October 14, 2004 at 12:53 pm
I am modifying my current backup strategy to be more flexible and meet the needs of our different database systems in the best manner possible. In doing my work, I have had a question about the backups needed for system databases.
In my backup plan, some of my databases will only have nightly full backups, some will have full backups once a week with a differential backup on other days, while others will have full backups once a week, differential other days, and transaction log backups every hour.
What kind of backups are necessary for the system databases (except master since you can only do full backup anyway)? Is there really any need to do differential backups or transaction log backups?
Thanks for the feedback.
----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011
October 14, 2004 at 1:04 pm
msdb contains the history of you job execution among other things. If you are interested in keeping this up to date then I would back up msdb as often as master.
Model never changes (unless you put a change here you want in every new database you create) so you can use any schedule you like. It is so small I back it up daily anyway.
I run msdb and master backups daily as well.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply