Set the PAGE_VERIFY Database Option to CHECKSUM

Applies to: yesSQL Server (all supported versions)

This rule checks whether PAGE_VERIFY database option is set to CHECKSUM. When CHECKSUM is enabled for the PAGE_VERIFY database option, the SQL Server Database Engine calculates a checksum over the contents of the whole page, and stores the value in the page header when a page is written to disk. When the page is read from disk, the checksum is recomputed and compared to the checksum value that is stored in the page header. This helps provide a high level of data-file integrity. If you use the PAGE VERIFY CHECKSUM option for a database, when SQL Server detects a page has been altered after it has been written to disk, SQL Server reports Msg 824 after reading the page back from disk.

Best Practices Recommendations

Set the PAGE_VERIFY database option to CHECKSUM. Using the PAGE_VERIFY CHECKSUM database option can provide the most robust detection of database consistency problems caused by the system I/O path.

For More Information

ALTER DATABASE SET Options (Transact-SQL)