Sankar Reddy, SQL Server Developer/DBA

From SQL Server 2005 onwards, CHECKSUM is available as a PAGE_VERIFY option at the database level. All databases created in SQL Server 2005 & above will have CHECKSUM enabled by default. Even tempdb in SQL Server 2008 has this option enabled. It is recommended by MSFT to change the PAGE_VERIFY option of databases to CHECKSUM when migrating from . . . → Read More: Performance impact of using BACKUP CHECKSUM in SQL Server 2005/2008

Starting from SQL Server 2005, BACKUPS can be taken using CHECKSUM option. This option is going to be extremely valuable for error detection if you have set the PAGE_VERIFY database option either to CHECKSUM or TORN_PAGE_DETECTION. The CHECKSUM/TORN_PAGE_DETECTION value of the page is re-calculated and checked with the original value set on the page provided the page . . . → Read More: How to check if backups in SQL Server are taken using BACKUP CHECKSUM?