May 14, 2009 at 8:55 am
I want to make sure I understand this correctly. If you do not use PAGE VERIFY options like CHECKSUM are there situations where DBCC CHECKDB will not catch something when it's executed. I'm trying to make sure I understand the relationship between the two.
May 14, 2009 at 9:12 am
Yes. Imagine a single bit corruption in the middle of a varchar column. Without a page checksum, nothing will detect the corruption.
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
May 14, 2009 at 9:20 am
Thank you very much for your insight - I appreciate it!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply