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.
💡 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
Set the PAGE_VERIFY Database Option to CHECKSUM | Microsoft Docs