If your SharePoint Config Database is Very Large in size.
C:\Windows\SYSMSI
The area of this folder which contained all the data was
C:\Windows\SYSMSI\SSEE\MSSQL.2005\MSSQL\Data
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
SharePoint_Config_ffffffff-ffff-ffff-ffff-fffffffffffffffffff_log.LDF
and was up to 16Gb in size, but other culprits were
ShareWebDb_log.LDF
WSS_Content_fffff…_log.LDF
![]() |
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
\\.\pipe\mssql$microsoft##ssee\sql\query
Then select Connect
Expand Databases and locate the database with the large log file
![](https://i0.wp.com/4.bp.blogspot.com/-9m1rg2xOGeQ/T_7yEvbhLiI/AAAAAAAAADM/JQyTSSWGQAI/s640/002a.jpg?resize=640%2C478)
Right click on the database and select New query
![](https://i0.wp.com/4.bp.blogspot.com/-U7qRGiU8eik/T_7y1ucnX4I/AAAAAAAAADU/QNFupCqsDC8/s1600/003a.jpg?w=980)
The query window will appear on the right. Enter the following text:
ALTER DATABASE Database_name SET RECOVERY SIMPLE;
GO
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;
GO
Then select Execute!
Right click > Tasks > Shrink > Files
Click OK
Once this process has completed, right click the database again and select New query
GO
Execute!
Browse to the folder location
C:\Windows\SYSMSI\SSEE\MSSQL.2005\MSSQL\Data
and you should see a big difference in the size of the log file.