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
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;
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.