Manually truncate MS SQL 2005 log file (.LDF)
If MS SQL database Recover Model is set to "FULL" and regular full backups are not performed databases log files (.LDF) can grow very large.
If you are working with a production database make sure you know what you are doing as you may loose ability to restore your database to any point in time since your last backup. If production database backups and storage management are set up properly you should never need to truncate logs manually.
To manually truncate log file on test/development SharePoint_Config database:
1. Open SQL Server Management Studio and run following SQL query:
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:
DBCC SHRINKFILE (N'SharePoint_Config_log', 50)
50 - Log file target size in MB.
SQL Server Management Studio > Databases > SharePoint_Config > Tasks > Shrink > Files
3. To prevent future growth of the log file run:
ALTER DATABASE SharePoint_Config SET RECOVERY SIMPLE
SQL Server Management Studio > Databases > SharePoint_Config > Properties > Options > Recovery Model > Simple
Microsoft SQL Server 2005