Shrinking SQL Server 2005 Databases to remove unnecessary transactions and empty space from the log file.
Note that you will need your database name **and** the SQL Server name of your log file (different to the NTFS name) for this look at sys.database_files. In this script my database name is "MyDatabaseName" and the SQL Server name of my log file is "MyDatabaseName_log" :
USE MyDatabaseName
DBCC SHRINKFILE(MyDatabaseName_log, 1);
BACKUP LOG MyDatabaseName WITH TRUNCATE_ONLY
DBCC SHRINKFILE(MyDatabaseName_log, 1);
DBCC SHRINKDATABASE(MyDatabaseName) -- Optional - not sure how much this helps
With this done I got back 50% of the entire space on my disk - guess I needed it :-) !!