var fbShare = {url: ‘http://www.thomasmaurer.ch/2010/01/shrinking-the-transaction-log-in-sql-server-2005/’,size:’small’}

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)