Truncate/Shirnk ldf File in Sql Server2005
The following Sql Statements will clear .ldf file into normal size. Declare @logfile_id int Backup Log > with No_Log Select @logfile_id = max(fileid) from dbo.sysfiles where name like '%log%' DBCC Shrinkfile (@logfile_id, truncateonly) My 10GB Database ldf came back to 2 MB. :-)