October 7, 2005 at 11:00 am
Confused completely. I 've done this some times before, I mean restore database from full backup with no recovery (and moving files, but actually it's not important as I restore DB with new name) and then restore from dif backup with recovery. But now I've got an error "Cannot apply the backup on device ..". during dif restore step (full- OK). Full backup was made on last Sunday, last dif backup- today morning (every day I create new dif backup file). What can be the reason for this error? Thanks
October 7, 2005 at 1:39 pm
It sounds like you are trying to RESTORE Fullbackup, then a DIFF backup and then another DIFF backup. You can only restore one Differential to a Full backup. Since the diff is everything that has changed since the last full backup, each diff is the same as the one before plus it has the latest changes added.
Also, are you sure you are restoring the full backup with NO RECOVERY?
-SQLBill
October 7, 2005 at 2:37 pm
No, I try to restore only 1 Diff back (after Full one that succededed). Yes, I restored Full backup with No Recovery (as DB has loading status)
Thanks
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply