Shrink SQL Server Database Log File Size

Truncate a SQL Server log file


ALTER DATABASE DBNAME SET RECOVERY SIMPLE

sp_helpdb 'DBNAME'

DBCC SHRINKFILE('DBNAME_log', 0, TRUNCATEONLY)

Shrink SQL Server User Databases