I'm looking for some guidance. I currently have WSS 3 running on a w2k8 r2 server using the internal db. I ran the stsadm precheck and was flaged for a large database pushing 4g.
The strange thing is I don't think my WSS installation is that large. It priimarily consists of a calendar with some additional fields and lookups.
When I do an stsadm -o backup with a url the backup is only 30 mg. If I do it with a -directory its about 240 mg.
So I have the following questions:
1) how can I determine the size of the databases?
2) if they are low, what would cause the precheck to state otherwise?
3) if its really that high what can I do? Do I need to go to real SQL and pay for it?
Content of Report:
Potential Upgrade Blocking Issues
Issue : Databases within this farm are hosted on Windows Internal Database and are larger than or close to 4GB in size.
The following databases are hosted on Windows Internal Database and are larger than or close to 4GB in size and will require additional administrator intervention to upgrade:
One or more databases are larger than or close to 4 GB in size, which could prevent the databases from being attached to a SQL Express 2008 instance as part of an upgrade to SharePoint 2010. There are several alternatives to mitigate this issue, including reducing the size of the site collections in the content databases, reducing the number of site collections within each large content database, moving the content databases to a different SQL instance running under a full version of SQL, or migrating the content databases to Remote BLOB Storage as part of the upgrade process. For more information about this rule and the actions you may need to perform to reduce the database sizes or to successfully upgrade, please see KB article 954783 in the rule article list at http://go.microsoft.com/fwlink/?LinkID=120257