Tlog for simple recovery db growing out of control
I have a db that uses simple recovery and the log file is growing out of control I tried to shrink the log file and it worked but after the full back up ran the log file again jumped, it went up 50 gigs over the weekend. Help
It sounds like you've got a large/long running transaction which can't roll around the log file until it has completed, thus pushing out the size. What type of processing is going on over the weekend? I'd start with some type of monitor (server side trace, extended events, 3rd party, etc) to see if you could capture what might be blowing out the transaction log size. Hope this helps!
You will need to implement some sort of monitoring solution to find what is causing the log to increase. Here is an [article] with a script on SSC that discusses this. Implement a solution like that to determine what is causing the log growth. Otherwise it is just a guessing game as to the cause (other than something is running that is causing it to grow). :