Monday, March 26, 2012

No Differential Backup on Master DB

Hi, Can someone plzz explain the below reason
"Differential backups are not allowed for the master database since
they require that complete backups be applied without recovery as the
first step. When restoring the master database, restore without
recovery is not allowed."Hi
If you look in BOL on how Master DB needs to be restored, you will notice
that it is not an easy procedure.
If Master DB gets bigger than a manageable size (say 100Mb), then you have a
serious problem. You have user objects in there and you are compromising
your recoverability of your server.
A small DB like Master needs no differential backups and not much changes in
it, and it is so quick to do a full backup, that it is not worth the effort.
Regards-
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"sasiraj" <vardhansasi@.gmail.com> wrote in message
news:1131737977.922320.82800@.g14g2000cwa.googlegroups.com...
> Hi, Can someone plzz explain the below reason
> "Differential backups are not allowed for the master database since
> they require that complete backups be applied without recovery as the
> first step. When restoring the master database, restore without
> recovery is not allowed."
>sql

No comments:

Post a Comment