Red Gate forums :: View topic - Copy Queue Table For Full/Differential Backups?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup 6
SQL Backup 6 forum

Copy Queue Table For Full/Differential Backups?

Search in SQL Backup 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
MattS



Joined: 20 Sep 2011
Posts: 18

PostPosted: Mon Mar 26, 2012 11:37 am    Post subject: Copy Queue Table For Full/Differential Backups? Reply with quote

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.
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 925
Location: Red Gate Software

PostPosted: Mon Mar 26, 2012 3:16 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
MattS



Joined: 20 Sep 2011
Posts: 18

PostPosted: Mon Mar 26, 2012 3:30 pm    Post subject: Reply with quote

Eddie,

Thanks for your reply, and the clarification.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group