Blog Archives

When was the last time i run dbcc checkdb with sucess

Good Morning Folks,

I am reading a good book for my 70-450 exam : SQL Server 2008 Administration in Action by Rod Colledge (Twitter|Blog), trust me this book is really good and is helping me to study to my next certification. So, going back to the subject, one of the chapters of his book is about DBCC commands, where he puts how can we see when was the last dbcc checkdb was executed with sucess. I’ll put below a code that can show you the date and time.

DBCC TRACEON (3604)
GO
DBCC PAGE(DBNAME,1,9,3)

after that you will see this input in the result of dbcc page.

dbi_dbccLastKnownGood

After your tests, don’t forget to disable the trace flag.

DBCC TRACEOFF (3604)

So, as you know i got this example from his book, and off course i need to thank him for this nice tip.

Regards,
Marcos Freccia