Skip to main content

SQL Express Data Limit

A
Written by Ashok P
Updated over a month ago

The issue being discussed in this article is:

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

The following is the cause:

The database storage capacity on your SI Server is near exhaustion.

The following is the resolution:

#1 Reduce Space or Export and Delete Projects

You can export your older projects to .zip format and then delete the projects from SI to reduce the space 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 safely; you can always import 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

#2 Upgrade to SQL Standard

Please know that SQL Server 2019 Standard has a cost, and you must purchase a license.

Follow the directions below to upgrade your existing SQL Server 2019 Express instance 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 to purchase the product key.

download sql.png

4/ Double-click the SQL2019-SSEI-Eval file from your Downloads folder.

5/ Click Download Media.

download media.png

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

language selection.png

7/ Double-click the SQLServer2019-x64-ENU file in your Downloads folder.

8/ Click OK on the following message.

directory.png

9/ Click Maintenance and then the Edition Upgrade option in the SQL Server Installation Center interface.

edition upgrade.png

10/ Enter your product key and click the Next button.

product key.png

11/ Accept the license terms and click Next.

license.png

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

select instance.png

The SQL installation will be complete, and you can continue to work in SI.

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

Did this answer your question?