Archive for December, 2014

TSQL to get last good DBCC CHECKDB

This is a piece of code I use to determine the last known good DBCC CHECKDB being run against a database. I’m surprised this information is so tricky to find. I’d expect it to be sitting on the database properties tab right under last known full backup. but it’s not. Instead it is listed as a database Info property, and we need to jump through some hoops to find it.

Read More →