I got strange delays when backed up a group of databases (20 more) in one scope (TSQL) to the same file location.
Is it possible that multiple backup operations are running at the same time? I have not found any "WAIT" operation in a BACKUP clause, but this option is present in SMO command (Wait) of Backup class.
Here is my partial code (full code works well, so I want to describe it as shown below):
WHILE 1 = 1 BEGIN SET @currentDbName = ... SET @sql = 'BACKUP DATABASE ' + @currentDbName + '...' EXEC(@sql) -- maybe it is a good place to wait? -- WAITFOR END