"Copy backup to network" option setting
miamikk
Posts: 4 Bronze 2
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 ?
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 ?
Comments
Thanks.
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8