SQL 2008 R2 single instance, hosting one database
This week I was performing an analysis of our server to make sure SQL is configured in an appropriate manner. Using this question
to guide me.
Since I started my analysis, our transaction logs have grown from 700 MB to 90 GB. I wasn't making changes that I'm aware of. I ran the Best Practice Analyzer and a few select statements.
What could cause my transaction logs to grow? How do I get them back to a manageable size?