Page Verification Option

When SQL Server writes data to a page, it can either assume the data was written correctly or test to make sure it was valid. Having the page verification options set to CHECKSUM provides an efficient way to perform the check.

CHECKSUM is the default for new databases but is often set to TORN_PAGE when databases have been restored from older versions of SQL Server.

Suggested Action

💡 Select 'Suggested Script' for an automatically generated script.

Set the page verify option to CHECKSUM.

How to Set the PAGE_VERIFY Database Option to CHECKSUM

USE [master]
GO
ALTER DATABASE [WhippetWorks] SET PAGE_VERIFY CHECKSUM  WITH NO_WAIT;
GO

Further Reading

Set the PAGE_VERIFY Database Option to CHECKSUM | Microsoft Docs