SQL Server records the date/time of the most recent database consistency check with no errors

Article translations Article translations
Close Close
Article ID: 2033590 - View products that this article applies to.
Expand all | Collapse all

SUMMARY

SQL Server records the date and time when a consistency check was run for a database with no errors (or "clean" consistency check). This is known as the last known clean check. When a database is first started, this date is written to the EventLog (EventID-17573) and ERRORLOG like the following:

CHECKDB for database '<database>r' finished without errors on 2010-05-05 18:08:22.803 (local time). This is an informational message only; no user action is required.

MORE INFORMATION

For more information about the products or tools that automatically check for this condition on your instance of SQL Server and on the versions of the SQL Server product, see the following table:

Collapse this tableExpand this table
Rule software

Rule title

Rule description

Product versions against which the rule is evaluated
SQL Server 2008 R2 Best Practice Analyzer (SQL Server 2008 R2 BPA)







Database consistency check not current







The SQL Server 2008 R2 Best Practice Analyzer (SQL Server 2008 R2 BPA) provides a rule to detect if a database has not had a "clean" consistency check within the last 14 days or not since being created. The SQL Server 2008 R2 BPA supports both SQL Server 2008 and SQL Server 2008 R2.

If you run the BPA tool and encounter a Warning with the title of Engine - Database consistency check not current, then a database (excluding tempdb) has not had a "clean" consistency check run within the last 14 days or has not had a "clean" consistency check since it was first created.
SQL Server 2008
SQL Server 2008 R2









SQL Server 2012 Best Practice Analyzer (SQL Server 2012 BPA)




Database consistency check not current




The SQL Server 2012 Best Practice Analyzer (SQL Server 2012 BPA) provides a rule to detect if a database has not had a "clean" consistency check since the database was created.

If you run the BPA tool and encounter a Warning with the title of Engine - Database consistency check not current, then a database (excluding tempdb) has not had a "clean" consistency check run since it was first created.
SQL Server 2012








Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.

Properties

Article ID: 2033590 - Last Review: April 3, 2012 - Revision: 2.0
APPLIES TO
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Enterprise X64 Edition
  • Microsoft SQL Server 2005 Express Edition
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Standard X64 Edition
  • Microsoft SQL Server 2005 Workgroup Edition
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Express
  • Microsoft SQL Server 2008 Express with Advanced Services
  • Microsoft SQL Server 2008 R2 Datacenter
  • Microsoft SQL Server 2008 R2 Developer
  • Microsoft SQL Server 2008 R2 Enterprise
  • Microsoft SQL Server 2008 R2 Express
  • Microsoft SQL Server 2008 R2 Express with Advanced Services
Keywords: 
KB2033590

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com