I have taken over SQL 2012 Server. I found 1 entry in msdb.dbo.suspect_pages table with last_update_date being "2012-04-06 21:13:46.257". The database this error is associated w/ is about 700GB. Checkdb physcial_only is executed every day except 3rd Sunday of the month (Full Checkdb). No errors has been reported during these checks.
I manually executed "DBCC CHECKDB (dbname) WITH all_errormsgs, no_infomsgs" and it returned "found 0 errors and repaired 0 errors. Elapsed time: 1 hours 54 minutes 24 seconds"
Here is the result for our most recent physcial_only results:
DBCC CHECKDB (dbname) WITH all_errormsgs, no_infomsgs, physical_only : found 0 errors and repaired 0 errors.
Is it safe to assume this is a very old error message and can be deleted? This is a production database that no one has completed about.
May 3, 2022 at 2:24 pm
Basically, it's a marker that something might be suspect, not that it is. So, you go and run a consistency check. If it finds something, there you go. If not, just go back and delete the entry. It was a false positive. No big thing.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 4, 2022 at 10:44 pm
This was removed by the editor as SPAM
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply