Validation of page checksum if the database has the PAGE_VERIFY option set to CHECKSUM and the database page was last written by using checksum protection. When you use the CHECKSUM option during a backup operation, the following processes are enabled: These utilities and the associated TSQL stored procedures do not provide an option to include the CHECKSUM option during backup.

You might have to use Trace Flag 3023 when you use utilities such as SQL Server log shipping or the Backup database task from SQL Server maintenance plans. If you do this, you do not have to rewrite all the existing backup scripts. You can turn on Trace Flag 3023 to make sure that all backups use the backup CHECKSUM option. If Trace Flag 3023 is turned on, the CHECKSUM option is automatically enabled for the BACKUP command. If you are using backup applications or utilities that do not expose these options, you can enable the CHECKSUM option by using Trace Flag 3023 on the instance of Microsoft SQL Server. The Transact-SQL BACKUP and RESTORE commands provide the error-management options CHECKSUM and NO_CHECKSUM. SQL Server 2014 Enterprise SQL Server 2014 Enterprise SQL Server 2014 Developer SQL Server 2014 Developer SQL Server 2014 Express SQL Server 2014 Express SQL Server 2014 Standard SQL Server 2014 Standard SQL Server 2014 Web SQL Server 2014 Web SQL Server 2012 Enterprise SQL Server 2012 Developer SQL Server 2012 Express SQL Server 2012 Standard SQL Server 2012 Web SQL Server 2008 R2 Enterprise SQL Server 2008 R2 Developer SQL Server 2008 R2 Express SQL Server 2008 R2 Standard SQL Server 2008 R2 Workgroup SQL Server 2008 R2 Web SQL Server 2008 Enterprise SQL Server 2008 Developer SQL Server 2008 Express SQL Server 2008 Standard SQL Server 2008 Workgroup SQL Server 2008 Web Microsoft SQL Server 2005 Enterprise Edition Microsoft SQL Server 2005 Enterprise X64 Edition Microsoft SQL Server 2005 Compact Edition Microsoft SQL Server 2005 Developer Edition Microsoft SQL Server 2005 Evaluation Edition Microsoft SQL Server 2005 Express Edition Microsoft SQL Server 2005 Standard Edition Microsoft SQL Server 2005 Standard X64 Edition Microsoft SQL Server 2005 Workgroup Edition More.

Windows checksum command