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

Your email address will not be published. Required fields are marked *