locked
How to Free Up Space In WSS 3.0 Database? RRS feed

  • Question

  • Hey guys;

     

    We run WSS 3.0 on mysql server express.  Recently we cannot upload doc's anymore, we get an operation error or something.  Our MDF file is 4,193,472 bytes which I believe surpasses the 4GB limitation.

     

    I hear you can upgrade to SQLSERVER EXPRESS 2008 and it has a higher limitation.  However in the meantime, is there an easy way to shrink down this size a bit for another month so we can do it when we're ready?

    If I try clearing out the sharepoint recylce bin, it doesn't allocate the space back.  So I was hoping someone else could recommend a temp solution to get it down to like 3.5GB or something.  Thank you in advance!

    • Edited by Mike Walsh FIN Monday, January 3, 2011 5:25 PM Don't shout and Titles and write simple questions
    Monday, January 3, 2011 4:15 PM

Answers

  • To your earlier question.

    WSS 3.0 using the built-in Windows Internal Database (which pre-supposes a single server system) has NO database size limit. (WID is a special version of SQL Server 2005 Express - as stated this special version doesn't have a limit)

    MOSS 2007 using it's buit-in version of SQL Server 2005 Express does have a 4GB limit.

    WSS 3.0 using (presumably because a two server system was wanted - this is very rare however) SQL Server 2005 Express has a 4GB limit. 

     

    So if you are using WSS 3.0 installed using the Basic installation or the Advanced installation + Single-Server as is likely you don't need to do anything.

    As for SQL Server 2008 Express. It has a 4GB limit too. However SQL Server 2008 Express *R2* has a 10GB limit.

     

    (Off-Topic: (so don't follow this up here) Your problems are not solved by upgrading SharePoint as the next version has a 4GB limit again - unless SQL Server 2008 Express R2 is used)

     


    SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx
    WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx
    Both also have links to extensive book lists and to (free) on-line chapters
    • Marked as answer by Leoyi Sun Monday, January 17, 2011 7:21 AM
    Monday, January 3, 2011 5:55 PM
  • I can also confirm (I found an old WSS 3.0 VM - the delay was in updating it with 58 fixes) that if the WID has been used then "Windows Internal Database" is listed in Add or Remove Programs.
    SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx
    WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx
    Both also have links to extensive book lists and to (free) on-line chapters
    • Marked as answer by Leoyi Sun Monday, January 17, 2011 7:22 AM
    Tuesday, January 4, 2011 4:36 PM

All replies

  • the temp solution is shrink your content Db. There is an excellent document available from Microsoft about Database Maintenance for Sharepoint:http://go.microsoft.com/fwlink/?LinkId=111531&clcid=0x409

     

    hope this help

    thanks

    -ws

     



    SharePoint administrator, MCTS,MCITP
    Monday, January 3, 2011 5:06 PM
  • How long do you think shrinking a database would take?
    Monday, January 3, 2011 5:39 PM
  • I went to the studio manager express, went to shrink -- Files, and  the available free space:  28.31MB  

     

    Does that  mean its only gonna free up 28 megs after a shrink?  If so, thats not worth it!

    Monday, January 3, 2011 5:45 PM
  • To your earlier question.

    WSS 3.0 using the built-in Windows Internal Database (which pre-supposes a single server system) has NO database size limit. (WID is a special version of SQL Server 2005 Express - as stated this special version doesn't have a limit)

    MOSS 2007 using it's buit-in version of SQL Server 2005 Express does have a 4GB limit.

    WSS 3.0 using (presumably because a two server system was wanted - this is very rare however) SQL Server 2005 Express has a 4GB limit. 

     

    So if you are using WSS 3.0 installed using the Basic installation or the Advanced installation + Single-Server as is likely you don't need to do anything.

    As for SQL Server 2008 Express. It has a 4GB limit too. However SQL Server 2008 Express *R2* has a 10GB limit.

     

    (Off-Topic: (so don't follow this up here) Your problems are not solved by upgrading SharePoint as the next version has a 4GB limit again - unless SQL Server 2008 Express R2 is used)

     


    SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx
    WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx
    Both also have links to extensive book lists and to (free) on-line chapters
    • Marked as answer by Leoyi Sun Monday, January 17, 2011 7:21 AM
    Monday, January 3, 2011 5:55 PM
  • right, so thats what I'm using.  WSS 3.0 with SQL Server Express 2005.   So I'm over 4GB, so thats my issue.  I would either have to migrate to sql server 2005/2008, or upgrade my express edition to  2008 Express R2?  Thats what it sounds like.  Which is easiest?
    Monday, January 3, 2011 6:15 PM
  • Easist is no doubt to full SQL Server 2005 as its the same database system. But it costs of course.

    Moving to SQL Server 2008 Express R2 has the advantage that its free and the two disadvantages that a) it's a different db system and b) it's not the db system that was around when WSS 3.0 was written.

     

    (I'd still like to know why you are using SQL Server 2005 Express and not the built-in Window Internal Database. Or was it as I wrote that you had to because you wanted a 2 machine farm?)


    SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx
    WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx
    Both also have links to extensive book lists and to (free) on-line chapters
    Monday, January 3, 2011 6:21 PM
  • When I came into this company sharepoint was already built/setup by two morons.  They used SQL Server Express 2005.  Now that we are at 4GB *.mdf file, I'm supposed to fix the issues.  They no longer work here.

     

    We have a SQL Server 2008 server thats not doing much.  Just has one DB on it.  So I could use that, just don't know whats entailed with migrating the data?

     

    Right now I'm trying to figure out where all the space is being used up, but its hard.  Theres no good way to find out.  So I'm doing exports (stsadm -export)  on all my sites to find out where all the space is being used up.  (Unless theres a better way)

    Monday, January 3, 2011 6:42 PM
  • I would suggest in that case that you move the databases to the SQL Server 2008.

    I think it's straightforward and probably just means moving the databases (in some way ...), so I suggest you first trying to scan or search the Setup forum here looking for a thread on upgrading from SQL Server 2005 to 2008 for the SP databases and if that brings up nothing start a new thread with an appropriate title.

    There seems little point in spending a lot of time finding out where the space is, if you have that solution already available to you at no extra cost.


    SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx
    WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx
    Both also have links to extensive book lists and to (free) on-line chapters
    Monday, January 3, 2011 8:28 PM
  • There are three main features in SharePoint that consumes a lot of disk space:

    1. Versioning - Try reducing the number of allowed versions and delete older versions
    2. Recycle bin - If you have not specified a quota to your site collections, recycle bin can grow indefinitely. Reduce the size of your second stage recycle bin
    3. Audit Log - Check if you have auditing enabled in your farm. If you have, you can use the command stsadm -o trimauditlog to delete old audit logs

    After any of the above operations, perform a database shrink. Hope this helps.

    Thanks,
    Dip

    Tuesday, January 4, 2011 3:16 AM
  • I mean is there anyway to find out if our version of wss 3.0 was installed with the embedded internal database or a copy of sql server express 2005?  Is there even a difference?  Here is a screenshot of whats installed.    Screenshot

     

    Thanks everyone!  So helpful

    Tuesday, January 4, 2011 2:23 PM
  • My *memory* tells me that when WSS 3.0 is installed with the Windows Internal Database then "SQL Server 2005" is not listed .

    Unfortunately I don't have a WSS 3.0 VM handy that I can check.


    SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx
    WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx
    Both also have links to extensive book lists and to (free) on-line chapters
    Tuesday, January 4, 2011 2:43 PM
  • Ok.  I did a search like you said and found another individual doing a similar process.  They posted this article that helped them upgrade their SQL.  http://www.toddklindt.com/blog/Lists/Posts/Post.aspx?ID=55

     

    I would just utilize it to upgrade to sql server 2008, which hopefully would be the same process.  I've read that shrinking CONTENT DB's is frowned upon??

    Tuesday, January 4, 2011 3:17 PM
  • I can also confirm (I found an old WSS 3.0 VM - the delay was in updating it with 58 fixes) that if the WID has been used then "Windows Internal Database" is listed in Add or Remove Programs.
    SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx
    WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx
    Both also have links to extensive book lists and to (free) on-line chapters
    • Marked as answer by Leoyi Sun Monday, January 17, 2011 7:22 AM
    Tuesday, January 4, 2011 4:36 PM
  • Ok, thanks.  So it sounds like  install SP2 for WSS 3.0, then try to upgrade the SQL server express to SQL server 2008.
    Tuesday, January 4, 2011 5:32 PM
  • My WSS database is 3.5 gigs, I am wondering if I have WID or SQL Server 2005 express or Microsoft SQL server compact 3.5 ?

    When I connect via Microsoft SQL server manager I use \\.\pipe\mssql$microsoft##ssee\sql\query. after I connect I right click on the top tree and select properties I see "Microsoft SQL Server Windows Internal Database (64-bit)", and VErsion 9.00.4035.00

    I am sure I am running WSS 3.0 because its in my installed programs....

     

    So my question is am I running WID, the special version of SQL server express that does not have a limit, or am I stuck with a 4 gig limit ?

     

    Thank you

     

     

     

     

     

     

     

     

    Monday, January 17, 2011 10:54 PM
  • So my question is am I running WID, the special version of SQL server express that does not have a limit, or am I stuck with a 4 gig limit ?

    If you read an earlier message from me in this thread, you'll see that if you have WID installed you will have Windows Internal Database listed when you look at Add/Remove Programs.


    SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx
    WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx
    Both also have links to extensive book lists and to (free) on-line chapters
    Tuesday, January 18, 2011 9:14 AM