Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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
  • Verified answer
    NavNab Profile Picture
    NavNab 4 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

Quick Links

Ramesh Kumar – Community Spotlight

We are honored to recognize Ramesh Kumar as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

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

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 2,655

#2
Mansi Soni Profile Picture

Mansi Soni 1,574

#3
YUN ZHU Profile Picture

YUN ZHU 1,453 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans