For security reason I always took back up of my database. I took full backup in each month. And differential in each week. I used to save each back up file in different name. I lost my latest full back up file. But I have my latest differential back up file. So when I tried to restore my differential back up with the previous full back up , I am getting an error that
This differential backup cannot be restored because the database has not been restored to the correct earlier state
- Took Full Backup - File is with me
- Took Differential - File is with me
- Took Another full - Lost this file
- Differential file - is with me
So can I restore 4th one with 1st one. With out the 3rd ?
Is there any solution for this scenario? Can I restore it without losing data?
I am using SQL Server 2008 R2