Obsolete Page Verify Option

Obsolete Page Verify Option

Recommendation

It is recommended to use CHECKSUM for your database Page Verify Option.  The options TORN_PAGE_DETECTION is obsolete.

Example Code

The following T-SQL can be used to check for the page_verify_option for all the databases on your SQL Server instance.


SELECT page_verify_option_desc as Verify, name
 FROM sys.databases
WHERE page_verify_option_desc <> 'CHECKSUM';

How Do We Fix it?

This can be fixed using the SSMS user interface by right clicking on the database in the object explorer, choosing properties, then clicking the options page in the Properties dialog.  From there scroll down to the recovery page and change the setting to CHECKSUM then clicking OK.

CHECKSUM

Another option is to change the setting with T-SQL.


ALTER DATABASE databaseName SET PAGE_VERIFY CHECKSUM;

Replace databaseName with the name of your database.


Enroll Today!
SteveStedman5
SteveStedman5
Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!

2 Comments on “Obsolete Page Verify Option

Leave a Reply

Your email address will not be published. Required fields are marked *

*

To prove you are not a robot: *