How can we help you today? How can we help you today?

Erasing backup files locally & remotely

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?
MasterCephus
0

Comments

1 comment

Sort by
  • Brian Donahue
    Hi,

    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
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.