Best Practices. Do you append to the existing backup setup when doing a Transaction Log backup?

Question

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.

Answer 1

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.