Sunday, February 19, 2012

Daily Backup of System Databases

I would like to know for daily backup of the system databases, is it suffice
if I just backup both Master and MSDB databases ?
For weekly backup, I have included the Master, MSDB and Model one.
Thanks
I think it would be easier and simpler to include also model on the daily
backup. Usually model is very small.
Ben Nevarez, MCDBA, OCP
"Jason" <Jason@.discussions.microsoft.com> wrote in message
news:ODldhbk8FHA.3416@.TK2MSFTNGP15.phx.gbl...
>I would like to know for daily backup of the system databases, is it
>suffice if I just backup both Master and MSDB databases ?
> For weekly backup, I have included the Master, MSDB and Model one.
> Thanks
>
|||Thank you for your advice.
I would like to know when do we change / customize the model database ?
Thanks
"Ben Nevarez" <bnevarez@.sjm.com> wrote in message
news:evUfWnk8FHA.3388@.TK2MSFTNGP11.phx.gbl...
> I think it would be easier and simpler to include also model on the daily
> backup. Usually model is very small.
> Ben Nevarez, MCDBA, OCP
>
> "Jason" <Jason@.discussions.microsoft.com> wrote in message
> news:ODldhbk8FHA.3416@.TK2MSFTNGP15.phx.gbl...
>

No comments:

Post a Comment