dbcc checktable will write in my dbcc page (x,9,3) for the field dbi_dbccLastKnownGood

Question

If I run DBCC CHECKALLOC,DBCC CHECKCATALOG and DBCC CHECKTABLE in all objects it will update my internal page with the actual date in dbi_dbccLastKnownGood field?

The main reason of the question is for a db with 14 TB and my window is short so I need lot of windows.

score 1 · Accepted Answer · edited Jan 22 '17 at 00:28

1

According to Erin Stellato's blog, What Checks Update dbccLastKnownGood?:

Breaking out the checks between the different commands does not update dbccLastKnownGood – running CHECKDB is the only thing that does

Erin also notes there that DBCC CHECKFILEGROUP and CHECKDB with the PHYSICAL_ONLY option will update dbccLastKnownGood.

edited Jan 22 '17 at 00:28

Paul White

94,921
30
437
687

answered Jan 20 '17 at 14:00

Scott Hodgin - Retired

24,062
2
29
52

dbcc checktable will write in my dbcc page (x,9,3) for the field dbi_dbccLastKnownGood

1 Answers1