Copy Queue Table For Full/Differential Backups?

Compresses, encrypts, secures and monitors SQL Server backups.

Copy Queue Table For Full/Differential Backups?

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

Hi,

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.
MattS
 
Posts: 18
Joined: Tue Sep 20, 2011 12:35 pm

Postby eddie davis » Mon Mar 26, 2012 3: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
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software

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

Eddie,

Thanks for your reply, and the clarification.
MattS
 
Posts: 18
Joined: Tue Sep 20, 2011 12:35 pm


Return to SQL Backup 6

Who is online

Users browsing this forum: No registered users and 0 guests