Sql script to shrink the database log file

USE <DATABASE NAME>

GO

DBCC SHRINKFILE('<LOG FILE NAME>', 1)


BACKUP LOG <DATABASE NAME> TO  DISK = N'LOG FILE BACKUP PATH'


DBCC SHRINKFILE('<LOG FILE NAME>', 1)

LOG FILE NAME: Go to Database Properties => Files => Database Files => Logical Name => Database_log

LOG FILE BACKUP PATH EXAMPLE: C:\Temp\Database_log.bak