Below are simple steps to shrink transaction log files in SQLSERVER.
sp_helpdb 'DATABASE_NAME'
Truncate the log by changing the database recovery model to SIMPLE
USE DATABASE_NAME;
GO
-- Truncate the log by changing the database recovery model to SIMPLE.
ALTER DATABASE DATABASE_NAME
SET RECOVERY SIMPLE;
GO
Shrink the truncated log file to 1 MB:
DBCC SHRINKFILE (LOF_FILE_NAME, 1);
Reset the database recovery model.
GO
-- Reset the database recovery model.
ALTER DATABASE DATABASE_NAME
SET RECOVERY FULL;
GO
