How to Shrink Your Sql Server Log Files

http://blog.sqlauthority.com/2006/12/30/sql-server-shrinking-truncate-log-fil... Assuming SMS is your database name and sms_log is your transaction log name: USE SMS GO DBCC SHRINKFILE(sms_log, 1) BACKUP LOG sms WITH TRUNCATE_ONLY DBCC SHRINKFILE(sms_log, 1)

About

[Insert Witty Saying Here]