Delete old backups from backup device

  • I have 3 backup devices that i use for backing up all databases.

    Full device (full backup for all databases running weekly)

    Diff device (diff backups for all databases running daily)

    Log device (log backups for all databases running hourly)

    I want to purge old backups from these backup devices.

    How can i accomplish this ?

  • add a cleanup task and define your retention period.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • you can perform backup WITH INIT clause,

    CAUTION: This will remove all the backups from the media set, which has expired or retain period is over,

    You can set the Retain Days while performing the backup.

    Vishal Gajjar
    http://SqlAndMe.com

  • Hi,

    Abow both answers are correct also you will schedule that older 25 day's data delete........

    Regards

    Satish

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply