web
You’re offline. This is a read only version of the page.
close
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
I have the same question (0)
  • Verified answer
    Marco Mels Profile Picture
    Marco Mels on at

    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.

  • Verified answer
    NavNab Profile Picture
    NavNab 6 on at

    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.

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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,143

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,694 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,067 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans