corruption

We left off the last post with 2 equally corrupted databases. One database had page checksums enabled and the other did not. We learned that upon reading the corrupt page, the checksum was recalculated, compared, and if unmatched, threw an exception. But what if the page that was corrupted isn’t read for a period of time? Maybe the page that has been corrupted is part of an older record that isn’t often read. Certainly a DBCC CheckDB command will find it, but we want to find out even sooner. It turns out the page checksums are again able to help us as we can askRead More →