• If a daily backup is enough for this database, I'd suggest to change the recovery mode to simple. Be sure that you don't have any uncommitted transactions that would prevent the log to truncate.

    Size the log correctly to prevent the need of auto-growth when running your daily processes.

    I still recommend that you read the article series (stairway) I included in the previous post and that you answer Jeff's questions to get an advice in detail.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2