Home > SI Documentation (v19) > Knowledge Base > SQL Express Data Limit

SQL Express Data Limit

Symptoms

 

Your SI data has reached the size limit of SQL Server Express 2019 and you received an email similar to the one below:

 

email.png

Resolution

 

You have a few options to try to resolve this issue.

Export and Delete Projects

 

You can export your older projects to .zip format and then delete the projects from SI to reduce the space being utilized. Each project must be exported individually. You will likely want to change your view to display your archived projects:

 

view archived.png

 

Select a project and click Export->Send To->Zip:

 

export projects.png

 

Store these backup files in a safe place as you can always import any of them back into SI if needed.

 

Once you have exported your projects to .zip files, you can select multiple projects at a time and delete them.

 

delete.png

 

Upgrade to SQL Standard

 

Please know that SQL Server 2019 Standard does have a cost and you will need to purchase a license. Follow the directions below to upgrade your existing instance of SQL Server 2019 Express to SQL Server 2019 Standard.

 

  1. Download SQL Server Standard 2019 from this link: https://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2019
  2. Select the EXE and click continue.
  3. Click the “How to license SQL Server” link for purchasing the product key.

 

download sql.png

 

  1. Double-click the "SQL2019-SSEI-Eval" file from your Downloads folder.
  2. Click "Download Media"

 

download media.png

 

  1. Select your language, the CAB option, and download location then click Download.

 

language selection.png

 

  1. Double-click the "SQLServer2019-x64-ENU" file in your Downloads folder.
  2. Click OK on the following message:

 

directory.png

 

  1. Click Maintenance and then the Edition Upgrade option in the SQL Server Installation Center interface:

 

edition upgrade.png

 

  1. Enter your product key and click the Next button:

 

product key.png

 

  1. Accept the license terms and click Next:

 

license.png

 

  1. Select the SQL instance used for SI, this is usually "DTOOLSSIX". Then click Next:

 

select instance.png

 

  1. The SQL installation will complete and you can proceed to continue to work in SI.

Contact Support

 

If you cannot resolve this issue, please open a Support Ticket.

Last modified

Tags

This page has no custom tags.

Classifications

This page has no classifications.