Resolve space issue of SharePoint_Config by reducing SharePoint_Config_Log File Size

If admins face any space related issue in SharePoint_Config database, most of time its because of the “SharePoint_Config_Log” file increases rapidly.  This rapid growth is because of the various operations in different SharePoint sites which affects the performance of the SharePoint server. We can use below SQL scripts to reduce/shrink the log file size

USE [master] Go ALTER DATABASE[SharePoint_Config] SET RECOVERY SIMPLE WITH NO_WAIT Go USE [SharePoint_Config] Go DBCC SHRINKFILE ('SharePoint_Config_Log') Go