DBCC DBINFO For Finding CHECKDB Executions

Kevin Feasel

2017-01-04

DBCC

Arun Sirpal uses the DBCC DBINFO command to check the last time DBCC CHECKDB ran:

What about separate checks?

Again I dropped and re-created the database to get back to level playing field.

Let’s work through the DBCC check commands, after a command I will check dbi_dbccLastKnownGood to see if it gets updated.

Click through for details on when the dbccLastKnownGood value gets updated.

Related Posts

Duplicate Key Error On DBCC CLONEDATABASE

Erin Stellato shows an edge case when you have a rather old database you’re trying to clone: If you’ve been using DBCC CLONEDATABASE at all, you might have run into a cannot insert duplicate key error (or something similar) when trying to clone a database: Database cloning for ‘YourDatabase’ has started with target as ‘COPY_YourDatabase’. […]

Read More

Incorrect PFS Free Space

Dave Mason walks through troubleshooting one database corruption scenario: I’ve been lucky with database corruption during my career. I could probably count on one hand the number of times I’ve had to deal with it. A couple times, it was in a customer’s environment–they managed it themselves, but called me in to help. The other […]

Read More

Categories

January 2017
MTWTFSS
« Dec Feb »
 1
2345678
9101112131415
16171819202122
23242526272829
3031