​The database PAGE_VERIFY CHECKSUM option can help detect database consistency problems with the system I/O path

Se aplica a: Microsoft SQL Server 2005 Developer EditionMicrosoft SQL Server 2005 Enterprise EditionMicrosoft SQL Server 2005 Enterprise X64 Edition

Summary


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

More Information


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. For more information about how to troubleshoot Msg 824, see the article:

How to troubleshoot Msg 824 in SQL Server

For more information on the details on how SQL Server implements checksum on database pages, see the whitepaper SQL Server I/O Basics, Chapter 2.

For more information about the products or tools that automatically check for this condition on your instance of SQL Server and on the versions of the SQL Server product, see the following table:
Rule software

Rule title

Rule description

Product versions against which the rule is evaluated
SQL Server 2008 R2 Best Practice Analyzer (SQL Server 2008 R2 BPA)




Databases exist without CHECKSUM protection




The SQL Server 2008 R2 Best Practice Analyzer (SQL Server 2008 R2 BPA) provides a rule to detect if a database is not using the PAGE_VERIFY CHECKSUM option. The SQL Server 2008 R2 BPA supports both SQL Server 2008 and SQL Server 2008 R2.

If you run the BPA tool and encounter a Warning with the title of Engine -Databases exist without CHECKSUM protection, then you have a database that is not configured to use the PAGE_VERIFY CHECKSUM option.
SQL Server 2008
SQL Server 2008 R2






SQL Server 2012 Best Practice Analyzer (SQL Server 2012 BPA)




Databases exist without CHECKSUM protection



The SQL Server 2012 Best Practice Analyzer (SQL Server 2012 BPA) provides a rule to detect if a database is not using the PAGE_VERIFY CHECKSUM option.

If you run the BPA tool and encounter a Warning with the title of Engine -Databases exist without CHECKSUM protection, then you have a database that is not configured to use the PAGE_VERIFY CHECKSUM option.
SQL Server 2012