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

šŸ’” Aireforge Advisor can automatically generate a script for this.

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