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;
신고

+ Recent posts