SQL Backup process keeps trying to copy a file and I can't stop it
SQL_Dude Posts: 10 New member
in SQL Backup
We are using SQL Backup for Log Shipping. This morning it started sending messages that it was getting an error copying a file. One of the Transaction Log files it was trying to copy to the shared folder was already there. We have Log Shipping scheduled for every 15 minutes but were getting this error every 5 minutes. I manually removed the file from the source folder and then we started getting messages every 5 minutes that it could not copy the file because the source did not exist. I disabled the Log Shipping job but it continued to send this message every 5 minutes. Then I restarted SQL Backup on the server and it immediately started sending the message every 5 minutes again.
0 · Share on Twitter
EXEC master..sqbdata 'UPDATE backupfiles_copylist SET status = ''E'' WHERE name = ''<the backup file name>'' '