locked
DBCC CHECKDB checks CHECKSUM even if Page Verify = NONE? RRS feed

  • Question

  • Page verify is an option you can define on a database.

    SQL 2000: NONE or TORN_PAGE_DETECTION

    SQL2005+: NONE, TORN_PAGE_DETECTION or CHECKSUM

    I have read a lot about it and understand that CHECKSUM is recommended, and that it doesn't automatically gets turned on when migrating databases from SQL 2000. And even if I turn it on, the pages won't be set with checksum until it is read into the buffer pool, modified, and written back to disk again.

    My question:

    If I don't have "Page Verify: CHECKSUM" enabled on my database, will it not be checked if I run DBCC CHECKDB? Or will DBCC CHECKDB calculate its own checksum temporarily on the fly somehow??

    We have some databases which does not have checksum enabled, and I'm afraid we might have undetected corruptions even though we run DBCC CHECKDB periodically?

    Thursday, December 13, 2012 8:02 AM

Answers

All replies