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

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 Microsoft Employee 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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,926 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,158 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 533 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans