Can anyone please point me to a piece of documentation that suggest how many concurrent backups initiated by different BACKUP statements are possible in Microsoft SQL server 2008?
The documentation suggests that you can specify up to 64 different backup devices in one statement, but I have noticed today that SQL server was not treating my BACKUP statement while the one initiated by SQL Server Agent was running.
I have been closely observing the Performance Monitor and could tell that at one time only one .bak file was being written to.
Another proof of that would be a screenshot I have with SQL Management Studio query running time being 15 minutes, and the actual query result stating:
BACKUP DATABASE successfully processed 3422697 pages in 389.656 seconds (68.624 MB/sec).
So, how many simultaneous backups is SQLServer meant to handle (if any)?