Tips to reduce SharePoint_Config_Log file size

This SharePoint tutorial, we will discuss how we can reduce SharePoint_Config_Log file size in SharePoint 2010.

This is the issue that SharePoint Server administrators face while maintaining their SharePoint farm is while maintenance, the free space of the drive where SQL is stored comes down.

This is because of the SharePoint log file size increasing. This leads to performance issues on those servers.

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.

Steps to Back up the Sharepoint log file:

  • Start -> All Programs -> Microsoft SQL Server 2008 R2 -> SQL Server Management Studio -> Connect to the Configuration database SQL Server
  • Then Select New Query
  • Type the following Query:
    BACKUP LOG [Sharepoint2010_Config] TO DISK=’D:\LogBackup.bak’
  • Click Execute.

Steps to Shrink the Sharepoint log file:

  • Clear the query or open another query tab and enter the next command
  • Type the following Query:
  • DBCC SHRINKFILE (‘SharePoint2010_Config_log’ , 200)
  • Note: Here I am setting the log file size as 200MB.
  • Click Execute.

Then check your DB size now.

You may like following SharePoint tutorials:

This way we can reduce SharePoint_Config_Log file size in SharePoint 2010/2013.

Donwload Hub site pdf

Download SharePoint Online Tutorial PDF FREE!

Get update on Webinars, video tutorials, training courses etc.