Backup WITH CHECKSUM
When WITH CHECKSUM option is used while taking backup, the backup process will verify each page for checksums and torn page. In case bad page checksum found, the backup will stop. Using backup checksums may affect workload and backup throughput.
If you want to continue the backup, you have to write CONTINUE_AFTER_ERROR in backup WITH clause.
In case backup completes successfully it means no bad checksums.
backup database sqldba to disk = 'c:\jspace\sqldba1.bak' with checksum
You can also use the 3023 trace flag for the check sum option, when 3023 trace flag is on WITH CHECKSUM option will be applied all the backups by default.
DBCC TRACEON(3023) GO backup database sqldba to disk = 'c:\jspace\sqldbatraceflag.bak' DBCC TRACEOFF(3023) GO
Let’s check if the 3023 trace flag applied the page checksum to above backup command or not. Execute below query for it.
RESTORE HEADERONLY FROM DISK = 'c:\jspace\sqldbatraceflag.bak' GO