Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ian.caro
Starting Member
9 Posts |
 Posted - 2009-01-15 : 02:04:24
|
| Hi,Please help to resolve the issue. We have a database the container turn into Green and there's a open/close parenthesis that say's Suspected. I am new to SQL Server and I dont know what to do with our database.Regards,IAN |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-01-15 : 02:54:00
|
| Check the SQL error log. There will be entries in that that say why SQL has marked the database as suspect. It's almost impossible to suggest an appropriate fix without knowing the reasons first.Do you have a backup of this database?--Gail ShawSQL Server MVP |
 |
|
|
ian.caro
Starting Member
9 Posts |
Posted - 2009-01-15 : 03:15:02
|
| Hi Gail,Thanks for the reply, Yes we have a backup database but not to this date. Sorry I'm new to SQL how am i going to check the log for it?Regards,IAN |
|
|
|
|
|
|
Database Container is Green - Suspected Status