Shrink Tlog

use below script in SP and schedule it maintenance window.

checkpoint;

go

DBCC SHRINKFILE('log file name',25)

The following query will give you the reason on why log file is not getting reused.



select name,log_reuse_wait_desc from sys.databases


If you get nothing as description for the logfile you will also be able to shrink the log file