Sql-server – Run Two Full Backups on SQL Server 2005 at the Same Time

backupsmosql-server-2005

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.

Best Answer

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