| Author |
Message |
miamikk
Joined: 25 Jun 2012 Posts: 2 Location: US/NZ
|
Posted: Wed Dec 19, 2012 10:40 pm Post subject: "Copy backup to network" option setting |
|
|
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 |
|
 |
petey
Joined: 24 Apr 2005 Posts: 2216
|
Posted: Thu Dec 20, 2012 4:27 am Post subject: |
|
|
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 |
|
 |
|
|
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