Infinite copy loop
Here is the issue - I DO want the resilience feature.
But... I do not want a never-ending flood of copy failed messages if the backup file to copy has been removed. And I assert this is the bug in the product.
For example; I have a backup job set for a full backup. I make a copy to a local drive and I have a copy to the network share. If the backups made previously are over 5 days old, the file is removed. What appears to be happening, based on messages is that a file is not getting copied over the network (for some reason), and the retries are occuring over and over and over... indefinitely. Then 5 days downstream the local file is deleted, and now it can NEVER be copied to the network.
I'm sure you don't intend it to be that way, but that is what appears to be happening based on the copy failed messages I keep getting.
SQL Backup file copy process failed to copy "M:\LDF BACKUP\LOG_(local)_DBA_20100603_163000.sqb" to "\\whaley10\Backups\WFR-DailyBackups\Whaley08\LOG_(local)_DBA_20100603_163000.sqb"
Last attempt started on 6/4/2010 1:31:20 PM, and failed with the error "COPYTO error: Unable to copy M:\LDF BACKUP\LOG_(local)_DBA_20100603_163000.sqb to \\whaley10\Backups\WFR-DailyBackups\Whaley08\LOG_(local)_DBA_20100603_163000.sqb (Source file does not exist: M:\LDF BACKUP\LOG_(local)_DBA_20100603_163000.sqb).
61 attempts have already been made to copy this file.