How to stop messages

paulus_999

Hi There

I made a mistake last night. I deleted the backup of a transaction log before it could be copied to the network site and now the system is giving me messages every few minutes such as the following.


SQL Backup file copy process failed to copy "D:\SQLBACKUP\SQL02\ReportServer\20111003_170010_LOG.sqb" to "\\LMS32VS02\SQL BACKUPS\SQL02\ReportServer\20111003_170010_LOG.sqb"

Last attempt started on 04/10/2011 09:45:11, and failed with the error "COPYTO error: Unable to copy \SQLBACKUP\SQL02\ReportServer\20111003_170010_LOG.sqb to \\LMS32VS02\SQL BACKUPS\SQL02\ReportServer\20111003_170010_LOG.sqb (Source file does not exist: \SQLBACKUP\SQL02\ReportServer\20111003_170010_LOG.sqb).
"

996 attempts have already been made to copy this file.

How do I stop them please

petey

Try this:

EXEC master..sqbdata 'UPDATE backupfiles_copylist SET status = ''C'' WHERE name = ''D:\SQLBACKUP\SQL02\ReportServer\20111003_170010_LOG.sqb'''

Check to see if the record has been updated:

EXEC master..sqbdata 'SELECT status FROM backupfiles_copylist WHERE name = ''D:\SQLBACKUP\SQL02\ReportServer\20111003_170010_LOG.sqb'''

paulus_999

Thanks very much for this.

It worked with a small change. there was more than 1 file involved so I changed it to say where Count > 500

:lol: