Symptoms
Your SI data has reached the size limit of SQL Server Express 2019 and you received an email similar to the one below:
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:
Select a project and click Export->Send To->Zip:
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.
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.
- Download SQL Server Standard 2019 from this link: https://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2019
- Select the EXE and click continue.
- Click the “How to license SQL Server” link for purchasing the product key.
- Double-click the "SQL2019-SSEI-Eval" file from your Downloads folder.
- Click "Download Media"
- Select your language, the CAB option, and download location then click Download.
- Double-click the "SQLServer2019-x64-ENU" file in your Downloads folder.
- Click OK on the following message:
- Click Maintenance and then the Edition Upgrade option in the SQL Server Installation Center interface:
- Enter your product key and click the Next button:
- Accept the license terms and click Next:
- Select the SQL instance used for SI, this is usually "DTOOLSSIX". Then click Next:
- 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.