5

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.

2 Answers 2

10

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.)

2
0

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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