DBCC CheckDB Last Known Good

 

Do you know when DBCC CheckDB was last run against your database? The DBCC CheckDB Last Known Good report can show you when CheckDB was last run, or if it was ever run.

The chart below shows that many databases on this SQL Server have never had DBCC CheckDB run against them.

DBCC_CheckDB_LastKnownGoodTo get to the DBCC CheckDB Last Known Good report, right click on the instance name in the tree view, choose Instance Level Reports and select DBCC Last Known Good.

 


Enroll Today!
SteveStedman5
SteveStedman5
Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!

2 Comments on “DBCC CheckDB Last Known Good

  1. I do regular dbcc checkdb on all of my databases, but DB Health tool shows that some DBs are not checked for months?! is that en error?

    • This report shows the last time that CheckDB succeeded. It is possible that if after DBCC CheckDB that this report doesn’t show the latest date, it may be in indication that the database is corrupt, and DBCC CheckDB is throwing errors.

      On the databases that are showing as not checked for months, try manually running checkDB and review the output.

      -Steve Stedman

Leave a Reply

Your email address will not be published. Required fields are marked *

*

To prove you are not a robot: *