• What is the size of the database generally log should be 25-30% of database size. If your database is in full /Bulk logged recovery model take log backup and shrink log to required size and then schedule log backups frequently (eg: every one hour). Log backup will truncate the transaction log and make the space available.

    But you’ve to shrink the log manually because truncation does not change the size of the log file on disk. So when the log file is shrunk, the size of the log file is reduced to the size requested, or the minimum size to contain all in use log segments in the log.