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.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

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

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

    
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

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

Your Answer

 
discard

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