Skip to main content

SQL Server Express database exceeds 10GB limit

  • Updated

Problem

Using default installation options, CloudM Migrate installs a local copy of SQL Server Express 2017. This version of SQL Server has a maximum database size of 10GB. For migrations with Record Document Mappings enabled (and specifically in Large Migrations), it is possible to exceed this database size limit.

 

Solution

To fix this issue, a full version of SQL should be installed. In this case an in-place upgrade on the primary server can be run by installing SQL Server Standard or Developer editions (not a cloud based version) and choosing the following option from the installer:

In_place_sql.png

 

You can choose Custom install in order to select the Express database to be upgraded. The original databases should first be backed up by the customer.

 

If after the upgrade the secondary servers are not connecting:

  1. Go to SQL Server Configuration Manager
  2. Open SQL Server Network Configuration
  3. Click on your Named Instance
  4. Ensure TCP/IP Enabled
  5. Open TCP/IP
  6. Click on IP addresses
  7. Added port 1433 to all ip's
  8. Restart MSSQL service

 

Comments

0 comments

Please sign in to leave a comment.