Shrink SQL Log Files - SIMS, FMS, Discover - ShrinkDBLog.bat
If you read KB104766 on supportnet and wanted to shrink the log files for any of your databases (our Discover log was rather large) here is the batch file the supportnet article mentions, save you grabbing it from Capita, remember to edit the PW for the SA account in the file. worked a charm for us! :) reduced the resource load on our server loads, and the log file down to 1mb!
Hopefully Capita don't mind it being here :cool: