web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / SQL Express Size Limit...
Small and medium business | Business Central, N...
Answered

SQL Express Size Limit Reached

(0) ShareShare
ReportReport
Posted on by WaelGhaith 73

Hi all, 

The size of my D365BC backup file is close to 9.7GB, too close to reaching the 10GB limit of the express version we are using. I am in the process of acquiring the standard license, however, this may take few days to complete, and I am afraid I might exceed the limit, does anyone know what will be consequences if I reached the limit?

1) Will D365BC stop functioning - I am using an on-prem version - ?

2) Will there by any data loss?

Last question, is the upgrade an easy process? or a complicated one. 

Thank you so much for your input.

Thanks

Wael

Categories:
Dynamics 365 Business Central
Dynamics 365 Business Central
I have the same question (0)
  • Verified answer
    NavNab Profile Picture
    NavNab 6 on at
    RE: SQL Express Size Limit Reached

    1) if my memory is good, sql server instance will stop if you try to write in the database

    2) you can't access the database since sql server will be down

    To upgrade:

    - backup your database(s)

    - install the new sql server

    - restore your backup(s)

    (I assume you'll upgrade to the same version)

    Is this a PRODUCTION environnement? If not, you can install sql server developer edition.

  • Verified answer
    Marco Mels Profile Picture
    Marco Mels on at
    RE: SQL Express Size Limit Reached

    Hello,

    Best probably is to run some maintenance on the database:

    learn.microsoft.com/.../database-reduce-data

    And to delete historical data. Of course make a database backup first so that historical data can still be accessed by accessing the current database. When the used space also reached the limit, your users may face some unknown strange errors.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Our Community Code of Conduct has been updated!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Sumit Singh Profile Picture

Sumit Singh 2,727

#2
Sohail Ahmed Profile Picture

Sohail Ahmed 2,681 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 2,288 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans