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

Advertisements

About Marcos Freccia

MVP em SQL Server (Data Plataform) , especialista em SQL Server, e atualmente trabalhando com Microsoft Azure!

Posted on September 12, 2011, in Administração, DBCC, VirtualPass and tagged , , , . Bookmark the permalink. 2 Comments.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: