Better to backup up all server databases or backup system databases separately from databases?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Spin - 30 Mar 2008 20:08 GMT

Gurus,

Running SQL Server 2005 SP2 and using named instances. I am having lots of
important application databases on my server these days. My question is
this. Is it better to back up all server databases in one maintenance plan
or backup system databases separately from databases?

Signature

Spin

Reply to this Message

Linchi Shea - 31 Mar 2008 01:26 GMT

I don't think it matters one way or another. But then it depends on what
issues you may be struggling with.

If you have scheduling issues running a single maintenance plan, break it up
into multiple plans. Personally, I prefer dealing system databases
separately. In particular, when you are dealing relatively large user
databases, you may not want to use the MS maintenance plans and may choose to
schedule their backups in your own schduler for better flexibility.

Linchi

Linchi

> Gurus,
>
> Running SQL Server 2005 SP2 and using named instances. I am having lots of
> important application databases on my server these days. My question is
> this. Is it better to back up all server databases in one maintenance plan
> or backup system databases separately from databases?

Reply to this Message