Backup WITH CHECKSUM

calendar 2012-03-09 · 1 perc olvasás · SQL SQL Server MCM  ·
Megosztás: linkedin copy

I’m attending on the Quickstart’s SQL Server 2008 Microsoft Certified Master (MCM) Accelerated Exam Preparation Program and a question came up yesterday: Can we use the WITH CHECKSUM with transaction log backups? The answer is pretty simple: yes, we can.

Here is a sample script for evidence 😀:

 1USE [master];
 2GO
 3BACKUP DATABASE [AdventureWorks2012] TO DISK='c:\DbBackups\AW2012\aw2012full.bak' WITH INIT, CHECKSUM;
 4GO
 5BACKUP LOG [AdventureWorks2012] TO DISK='c:\DbBackups\AW2012\aw2012tr.bak' WITH INIT, CHECKSUM;
 6GO
 7RESTORE HEADERONLY FROM DISK='c:\DbBackups\AW2012\aw2012full.bak';
 8--HasBackupChecksum column is 1, we have checksum :)
 9GO
10RESTORE HEADERONLY FROM DISK='c:\DbBackups\AW2012\aw2012tr.bak';
11--HasBackupChecksum column is 1, we have checksum for log backup as well:)
12GO