The steps depends on which version SQL Server you are running.
When you are doing the steps below, make sure you choose the MASTER database to connect to and not the database that is having the log problem. If you connect the database with the log problem, Sql Server wont have exclusive access and will give you an error.
For SQL Server 2005 it is simpler:
In a new query window run the following commands (replace databasename with the name of your database, leave the double quotes
BACKUP LOG "databasename" WITH TRUNCATE_ONLY;
DBCC SHRINKFILE ( databasename_Log, 1);
For Sql Server 2008 or newer it is harder because the removed the truncate command.
So first we have to make sure you are using the simple backup plan.
(replace databasename, make sure to leave the single and double quotes)
ALTER DATABASE "databasename" SET RECOVERY SIMPLE;
DBCC SHRINKFILE('databasename_log', 0, TRUNCATEONLY);
If that still doesnt shrink the database, Then you probable have a corrupt log.
To fix this you have to detach the database, Stop the microsoft sql server service, rename the log file ( do not delete incase you need it) . Start the sql server service, then re-attach the database, without select the log file. You can do this easily through Sql Server Management studio.
You can download the newest version here.
www.microsoft.com/.../details.aspx
Let Me know if you need more help.
Thanks
