Set the PAGE_VERIFY Database Option to CHECKSUM

MSDN Library
Servers and Enterprise Development
SQL Server
SQL Server 2008
Product Documentation
SQL Server 2008 Books Online
Database Engine
Operations
Administration
Administering Servers by Using Policy-Based Management
Monitoring and Enforcing Best Practices by Using Policy-Based Management

Asymmetric Keys Encryption Strength
Authentication Mode
Backup Files Must Be on Separate Devices from the Database Files
Check Disk I/O Subsystem for I/O Delay Problems
Check Disk I/O Subsystem for Read Retry Problems
Check File Size and Growth for SQL Server 2000
Check Integrity of Database with Suspect Pages
Correct Affinity Mask and Affinity I/O Mask Overlap
Default Trace Log Files Disabled
Detect Failed I/O Request
Detect SCSI Host Adapter Issues
Device Driver Control Error
Device Not Ready Error
Disable Lightweight Pooling
Disable Updates for System Tables for SQL Server 2000
Disk Fragmentation Error
Guest Permissions on User Databases
I/O Error During Hard Page Fault
Increase or Disable Blocked Process Threshold
Keep the Affinity Mask Default Value
Keep the Locks Configuration Option Default Value
Network Packet Size Should Not Exceed 8060 Bytes
Outdated Backup
Place Data and Log Files on Separate Drives
Restrict CmdExec Rights to sysadmin
Server public Permissions
Set the AUTO_CLOSE Database Option to OFF
Set the AUTO_SHRINK Database Option to OFF
Set the Collation of User-defined Databases to Match Those of the master and model Databases
Set the Max Degree of Parallelism Option for Optimal Performance
Set the open objects Option to 0 for SQL Server 2000

SQL Server Login Password Expiration
SQL Server Login Password Strength
Storage System I/O Time-out
Symmetric Keys on System Databases
Symmetric Keys on User Databases
Trustworthy Bit
Unexpected System Failures
Use Database Mail Instead of SQL Mail
Verify Max Worker Threads Setting

Set the PAGE_VERIFY Database Option to CHECKSUM
SQL Server 2005

SQL Server 2008 Books Online (October 2009)

Set the PAGE_VERIFY Database Option to CHECKSUM

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.

Best Practices Recommendations

Set the PAGE_VERIFY database option to CHECKSUM.

For More Information

Setting Database Options