[2k] checkksum 옵션을 사용한 백업 및 복구

1. /**********************************************************************************************
   -- Title : [2k] checkksum 옵션을 사용한 백업 및 복구
   -- Reference : hanbitbook.co.kr
   -- Key word : with checksum
   **********************************************************************************************/
   USE master;
    
   --checksum 옵션을 사용한 백업
   BACKUP DATABASE AdventureWorks
   TO DISK = 'd:\adv.bak'
   MIRROR TO backupDevice1
   WITH INIT, FORMAT, CHECKSUM;
    
   --AdventureWorks 삭제
   USE master;
   DROP DATABASE AdventureWorks
    
   --복원
   RESTORE DATABASE AdventureWorks
   FROM backupDevice1 WITH CHECKSUM;