Is your SQL database log file too big? Maybe it is. But maybe it’s not.
When log files keep growing and appear to be too big some might suggest switching to Simple recovery, shrinking the log file, and switching back to Full recovery. While this will work to shrink the file and free up disk space, it may grow right back again. Also, the database will be at risk for data loss in the event of an unexpected disaster. You will only be able to recover data from the point in time of your last full backup. If it is