Shrinking the Transaction Log in SQL Server 2005

Shrinking the Transaction Log in SQL Server 2005
Use the MS SQL Server Management Studio

EXEC sp_dboption 'XXX', 'trunc. log on chkpt.', 'TRUE'

CHECKPOINT

DBCC SHRINKFILE ('XXX_Log', TRUNCATEONLY)

EXEC sp_dboption 'XXX', 'trunc. log on chkpt.', 'FALSE'

GO

(replace XXX with the database name)