Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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?

share|improve this question
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 –  Yuck 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 –  Yuck Sep 22 '10 at 22:17

2 Answers 2

up vote 3 down vote accepted

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

share|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?

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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