Compresses, encrypts, secures and monitors SQL Server backups.
Moderators: JonathanWatts, Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey
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 ?
- Posts: 2
- Joined: Mon Jun 25, 2012 11:26 pm
- Location: US/NZ
Could you please post the current T-SQL script for the backup job?
SQL Backup Consultant Developer
Associate, Yohz Software
- SQL Backup goodies under the hood, updated for version 7
- Posts: 2230
- Joined: Sun Apr 24, 2005 12:34 pm
Return to SQL Backup 7
Who is online
Users browsing this forum: No registered users and 0 guests