SQL 2008 iniz şişecek derecede diski doldurduysa;

Use <database Name>
GO
Alter Database <database Name> Set Recovery Simple
GO
Alter Database <database Name> Set Recovery Full
GO
DBCC SHRINKFILE (‘<log file name>’, 1)
GO

kullanabilirsiniz.