When to remove previous log backups

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

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?

Thanks.


Best regards,

Jude.
· Share on Twitter

Comments

  • 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.

    Chris
    · Share on Twitter
  • judewongjudewong Posts: 5
    Hi Chris,

    Thanks for confirming my understanding.


    Best regards,

    Jude.
    · Share on Twitter
Sign In or Register to comment.