This question is an exact duplicate of:

There is a SQL Server 2012 database that has the following configurations

  1. Recovery mode : Simple
  2. Backup Schedule : Full backup at 01:00 hours daily as well as differential database backup 13:00 hours daily

Once the differential backup of this database failed at 14:00 hours, the database then failed.

I need to restore this database and ensure the data loss is minimal.

Shall I choose

  1. Restore the latest full backup, or
  2. Restore the latest full backup, then restore the latest differential backup

marked as duplicate by Aaron Bertrand Sep 22 '15 at 13:10

This question was marked as an exact duplicate of an existing question.

migrated from stackoverflow.com Sep 22 '15 at 12:07

This question came from our site for professional and enthusiast programmers.


Restore the latest full backup (using the with norecovery option) and the last good differential.


Okay, so since differential backup failed at 14:00, there is no latest differential backup file available. Therefore, the only sensible choice is Full Db Backup.

Not the answer you're looking for? Browse other questions tagged or ask your own question.