Comments
2 comments
-
We use 2 copyto locations, one is for offsite backups and another is for storing backups for archiving to tape. It would be really nice to be able to specify different timeframes for local backup files as well as different durations for each copyto location.
-
I'll add it to the feature request list for future consideration. No promises, but would something like this feel right?
EXEC master..sqlbackup '-sql "BACKUP .... WITH ERASEFILES = 60, FILEOPTIONS = 1, COPYTO = [\\offsite\backups|2] " '
Add comment
Please sign in to leave a comment.
as an added note we'd also like to see bigger options than just hours and days. We typically keep things for week or months and it would be much easier if we could say store for 4 weeks instead of 28 days