Copy Queue Table For Full/Differential Backups?

Forum for users of Redgate's SQL Backup tool

Copy Queue Table For Full/Differential Backups?

Postby MattS » Mon Mar 26, 2012 10:37 am


I understand that when SQL backups are copied from the local directory to a network directory they are queued in the [backupfiles_copylist] table.

However, the only records that appear to be in this table are for LOG file backups - are you able to confirm where I can find the records relating to FULL and Differential backups that have been copied over?

Many thanks.
Posts: 18
Joined: Tue Sep 20, 2011 11:35 am

Postby eddie davis » Mon Mar 26, 2012 2:16 pm

Hi MattS

The Log Copy Queue is only used for Transaction Log Backup jobs.

When you perform a Full or Diff backup using the COPYTO keyword, the copy process is perfromed within the backup job and as a retry count as set by the DISKRETRYINTERVAL and DISKRETRYCOUNT keywords, by default is upto and including 10 attempts every 30 seconds. To check the success of the copying process you need to view the SQL Backup log file for that job. In the SQL Backup GUI ->Activity History tab may have a warning triangle to indicate that the backup was successful with warnings.

To help with a Log Shipping setups, Transaction Log Backups using the COPYTO keyword, the copying process differs. The copying process is perfromed outside of the log backup job. When the Log backup completes successfully, the job ends and an entry is placed into the Log Copy Queue. The SQL Backup Agent Service checks the Log Copy Queue and attempts to copy the log backup file to the configured network share. The retry attempts will take place for a 24 hour period. This SQL Backup help article contains further information.

I hope this answers your question.

Many Thanks
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
eddie davis
Posts: 1148
Joined: Wed Jun 14, 2006 2:47 pm
Location: Red Gate Software

Postby MattS » Mon Mar 26, 2012 2:30 pm


Thanks for your reply, and the clarification.
Posts: 18
Joined: Tue Sep 20, 2011 11:35 am

Return to SQL Backup Previous Versions

Who is online

Users browsing this forum: No registered users and 1 guest