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

When to remove previous log backups

judewongjudewong Posts: 5
edited March 13, 2009 4:15AM in SQL Backup Previous Versions

I have a database with the Full recovery model and perform the following backup.

Full Backup 1
Log Backup 1a
Log Backup 1b
Log Backup 1c
Full Backup 2

After completing Full Backup 2, can I remove all the previous Log Backup?


Best regards,



  • Options
    howarthcdhowarthcd Posts: 70 Bronze 3
    Assuming that you will never have to restore to a point in time between the completion of Full Backup 1 and Full Backup 2, and that you are sure that Full Backup 2 is integral, then yes you can delete the log backups.

    I'd recommend keeping them for at least 3 days 'just in case', but obviously the retention policy is dependent on your requirements.

  • Options
    Hi Chris,

    Thanks for confirming my understanding.

    Best regards,

Sign In or Register to comment.