Comments (4)

  1. We have taken 1 Full backup and 4 ( 1, 2 3, 4 ) Differential Backup, so which differential backup should be taken for recovery.

    1. You mean to restore the database? If you want to restore it to the most recent point possible, then restore the full backup with norecovery followed by the most recent differential (#4). If you have log files to recover too, be sure to use norecovery for the restore of the differential file and then restore the log backups created since the differential was created.

Leave a Reply to Day 26 of 31 Days of Disaster Recovery: The Mysterious Case of the Long Backup | SQLSoldierCancel reply