Thursday, May 10, 2018

Using DATABASEPROPERTYEX to Find the Last Good DBCC CHECKDB Time

DZone Database Zone
Using DATABASEPROPERTYEX to Find the Last Good DBCC CHECKDB Time
Using DATABASEPROPERTYEX to Find the Last Good DBCC CHECKDB Time

For decades, a pain point for SQL Server administrators has been determining when the last known DBCC CHECKDB was run against a database. Microsoft has not exposed this information in an easily digestible format. You can find a handful of options available online for returning this information. My favorite was this post by Rob Sewell.

It was my favorite.

No comments:

Fun With SQL: Functions in Postgres

DZone Database Zone Fun With SQL: Functions in Postgres In our previous  Fun with SQL  post on the  Citus Data  blog, we covered w...