Home / server / Questions / 183789
Accepted
Alex Gordon
Asked: 2010-09-23 13:56:50 +0800 CST

sql server backups: should i set them to run at the same time?

  • 772

i have several databases that need to be backed up

should i set the backup times the same? is there a good/bad way to do this?

i am concerned that since they are going to be backing up at the same time they will consume too many resources?? what is the best way to time database back ups?

sql-server backup

2 Answers

  1. Best Answer

    With databases that small you can back them up at the same time without issue.

    • 3

  2. When you say run them at the same time you mean you have some t-sql task that does the following:

    backup database master to disk=...
...
backup database Adventureworks to disk=...

    This isn't exactly 'at the same time' the commands are synchronous so the backup for master will complete before the backup for adventureworks starts.

    If you really want them to run all at the same time, then you can create seperate SQL Agent Jobs to all go off at the same time, but why would you want to do that?

    • 2