Torn Page Detection & CHECKSUM (SQL Server)

SQL SERVER DATABASE

Torn Page Detection

writes a bit for every 512 bytes in the page.  This allows you to detect when a page was not successfully written to disk, but does not tell you if the data stored in those 512 bytes is actually correct as a couple of bytes may have been written incorrectly.

Checksum

This will calculates a checksum value as the final thing before passing it to the IO system to be written to disk.This guarantees that SQL Server had no part in corruption in the page.  When SQL Server reads it back, if a single bit is corrupt, it will caught, and a checksum error (824) will be generated.