2

I have this question. If database goes into "Suspect Mode" but when I check it in "Emergency Mode" with the "DBCC CHECKDB" command, the result is successful. It means that the data page files are correct or maybe some of them are damaged? Thanks in advance!!

1 Answer 1

4

Pages that caused the database to be marked suspect may no longer matter - for example, if they have been deallocated.

You can determine whether this is the case by checking the event_type column of msdb.dbo.suspect_pages.

You may also want to look through the SQL error log for any relevant messages.

If everything is ok (and you have verified that recent backups are available and not about to be deleted, just in case) you can go through repair.

You may also want to turn on checksum page verification if it is not currently set.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.