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?

  • 1
    How big are they? What version of SQL Server are you running? What hardware are you running on? It all depends on these questions. – user3914 Sep 22 '10 at 22:03
  • Additionally to Ralph's questions: How many databases are you talking about, are they all on the same server and really what I'm most interested in is what are you using to do the backups? – Dave Holland Sep 22 '10 at 22:15
  • im talking about 3 databases, one is 3 gigs they others are like 10mb – l--''''''---------'''''''''''' Sep 22 '10 at 22:16
  • using sql server 2008, i dont know what harder they are writing to, but the system is 10g ram, 64bit windows 7 or something – l--''''''---------'''''''''''' Sep 22 '10 at 22:17

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

| improve this answer | |

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?

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.