Posted by: bajara May 2, 2012
SQL server database restore question
Login in to Rate this Post:     0       ?        
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
Read Full Discussion Thread for this article