• Great article. However, I think I would have pointed out one more point under your bulleted list

    AVOID TRUNCATING TRANSACTION LOG FILE ON PRODUCTION ENVIRONMENT BY ALL MEANS BECAUSE IT BREAKS LSN, unless:

    o You have a very high VLF count which is an indicator that your Transaction Log is fragmented. This fragmentation will cause performance issues.

    You should also mention something about growing your transaction log in chunks once you have it truncated so that it doesn't fragment again.

    Reference Kimberly Tripp's article at http://www.sqlskills.com/blogs/kimberly/post/8-Steps-to-better-Transaction-Log-throughput.aspx