Sharepoint 2013 large log file fix

I have been working on SharePoint 2013 lately and was wondering why so much HD space is disappearing.

It appears the SharePoint_Config_Log was very large (over 40gb).

The link below will help you with solving this problem.

http://www.craig-tolley.co.uk/2010/04/15/sharepoint_config_log-file-size-is-78gb/

(I give full credit to the website owner above however if you need the fix I will paste it below)

1.Open up Microsoft SQL Server Management Studio
2.New Query
3.Type in the following and press execute.

USE [master]
GO
ALTER DATABASE[SharePoint_Config] SET RECOVERY SIMPLE WITH NO_WAIT
GO
USE [SharePoint_Config]
GO
DBCC SHRINKFILE (‘SharePoint_Config_Log’)
GO

Log has now shrunk 🙂