Link to home
Start Free TrialLog in
Avatar of mdiehly64
mdiehly64

asked on

WSS 3.0 Config Database (SharePoint_Config) is 50GB!

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.
test.JPG
ASKER CERTIFIED SOLUTION
Avatar of Brad Howe
Brad Howe
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of mdiehly64
mdiehly64

ASKER

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?