01/06/2026
Your CHECKDB timestamp is lying to you
And you don’t even know it
Most DBAs trust one field:
dbi_dbccLastKnownGood
Problem?
It often lags behind reality.
Especially when you manage:
Read-only databases
Availability Group secondaries
Filegroup level checks
Takeaway
Don’t rely on an inconsistent indicator to prove database health.
Better Framework
If you’re on 2016 SP2+:
Use: DATABASEPROPERTYEX('dbname','LastGoodCheckDbTime')
Query from any replica
Build alerts around this SUPPORTED property
Log results in a custom table
Supported beats undocumented. Always. https://www.stellarinfo.com/blog/how-to-repair-sql-database-using-dbcc-checkdb-command/
