This question is an exact duplicate of:
There is a SQL Server 2012 database that has the following configurations
- Recovery mode : Simple
- 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
- Restore the latest full backup, or
- Restore the latest full backup, then restore the latest differential backup