Corruption Series: #2 Page Verification
SQL Server corruption usually happens when a data page is written to disk and the disk subsystem doesn’t write what SQL Server expects. Or it does write what is expected, but somehow changes it before the next write. As one can imagine, this should really never happen. But once is a great while it does. This post will show how page verification can help determine there is corruption before a DBCC CheckDB finds it. This early warning system can be very effective. What is Page Verification? Page verification is a process in SQL Server where the engine writes extra data to the header of theRead More →