How to restore Diff and log backups to SQL server 2012 database
Posted on 2015-02-22
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.