SQL Server Express Database Exceeds 10GB Limit

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

  1. Insert the SQL Server installation media. From the root folder, double-click setup.exe or launch the SQL Server Installation Center from Configuration Tools. To install from a network share, locate the root folder on the share, and then double-click Setup.exe.
  2. To upgrade an existing instance of SQL Server to a different edition (Developer or Standard), from the SQL Server Installation Center click Maintenance, and then select Edition Upgrade.

abc.png

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
Was this article helpful?
0 out of 0 found this helpful