How can we help you today? How can we help you today?

When to remove previous log backups

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.
judewong
0

Comments

2 comments

Sort by
  • howarthcd
    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
    howarthcd
    0
  • judewong
    Hi Chris,

    Thanks for confirming my understanding.


    Best regards,

    Jude.
    judewong
    0

Add comment

Please sign in to leave a comment.