Options

Erasing backup files locally & remotely

MasterCephusMasterCephus Posts: 35
edited April 24, 2009 12:58PM in SQL Backup Previous Versions
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?

Comments

Sign In or Register to comment.