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