Sharepoint Config database on SBS 2008 very large

You may notice that these databases become larger than expected on the C:\ drive of a default SBS 2008 installation.  You will have to shrink them to regain the space that the log (.ldf) files are consuming.

Databases that might be affected:

SharePoint_Config_*****_log.LDF
ShareWebDb_log.LDF
WSS_Content_*****_log.LDF

Folder location of these databases that you will see grow in size:

C:\Windows\SYSMSI\SSEE\MSSQL.2005\MSSQL\Data
1. Open SQL Management Studio and connect to database instance –  Location:  Start > All Programs > Microsoft SQL Server 2005 > SQL Server Management Studio Express

Server name will be:  “\\.\pipe\mssql$microsoft##ssee\sql\query”    Click Connect.

NOTE: You may receive a login error even if you are logged in as a domain admin.  If that’s the case, close SQL Management Studio and reopen it by right-clicking and running as Administrator.

2. Right click on the database that we need to reclaim space from and click New query. 

3. The query window will appear on the right. Enter the following text:

ALTER DATABASE “SharePoint_Config_type-actual-values-here” SET RECOVERY SIMPLE;
GO

4. Then click the Execute! button

5. Right click the same database > Tasks > Shrink > Files, Change File type to Log, then Click OK.

6. Set the databases back to Full Recovery mode, run this on the same database:

ALTER DATABASE “Database_name” SET RECOVERY FULL;
GO

 Repeat steps 2 through 6 for each database that is consuming a large amount of space and then you should see a major difference in space being used.

About Jeremiah

Windows operating system advocate in Houston, TX.
This entry was posted in Microsoft, SQL Server, Uncategorized and tagged , . Bookmark the permalink.

2 Responses to Sharepoint Config database on SBS 2008 very large

  1. Josef says:

    Jeremiah,

    I spent some hours trying to fix this issue. MS Fixit did not work.

    Thx for your detailed description. 20 minutes and everything was resolved.

    Joe

  2. vicky says:

    Hi,
    Your solution is simple and excellent.
    works like magic..after a few seconds I could see the increase in FREE disk space.

    Thanks
    Vicky
    http://www.techvicky.com

Leave a Reply

Your email address will not be published. Required fields are marked *