SQL Server Page Verification CHECKSUM

What is PAGE_VERIFY in SQL Server?

PAGE_VERIFY is a database option that defines the mechanism used by SQL Server to verify page consistency when it is written or read from disk.

This reduces the potential of corrupting the database and as a good practice should be set to CHECKSUM.

How to identify the issue?

Since SQL Server 2005, Microsoft has implemented page verification CHECKSUM by default on the SQL Server Engine level.

You can check it on the Database Properties window on the Options page:

How to fix it?

You can choose it using the interface above, just change the property Page_Verify to CHECKSUM. Also, you may run the script below to generate the change script for all databases on the server.

Run the query below to generate the change script:

USE master GO

SELECT 'ALTER DATABASE ['   +  name  +   '] SET PAGE_VERIFY CHECKSUM  WITH NO_WAIT; '  Command_to_execute from sys.databases where page_verify_option_desc !=   'checksum';GO

The output the script will generate as an example:

ALTER DATABASE  [test]  SET PAGE_VERIFY CHECKSUM  WITH NO_WAIT;

ALTER DATABASE  [DBA]  SET PAGE_VERIFY CHECKSUM  WITH NO_WAIT;

More information

• Microsoft –  Set the PAGE_VERIFY Database Option to CHECKSUM