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 |
|
pmccann1
Posting Yak Master
107 Posts |
 Posted - 2007-02-21 : 05:13:06
|
| One of my databses is saying suspect beside it can this be fixed |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-02-21 : 06:15:44
|
| It is possible to change the Flag, however that's a bit pointless if the reason it is Suspect is because its broken!Your best route is to Restore the database from backup, but it is possible that your Backup may be corrupted.(You may want to restore the Backup to a new, temporary database first, and check that the restored version is OK before you risk restoring over your Suspect database)Kristen |
 |
|
|
|
|
|
Suspect DB