Login or Sign Up to become a member!
LessThanDot Site Logo

LessThanDot

Community Wiki

Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.

LTD Social Sitings

Lessthandot twitter Lessthandot Linkedin Lessthandot facebook Lessthandot rss

Note: Watch for social icons on posts by your favorite authors to follow their postings on these and other social sites.

Navigation

Google Ads

When did DBCC CHECKDB last run to completion?

From Wiki

Jump to: navigation, search

How can you find out when DBCC CHECKDB last ran to completion? Before we answer that, first you need to know that if DBCC CHECKDB runs and it reports errors or no errors then this is considered a successful run. So now I will run the following DBCC CHECKDB command

  1. DBCC CHECKDB ('AdventureWorksDW2008')

In SQL Server and up you can use DBCC DBINFO to find the last successful run of DBCC CHECKDB. You need to look in the field column dbi_dbccLastKnownGood, the value column will have the date. So if I run DBCC DBINFO like this

  1. DBCC DBINFO ('AdventureWorksDW2008') WITH TABLERESULTS


Then here is my partial output, in my case I am interested in output row 17

ParentObject		Object				Field			VALUE
DBINFO STRUCTURE:	DBINFO @0x000000000E94E5E0	dbi_dbccLastKnownGood	2010-05-13 20:52:16.480



Contributed by: --SQLDenis 01:25, 14 May 2010 (GMT)

Part of SQL Server Admin Hacks

773 Rating: 2.6/5 (46 votes cast)