truncate MS SQL 2005 log file (.LDF)

1. Open SQL Server Management Studio and run following SQL query:
USE SharePoint_Config
BACKUP LOG SharePoint_Config WITH TRUNCATE_ONLY
This will truncate log file but won't reduce actual file size.

2. To shrink actual file run:
USE SharePoint_Config
DBCC SHRINKFILE (N'SharePoint_Config_log', 50)
50 - Log file target size in MB.
OR 
SQL Server Management Studio > Databases > SharePoint_Config > Tasks > Shrink > Files

3. To prevent future growth of the log file run:
USE SharePoint_Config
ALTER DATABASE SharePoint_Config SET RECOVERY SIMPLE 
OR
SQL Server Management Studio > Databases > SharePoint_Config > Properties > Options > Recovery Model > Simple


Microsoft SQL Server 2005