How to find the last good known checkDB date?
Starting with SQL Server 2016 SP2, we have DATABASEPROPERTYEX (‘dbname’ , ‘LastGoodCheckDbTime’ )
In SQL Server 2017, CU14 ( I tested it) , this is also working.
Like so:
SELECT DATABASEPROPERTYEX (‘db_workspace’ , ‘LastGoodCheckDbTime’ )
or
SELECT DATABASEPROPERTYEX (d.name , ‘LastGoodCheckDbTime’ )
FROM sys.databases as d
Value of `1900-01-01 00:00:00.000` means – no check db was run.
Please, see here more info
S
Sql Server 