How to shrink a SQL Transaction Log
For 2005: --\* you can get the logical log file name usingthe following command in Query Analizer: exec "databaseName".dbo.sp_helpfile Now execute the following command to shrink the database log to 200MB: DBCC SHRINKFILE ("logicalLogFileName", 200) BACKUP LOG "databaseName" WITH TRUNCATE_ONLY DBCC SHRINKFILE ("logicalLogFileName", 200) –if it doesn’t work, run the two commands again. –When done with that, do a full backup of your db as you will have broken your tlog backup chain. For 2008+ ...