I have run into a situation which on a regular basis the transaction log for my ms sql database is becoming full and causing our application not to work properly.
This happened two weeks ago after about two months of running a new application called FBO Manager. It is for running the point of sale at a small airport. Anyway at that time I set the recovery method to simple and shrunk the log file down and that was fine. Then I set "automatically shrink" and reset the recovery method.
After two weeks the log file had filled up again. I am not on site there all the time so It was not being monitored.
Anyway I would greatly appreciate it if someone more knowledgable could let me know the best way to set the settings relating to database size so it does not require a manual shrinking every two weeks.
I work with several other applications that run on mssql and I have never run into this before, so I apologize in advance if this is a ridiculouslly easy question or I haven't phrased something correctly.
Thanks in advance.