If you manage both your SharePoint environment and your SQL environment, you may find that the SharePoint_Config_Log.ldf file keeps growing far too large. Here is a quick way to reduce the size of the file. There are other articles that explain how to do this for older versions of SQL server, but I found this one to work for me in my environment.
- Windows Server 2012
- SQL Server 2012 SP1
- SharePoint 2013 Standard
- Run the SQL Server Management Studio 2012
- Select the SharePoint_Config database (you may have renamed yours)
- Open a new Query window
- Enter the following commands (Make sure you change the DB name if you don’t use the default name)
This will set the recovery mode of the configuration database to Simple which then will shrink the log file then it will reset the database back to FULL. I left mine as Simple as I have no intention of restoring my configuration database should there be an issue.