WSS 3.0 Config Database (SharePoint_Config) is 50GB!

Posted on 2010-03-25
Medium Priority
Last Modified: 2012-05-09
I have WSS 3.0 set up on my server using the default Windows Database that is setup with WSS 3.0.  I have connected to it using MSSQL Server Manager Express and found that the size of the SharePoint_Config database is 50GB! Further investigation shows that this is the transaction log, and this is the INITIAL size it was set to!  Doing a transaction log backup will not shrink it below the initial size, so I'm stuck with this massive file on a server when the content is only 2 sites and they contain about 7 GB worth of data (content) as shown by the size of the SharePoint content database (not shown).  The problem here is that I am running out of disk space and since this is taking up more than 35% of my available space, I would like to make it MUCH smaller.

My question is two-fold.

1.  Is the a standard size for this database?  Seems awfully large to me.
2.  Can I reduce the minimum size of this file without adverse effects?  If so, what size?

Thanks in advance for your help.
Question by:mdiehly64
LVL 30

Accepted Solution

Brad Howe earned 2000 total points
ID: 28597187
You can shrink the log without losing any content.  This grows for transactions beacuse the DB is in FULL Recovery -- which is good.

To reduce this you can do the following below.

I would suggest creating a maintance plan to execute these tasks once a week as well.

USE SharePoint_Config;
-- Truncate the log by changing the database recovery model to SIMPLE.
ALTER DATABASE SharePoint_Config
-- Shrink the truncated log file to 1 MB.
DBCC SHRINKFILE SharePoint_Config_Log, 1);
-- Reset the database recovery model.
ALTER DATABASE SharePoint_Config


Author Closing Comment

ID: 31707261
Awesome.  Worked beautifully.

Since I'm using the Express version of SQL, I don't think I can set up a maintenance plan.  If this is not the case, please write back and let me know where to find it.  There is nothing under tools.  I wonder if I could run a transact-SQL script and plant it somewhere?

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
Summary In SharePoint 2010 it is easy to create custom color themes to jazz up a site. Theme colors can also be created in PowerPoint 2010 with a few clicks. But how do the chosen colors actually look in the SharePoint site? The attached PowerPoint…
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.
Suggested Courses

601 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question