How many runs of 220.127.116.112 dbvalid.exe do I have to run, using which options, to perform the maximum amount of checking?
I am guessing two runs...
Further guesswork: The first run validates everything except checksums, and the second run does that.
-s causes a VALIDATE CHECKSUM to be executed which does a sequential scan of the entire database and validates the checksum on each page. If you're not using checksums on your pages, that's a lot of wasted work.
Checksums on pages are checked every time the page is read from disk so if you are doing a full validation (ie the default), you will generally visit every or very nearly every page anyways and doing a separate checksum validation should not be necessary.
answered 07 Oct '10, 17:09
FWIW, based on this question, I have made two comments on DCX (for SA 12 docs) w.r.t. dbvalid and the VALIDATE statements with backlinks to this question.
And reading the VALIDATE statements docs I had two more questions (taken from my comment there):
(Sorry for including more questions instead of an answer but they seem to be all part of the same general question.)
answered 11 Oct '10, 16:20