Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Running SQL Server Express 2005 here. We are creating several programs which run a backup on the database using Server Management Objects (SMO) mostly through C# (.NET). We have separate processes that will invoke the backup at different times.

Are there any issues with running two full backups at the same time if they are dumping the backup to different locations? The processes are pretty independent of each other and it would be a bit of work to synchronize them all.

share|improve this question
add comment

2 Answers

up vote 10 down vote accepted

Shouldn't be an issue, assuming your I/O subsystem can keep up. ("Different locations" may mean different things to different people - it's not just about drive letters.)

share|improve this answer
3  
Aaron is correct you can two full backup running at a time. However, you can't have two simultaneous log backups... one will wait other to complete. –  SQL Learner Oct 11 '12 at 16:42
    
+1 Just to supplement your answer, Aaron, a good resource is here on TechNet: technet.microsoft.com/en-us/library/ms189315(v=sql.90).aspx. –  Thomas Stringer Dec 5 '12 at 14:06
add comment

Also, starting with SQL Server 2005, it's possible to create concurrent log and full/differential backups

Just note that the inactive part of the log file in not cleared immedeatly after the log backup is completed, but after the full/differential backup is completed

Check out this Paul Randal's post: Search Engine Q&A #16: Concurrent log and full backups

share|improve this answer
add comment

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.