I've got a SQL job that for some inexplicable reason, has begun executing and the log consuming more than 100GB of hard drive space, as of 9:42 this morning. I've troubleshooted the hell out of it, after deleting the log, then with great difficulty getting db back online, researched the hell out of it on the net, and what it appears like is my log_reuse_wait time has somehow got set to 4, and this is causing the log to not shrink. When I set the job to stop at some amount of maximum log growth, it errors out.
So I'm trying to set the value of log_reuse_wait in SYS.DATABASES from 4 to 0, and nowhere can I find instructions on where to click, or what command to input, to do this. I realize this may not "directly" address my problem, but if I can just figure out how to set this, it may get me a step further.