October 4, 2008 at 2:44 am
Hi ,
I have the backup of database newdb .
1) Full Database Backup(newdbfull.bak)
2) Differenitail Backup (newdbdiff.bak)
3) Log Backup (newdblog.bak)
my question is why should not i restore log backup instead of diffrentila backup after full database backup restore ?
like..
1) Restore full databse backup with norecovery
2) restore log backup with recovery .
is there any specific reason should i restore the database in the following order ...
1) Restore full databaes with norecovery
2) restore differential with norecovery
3) restore log backup with recovry
October 4, 2008 at 12:50 pm
In the circumstances you describe with just one diff backup and one log backup, there is no reason at all why you should not just restore the full backup then the log backup, indeed that would be the sensible thing to do.
Where the differential backup would be useful is if you had a lot of tran log backups between the full backup and the diff backup, then you could save a lot of time by restoring the full backup, go straight to the diff backup, and just restore any log backups after the diff.
The point is a diff backup does not break a log backup chain, so can be ignored in a chain of log restores, but gives a marker in the log where you can start a log restore chain from (having first done a full restore)
See BOL on this and give it a go yourself on a test database.
---------------------------------------------------------------------
October 5, 2008 at 4:16 am
Thanks for your reply....
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply