I'm running Small Business Server 2008 Standard with SharePoint 3.0. I'm intending to upgrade to SharePoint 2010 Foundation. I ran the stsadm preupgradecheck and the only remaining issue is "Databases within this farm are hosted on Windows Internal Database and are larger than or close to 4GB in size." Then it lists ShareWebDb, and ShareWebDb.mdb is indeed around 4GB.
Point 1: I installed SQL Server Express 2008 R2, upgrading the SQLEXPRESS instance. I moved ShareWebDb to this instance following the instructions under "Moving the Windows SharePoint Services content database" at http://technet.microsoft.com/en-us/library/cc794697%28WS.10%29.aspx
. Companyweb and the one sub-site are working fine. In SQL Server Management Console I see the ShareWebDb database under SQLEXPRESS and the SQLEXPRESS version is 10.50.1600. So don't I now have a 10GB limit and the preupgradecheck is raising a false alarm?
Point 2. I applied a huge quota template to companyweb, which is the only SharePoint site other than SharePoint 3.0 CCentral Administration, which is using a different content database. Under Storage Space Allocation the entire site and its sub-site is using 119.9 MB.That's all the content I have. Why is the ShareWebDb.mdb file 4GB, and is there any way to shrink it? (I regularly shrink the log file).