Home / server / Questions / 209544
Accepted
Gabriel Guimarães
Asked: 2010-12-07 04:52:45 +0800 CST

SQL: Find Last Integrity Check Date

  • 772

Is there a way to check when was the last integrity check run for each database?

I know when the service startup it checks for these values, so they exist, and they are probably writen on the database header information.

By the way I would like an T-SQL solution.

sql-server data-integrity sql-server-2008-r2

2 Answers

  1. Best Answer

    You can get this information from the Boot Page of the database. i.e. Page ID 9. 

    DBCC TRACEON (3604)
GO
DBCC PAGE (DatabaseName, 1, 9, 3)
GO
    • 1

  2. When the SQL Server starts up, it reports the last DBCC CHECKDB date as an informational message. It is not running the command, just reporting.

    To see from T-SQL this execute this

    EXEC sp_readerrorlog 0, 1, 'CHECKDB'

    This procedure takes four parameters:

    1. Value of error log file you want to read: 0 = current, 1 = Archive #1, 2 = Archive #2, etc...
    2. Log file type: 1 or NULL = error log, 2 = SQL Agent log
    3. Search string 1: String one you want to search for
    4. Search string 2: String two you want to search for to further refine the results
    • 1