yadavdep
asked on
How to restore Diff and log backups to SQL server 2012 database
I had setup a Maintenance plan for my database as given below
1. Weekly FULL backup
2. Daily DIFF backup
3. LOG backup every 10 min
Now, client wants me to give some records which he by mistake overwritten using the application into the database.
He did this on Feb 20
Now, I have had restored the full backup dated Feb 15 to my local server.
And I am not able to restore the the differential or log backups I have for Feb 20 on this Database.
On the restore screen I am getting this error when I select either the differential or log backup
"unable to create restore plan due to break in the lsn chain".
I am not sure how to restore the differential or log backups.
Need help here.
1. Weekly FULL backup
2. Daily DIFF backup
3. LOG backup every 10 min
Now, client wants me to give some records which he by mistake overwritten using the application into the database.
He did this on Feb 20
Now, I have had restored the full backup dated Feb 15 to my local server.
And I am not able to restore the the differential or log backups I have for Feb 20 on this Database.
On the restore screen I am getting this error when I select either the differential or log backup
"unable to create restore plan due to break in the lsn chain".
I am not sure how to restore the differential or log backups.
Need help here.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi Vitor,
At the first place I did not do what you said in your comment, but after doing some Google then I came to know that I need to chose No_Recovery option.
At the first place I did not do what you said in your comment, but after doing some Google then I came to know that I need to chose No_Recovery option.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
It's working now?
ASKER
yes Vitor it works now,
thanks every one for your help
thanks every one for your help
Open in new window