mercredi 4 mars 2015

DataBase BackUp issue in SQLServer


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"


My Scenario



  1. Took Full Backup - File is with me

  2. Took Differential - File is with me

  3. Took Another full - Lost this file

  4. 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 loosing data?


I am using SQL Server 2008 R2





Aucun commentaire:

Enregistrer un commentaire