Post reply

backup device, how to rid of expired backups

  • November 20, 2003 at 11:26 am

    #160975

    I am running SQL2000, Ent, sp3a.

    I created a backup device and have full backups going to it daily. 5 of them are expired, but are not removed from the backup device. I have the expiredate on the backup set to "sysdate() + 9". I wanted 9 days of backups to be stored in the device.

    1) Looks like I want retaindays, not expiredate. Will retaineddays remove the backups from the backup device and the physical file on the 10th day?

    2) How do I remove the "expired" backups from the device?

    3) I have looked at the definition of expireddate. But what does it get me, if I use it?

    All my backups go to disk, then I have a server backup that takes the file to tape.

    thanks,

    Joseph

  • November 20, 2003 at 11:44 am

    #482937

    Also, when you look at the backup device, both the expiredate and the retaindays set the expiredate when you look at the contents of the backup device.

    joseph

  • November 26, 2003 at 2:21 am

    #483671

    Hi,

    If you running SQL2K, SP3a,

    Why not create a maintenace job to backup your database and then remove the backup files older than a certain number of days.

    These flat files are dumped to a folder on the physical disk so it can be backed up with the OS backup\server backup.

    Roy

    Roy

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

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