SharePoint 2007 Config LDF File Grown up like Beast

Today my server started throwing low disk space error in C drive. I had more than 60 GB free space in my drive, No clue what happened. Then I started drilling into my folders to find the issue.

Finally, I found the SharePoint_Config_Log file size is 52 GB. :-O

Solution:

Right Click the Database

Select Tasks -> Shrink -> Files

Select Release Unused Space and click OK.

If you still couldn’t get much space.

Shrink the log file using script.

USE SharePoint_Config
GO
DBCC SHRINKFILE (SharePoint_Config_Log, 50)
GO