November 13, 2008 at 12:23 pm
Hi,
I have stored procedure which backsup all the user databases. Its running as a job.
Now can we include the system databases to backup in the same job or do we need a separate job?
November 13, 2008 at 12:48 pm
Personally, a separate job for the system databases.
November 13, 2008 at 1:05 pm
If you include the system databases, be sure to put msdb at the end, because it contains all backup info.
We are using a single job for all our databases (daily) and another job to perform the log-backups (at least hourly).
Both jobs include (at the end) master and msdb.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
November 13, 2008 at 1:12 pm
I've gone both ways, but I have tended to separate out the system databases to a separate job.
November 13, 2008 at 1:15 pm
thank you..
Iam currently taking log backups for user databases only. How frequently do we need to schedule log backups for modl,msdb?
we can not take log backup for master database right?
November 13, 2008 at 11:51 pm
Frequency ? That's entirely up to you :w00t:
Most of the time, system databases are small, so what's the space impact of an extra backup.
Backup frequency of the model db ?
Do you actualy modify model db to do e.g. some initial (propriatary standards) security settings ?
If you don't, you'll do fine with just one backup.
If model db is being modified, I would suggest to put it in the normal backup cycle of your dbs.
As already stated, msdb contains the backup history information.
We always add a full backup of it to every backup job.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply