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

New ERASEFILES_REMOTE option in SQL Backup v5.3

If there are two COPYTO locations configured; is it possible to specify two ERASEFILES_REMOTE parameters? I would like to enable a different # of days of “retention periods" on the two remote locations... It is my guess that ERASEFILES_REMOTE is "global" for all COPYTOs; but I though that I would ask (I have not tried it yet). If not; it might be a worthwhile enhancement to SQL Backup in a future release. In this case; the 1st remote location is a SQL Server where the backup is restored daily (a read-only copy of yesterday's data) and I only want to retain one copy; i.e. the current backup. The 2nd remote location is a NAS device and I would like to keep 5 to 7 days of backups...

Also; is there a limit to the number of COPYTOs that can be specified for a backup?

Thanks,
plavalle
0

Comments

2 comments

Sort by
  • Ben Pinchen
    Unfortunately, the ERASEFILES_REMOTE parameter is, as you say, global. In the sense that you can only specify one instance and it will affect all of the COPYTO locations. I'll add a feature request for you requesting a way of specifying multiple ERASEFILES_REMOTE parameters.

    I'm fairly sure that there isn't a limit to the amount of COPYTOs that you can use. We have customers who use multiple destinations and I've never heard of anyone reaching a 'limit'.
    Ben Pinchen
    0
  • plavalle
    Thanks Ben!
    plavalle
    0

Add comment

Please sign in to leave a comment.