Suspect ?? What's that?

One day, I found My Database 'Library' was Suspected". The Database can not work any more now.
Why? I have do something wrong? How to repair it?
The System Log told me : "Database 'Library' can not be opened - It has been marked SUSPECT by recovery. The SA can drop the database with DBCC"

... But I don't want to Drop the Database, I want it to work... How to Repair it? Use "DBCC Repair" ?

Oh, Why did it happened to me?
LVL 2
thresholdAsked:
Who is Participating?
 
Victor SpiridonovCommented:
Database was corrupted for some reason. Database is marked suspect, beacause SQL server is probably trying to recover it from transaction log. You can try the following : wait until it is recovered. (SEE Q170115 'How to troubleshoot long recovery on databases.) You can try resetting suspect status back to normal using 'sp_resetstatus' If it didn't help reset it back sp_marksuspect. IF you still can't use DB  you will have to DROP it and recreate from the last backup.
0
 
thresholdAuthor Commented:
Edited text of question
0
 
thresholdAuthor Commented:
I have use the DBCC to 'Repair' it, and found 'Repair' means 'Drop' in MS SQL.
Thank you, I will try your way in the next time.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.