Post reply

Deleting log back-up files

  • November 15, 2010 at 8:48 am

    #388231

    Hi

    I have a maintenance plan that backs up of our logs every hour. Is it okay to just go in and delete the old back up files from the server or are they needed in the event of a restore?

    Thanks

    Matt

  • November 15, 2010 at 8:58 am

    #1250783

    The backups are needed if you need to recover to a point in time between the full backups. If you do a full backup at midnight each day, and your server has a data error/crash/disaster at 4pm, only the log backups from midnight to 4pm can recover the data changed in that time.

    Typically people will think about data loss when deciding how many log backups to keep. It might be only since the last full, might be since the last 2 fulls. It's up to you, depending on your tolerance for loss.

    There is a task in the maintenance plans that can remove old log backups for you.

  • November 15, 2010 at 9:02 am

    #1250790

    Thanks Steve, that tells me what I need to know 🙂

  • January 19, 2012 at 11:06 am

    #1436077

    Hi Steve ..

    I am trying to delete old t-log backup files using maintenance plan and it works fine but when i check the files in backup device the old backup files still there.

    i am T-log backup on network drive in Backup device.

    any idea?

    Thanks

  • January 19, 2012 at 11:18 am

    #1436089

    Please start a new thread for new questions.

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

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