November 7, 2007 at 2:13 am
Hi all,
I have a problem when I try to restore differential backup. Server give me the massage "...no files are for rollforward...". What is wrong?
MP
November 7, 2007 at 2:37 am
Have you restored the last full backup first with norecovery?
hth
David
November 7, 2007 at 4:01 am
David Scotland (11/7/2007)
Have you restored the last full backup first with norecovery?hth
David
No, "with recovery".
So I must restore full backup with "no recovery" and next diff with "with norecovery" too but the last diff with "with recovery"?
MP
November 7, 2007 at 4:19 am
Marek Powichrowski (11/7/2007)
David Scotland (11/7/2007)
Have you restored the last full backup first with norecovery?hth
David
No, "with recovery".
So I must restore full backup with "no recovery" and next diff with "with norecovery" too but the last diff with "with recovery"?
MP
Yes you need to restore your last full backup with "NO RECOVERY" and then the last diff you want with "RECOVERY". Differential backups are since the last full backup so you only need to restore the most recent one you require. They are not cumulative.
hth
David
November 7, 2007 at 5:21 am
Thanks,
David
MP
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply