SQL Server 2005 Express Edition has a maximum database size of 4GB.
If the database is not corrupted as a result of being out-of-space, the options are:
- In-place upgrade to SQL Server 2008 R2 Express Edition, which will increase the max database size to 10GB.
- Upgrade the Extension Pack to v1.7SP1 and migrate the database to a remote SQL Server running Standard Edition (or greater).
so the new extension pack now is supported on remote SQL servers? that's good...do you have a link to the upgrade...i only see the demo...or do you want me to open a case and have support send me the info?
If you opt to choose the first option, here are instructions for upgrade from SQL 2005 Express to SQL 2008R2 Express:
- Download SQL2008R2 Express installation file (32-bit or 64-bit, depending on your needs) from here: http://www.microsoft.com/express/Database
- Close EminentWare
- Stop the ‘EminentWare Data Grid Service’ service
- Open the installation file for SQL Express 2008R2
- Choose the option during the install to upgrade from “SQL server 2000, SQL Server 2005 or SQL Server 2008”.
After the install, you’ll need to run a couple of installs to restore some EminentWare prerequisite files that were overwritten:
- Microsoft SQL 2005 Native Client [ x64 | x86 ]
- Microsoft SQL Server 2005 Management Objects Collection [ x64 | x86 ]
After those are installed, you can restart the EminentWare Data Grid Service and launch the EminentWare console.
The newest update (220.127.116.11 at the time of this writing) is available on our Product Downloads page. To apply it you'd want to close any open Consoles, apply the Update Only patch to your EminentWare PAS (Primary Application Server), then to any additional server Roles you may have running, then to any remote Consoles you may have.
you rock Kelly...thanks