Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

When doing transaction log backups, is it best practice to just keep appending to the same file or creating a new .trn file for each backup?

Thanks.

share|improve this question
    
Which RDBMS are you working with? By your transaction log backup file extension I'm guessing SQL Server..? –  Thomas Stringer Feb 9 '13 at 1:26
add comment

migrated from stackoverflow.com Feb 9 '13 at 0:59

This question came from our site for professional and enthusiast programmers.

1 Answer

I personally create a whole new NTFS file for each backup. Why? Because there is no chance of accidentally overwriting a backup (with init). A lost transaction log backup is crippling. In my opinion, the maintenance overhead of multiple backup devices/files is negligible.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.