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!!
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
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.