I am running SQL Server 2005 on a Windows 2003 Advanced Server machine.
It is a test set up with one running instance of SQL Server 2005 standard and Microsoft Test databases only. I am running SQL Server directly on the machine and the server\discs are not subject to any external load or network traffic.
I am running tests to compare different back up scenarios to find the optimum methodology (with speed in mind)
I am surprised that when I back up Adventureworks using 2 backup devices, each on a seperate local disk, the backup time is double that of a backup to a single device.
The microsoft documentation suggests that a parallel backup into two devices will halve the time required to complete the back up. This seems logical.
Can anyone explain to me why it is taking longer. Thanks. The code I used is attached.
BACKUP DATABASE AdventureWorks
TO AdventureWorks_F_6, AdventureWorks_F_7
WITH DESCRIPTION = 'Daily split disk full Backup of Adventureworks',
NAME = 'Adventureworks_F_200904171400'