Sometimes, we face some space related issue in SharePoint_Config database. The “SharePoint_Config_Log” file increases rapidly, due to various operations in different SharePoint sites. As a result, it affects the performance of the SharePoint server which is associated with the SharePoint_Config database. The following queries can help us 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