September 20, 2013 at 8:21 am
Hi all,
Took Full backup
created Table1
Took Tran Log backup
Created Table2
Took Diff backup
Created Table 3
Took Tran backup
Now I am creating another database using above.
how can I restore all 3 backups, can somebody write steps Please in details.
Because I can restore fullback up (creating another db) no recovery, could apply 1st tran backup with no recovry but when it comes to apply differential backup, it wont let me do it.
September 23, 2013 at 9:29 am
You can't restore a differential after restoring a log backup. The order of restores must be:
1. Restore full backup
2. Restore differential backup
3. Restore log backup
So, in your case, if you wanted to create a new database with both tables, you'd restore the full backup with no recovery, then the differential backup with no recovery, then the second log backup with recovery.
Greg
September 23, 2013 at 12:57 pm
Greg Charles (9/23/2013)
You can't restore a differential after restoring a log backup. The order of restores must be:1. Restore full backup
2. Restore differential backup
3. Restore log backup
So, in your case, if you wanted to create a new database with both tables, you'd restore the full backup with no recovery, then the differential backup with no recovery, then the second log backup with recovery.
Or - restore the full backup, the first and second log backups. No need for the differential backup in this scenario.
Note: the only reason to use differentials is to reduce the number of files being restored or allow for not performing a full backup every night (e.g. weekly full, daily differentials - frequent log backups).
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply