If your SharePoint Config Database is Very Large in size.
The area of this folder which contained all the data was
This folder contained many SQL databases and log files, and after some research I discovered that my largest files were Transactional Log files for Sharepoint.
The biggest of these files was
and was up to 16Gb in size, but other culprits were
|Large SharePoint log files|
All these files are log files which can easily be shrunk down to a manageable size. SQL Server Management Studio is required for this.
To run SQL Management Studio, select
Start > All Programs > Microsoft SQL Server 2005 > SQL Server Management Studio Express
Server name is
Then select Connect
Expand Databases and locate the database with the large log file
Right click on the database and select New query
The query window will appear on the right. Enter the following text:
ALTER DATABASE Database_name SET RECOVERY SIMPLE;
Then click the Execute! button
If the database name contains a ‘ – ‘, you will get an error message (below).
In this case, the database name must be surrounded by ” “, eg:
ALTER DATABASE “SharePoint_Config_29c26fca-17b8-48c1-9704-b869932abcb6” SET RECOVERY SIMPLE;
Then select Execute!
Right click > Tasks > Shrink > Files
Once this process has completed, right click the database again and select New query
Browse to the folder location
and you should see a big difference in the size of the log file.