Red Gate forums :: View topic - "Copy backup to network" option setting
Return to www.red-gate.com RSS Feed Available

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

"Copy backup to network" option setting

Search in SQL Backup 7 forum
Post new topic   Reply to topic
Jump to:  
Author Message
miamikk



Joined: 25 Jun 2012
Posts: 2
Location: US/NZ

PostPosted: Wed Dec 19, 2012 10:40 pm    Post subject: "Copy backup to network" option setting Reply with quote

Is it possible to "delete prior to start of copy" for copy backup to network ?

We have a large database backup which is little over 1/3rd the size of disk which means we can only save 1 copy of backup to disk instead of 2. The copy task first copies the backup and then deletes the old backup, so it needs the space for 2 backups.

The backup task has the option to "Delete prior to start of backup" and was wonder if we can edit update the T-SQL for the job to do the same for copy task ?
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2306

PostPosted: Thu Dec 20, 2012 4:27 am    Post subject: Reply with quote

Could you please post the current T-SQL script for the backup job?

Thanks.
_________________
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
Back to top
View user's profile Send private message Send e-mail
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