In my previous post “How to: claim lost space on drive c: under SBS 2008” I have mentioned the obvious things that can be done to free space from drive C: on an SBS 2008 server.
Today I discovered another fast growing and space consuming service, sharepoint…or to be precise,the SharePoint Config database Log file located at C:\Windows\SYSMSI\SSEE\MSSQL.2005\MSSQL\Data\Sharepoint_config_***.ldf
this file can be huge.
I have download and installed the “SQL Server Management Studio express” from here
opened the Database Engine: “\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query”
and tryed to shrink the Database by expanding “Databases” and select the config database “SharePoint_Config****”, right Click it, select Tasks –> Shrink –> Files,
nothing happened…..So I needed to be more drastic, I backed up the the database, right click and “Detached” the database Tasks -> Detach, I had to mark the drop connection to be able to detach the database.
after the detachment I moved the ldf file from (C:\Windows\SYSMSI\SSEE\MSSQL.2005\MSSQL\Data\Sharepoint_config_***.ldf) to a different location and Attached the database mdf file again, Tasks -> Attach, selected the Sharepoint_config database again and removed the log file from the database window.
The next thing I wanted to do is to limit the growth of this database so it w’ont happen again.
I opened the database properties window and changed the autogrowth settings for the log file to restricted 1024MB.
