As the title states, this is most likely going against best practices but I want to hear some opinions on this.
The database(s) in question are in FULL RECOVERY mode, transaction log backups are being performed every 15 minutes. Maintenance tasks are being performed to Microsoft and Microsoft MVP standards.
We have an ERP system that really uses SQL inefficiently. The database size is relatively manageable, but the log file continuously grows out of control. In the past we've just allocated space to the log file drive in order to control growth. I understand I can limit growth, but our ERP vendor doesn't recommend this approach. Month end processing can make this log almost double in size and make our transaction log backups huge. No problem, right? Well it's a problem as we now have two databases doing this same thing on month end.
To make a long story short, I want to have a discussion on the pros and cons of going against the grain on backing up the transaction log file, then shrinking it to conserve space. I've tackled this processes a couple times out of the year to manage space and get the logs under control but I want to hear some opinions on automating this process to relieve some headaches or to make me think outside the box.
What is recommended in this scenario that I'm not doing already? I'm to the point of offloading transaction log backups every minute to try and further prevent the log from growing but I'm not too hopeful that will solve the problem.