March 29, 2010 at 11:21 pm
Hi Experts,
Is it possible to restore latest differential backup after restoring an old full backup?
March 29, 2010 at 11:23 pm
is the latest diff backup taken after old full backup????
March 29, 2010 at 11:54 pm
Ratheesh.K.Nair (3/29/2010)
Hi Experts,Is it possible to restore latest differential backup after restoring an old full backup?
if the full backup is most recent and diff backup was taken after this full backup then yes.
March 30, 2010 at 3:40 am
Ratheesh.K.Nair (3/29/2010)
Hi Experts,Is it possible to restore latest differential backup after restoring an old full backup?
No, unless the OLD backup is base for the differential backup.
You will get following error:
This differential backup cannot be restored because the database has not been restored to the correct earlier state.
March 30, 2010 at 4:51 am
If you have not performed any full backup in between Old full backup and latest differential backup than yes you will be able to perform the restore.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply