June 3, 2004 at 10:30 am
I have a database marked 'suspect'. What options do I have? Thank You!
June 3, 2004 at 10:54 am
Below are some of the options
1) Try detaching and re-attaching the database and see if it helps.
2) put the database in emergency mode and script out all the data.
3) restore the database from the latest backup.
June 3, 2004 at 5:20 pm
Thank you very much for the input. I ended up restoring from backup.
June 4, 2004 at 4:51 am
FYI - there is a great article on this site by Brian Knight. It may save you a RESTORE next time. See here:
http://www.sqlservercentral.com/columnists/bknight/unmarksuspect.asp
Adam
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply