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.

Ken Richards
  • 278
  • 3
  • 7

2 Answers2

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

Aaron Bertrand
  • 181,950
  • 28
  • 405
  • 624
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

Carol Baker West
  • 1,616
  • 14
  • 13