I have a full backup running at 1am (FullbackupA), then a seperate backup exec does another full backup at 2am (FullbackupB, I have my differential at 8am (DiffBackupC). When I try to restore to my differential ( restore FullBackupA and then DiffBackupC), it doesnt work because there is another full backup (FullbackupB) taken at 2am, so the chain is broken. I dont have the .bak file for the one taken at 2am, but i do have .ldf, .mdf files. Is there any way I can restore to my differential at 8am, from 2am (FullBackUpB)? since i dont have .bak file? Can i use my .ldf, .mdf file to restore? Thanks for help
bajara · May 2, 2012 8:29 PM · 10,072 views
Answer is no. If you lost your differential base (your 2 am full backup), then the only backup you can restore is the one you took at 1:00 am. Using your mdf, ldf files you can only do an attach not restore.
mero_desh · May 2, 2012 11:56 PM
You can re-attach the mdf and ldf to another database (Detach them first). What is this for? It is your local SQL instance correct?
gone12 · May 3, 2012 10:01 AM
Gonez, Yes I can attach the 2am using my mdf and ldf. But I want to restore to 8am differential. But to use differential, i will need to restore from .bak file (2am) which I do not have .Than you mero_desh. Thats what i thought too
bajara · May 3, 2012 12:38 PM
This conversation is preserved exactly as it was on the original Sajha.com and can't accept new replies.
Start a New Discussion