Erasing backup files locally & remotely
MasterCephus
Posts: 35
I am fixing to set up a backup job for production servers and I want to make sure that I understand exactly how to do what I want to do. I want to keep about 2 days backups on the local share and I want to keep my backup files on a network share for 10 days. I want SQL Backup to auto delete the backup files. Are these settings right?
TO DISK = 'C:\WHATEVER'
WITH COMPRESSION = 2
COPYTO = '\\NETWORK\Backup\FULL'
FILEOPTIONS = 1
ERASEFILES = 2
ERASEFILES_REMOTE = 10
INIT
THREADCOUNT = 4
VERIFY
Are these settings correct?
TO DISK = 'C:\WHATEVER'
WITH COMPRESSION = 2
COPYTO = '\\NETWORK\Backup\FULL'
FILEOPTIONS = 1
ERASEFILES = 2
ERASEFILES_REMOTE = 10
INIT
THREADCOUNT = 4
VERIFY
Are these settings correct?
Comments
This sure looks okay to me.
FILEOPTIONS=1 will delete the copies as well as the primary backup file, and ERASEFILES_REMOTE will override that and allow you to keep the copies a bit longer.
We have got a very detailed article about using ERASEFILES and ERASEFILES_REMOTE together:
http://www.red-gate.com/supportcenter/C ... 000356.htm