What are the challenges you face when working across database platforms? Take the survey
Options

Feature Request - delete copy to files

Giggles220Giggles220 Posts: 154
edited June 3, 2007 11:53PM in SQL Backup Previous Versions
I need a way to say delete the backup files older than 60 days and delete copyto files older than 2 days. In our location we need these two values to be different.

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

Comments

  • Options
    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.
  • Options
    peteypetey Posts: 2,358 New member
    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] " '
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
Sign In or Register to comment.