CREATE PROCEDURE Shrink_Transaction_Log AS

    -- Build log file name
    declare @strLogFile as varchar(100)
    set @strLogFile = 'C:\Backups\SQL\Transaction Logs\'
    set @strLogFile = @strLogFile + cast(year(getdate()) as varchar(4)) + ' - ' + right('00' + cast(month(getdate()) as varchar(2)), 2)  + ' - ' + right('00' + cast(day(getdate()) as varchar(2)) , 2)
    set @strLogFile = @strLogFile + '.bak'

    BACKUP LOG LiveDatabase TO DISK = @strLogFile

    -- Reduce log file to acceptable size
    DBCC SHRINKFILE(LiveDatabase_Log, 100)

GO

SQL Shrink Transaction Log

database, backup

SQL