DBCC CheckDB Last Known Good

 

This report provides an overview of the last known successful DBCC CHECKDB execution for each database on the SQL Server instance. DBCC CHECKDB is used to check the logical and physical integrity of a database.

Report Columns:

• Row – Sequential number assigned to each database in the report.
• Database – The name of the database being reported.
• When Checked – The most recent date and time when DBCC CHECKDB was successfully completed. If a database has never been checked, it will display “Never.”
• Size in MB – The size of the database in megabytes.

Understanding the Report:

• Databases with a recent DBCC CHECKDB date indicate that integrity checks have been performed.
• If a database shows “Never,” it means DBCC CHECKDB has not been recorded as running for that database.
• Double clicking a row in this report provides access to the CheckDB Advisor allowing easy access to the SQL Server DBCC CheckDB commands.

Recommended Actions:

• Regularly review this report to ensure all databases have been checked.
• Schedule DBCC CHECKDB as part of database maintenance to detect and address potential integrity issues.
• Investigate any databases that have not been checked recently to confirm they are included in scheduled maintenance tasks.