MSDE Database reached the 2Gb limit and ASM has some problems. Is there any solution?

KB50817

Ultimo aggiornamento: 08 October 2015

Moving from MSDE to another Database

All versions

2Gb is a "by design" limit. reaching this limit means that it's not possible to insert new data into the database. Some queries work but some other doesn't. ASM does a lot of different queries (SELECT, INSERT, DELETE) on the database and thus the application cannot work flawlessy if database is full. Errors are unpredictable (it depends on how much space is left and the kind of the queries made)

If your ASM installation reached the database limit, it means that MSDE is the wrong choice and you should consider a solution that allows more data to be stored.

Possible solutions are:

1. MSDE –> MySQL (free). You can find "how-to" documents here:
http://www.achab.it/download/asm/doc/ASM_DBmigration.pdf
MySQL doesn't have any "by-design" limit

2. MSDE –> upgrade to SQL Server 2005 Express (free)*. SQL Server 2005 Express has a 4 Gb limit so, before adopting this solution you should consider if this is a good choice for your data volumes or if you are just postponing the problem.This article explains how to assess the space requirements:
http://www.achab.com/prod/kb/index.cfm/13/?idfaq=214

3. MSDE –> upgrade to SQL Server (paid version)*."How-to" documents can be found here:
http://www.achab.com/download/asm/doc/ASM_DBmigration.pdf
SQL doesn't have any limit

* more info here:
http://support.microsoft.com/kb/325023/en-us

Warning:

Database Migration and upgrades are considered system operations and should only be done from specialized personell