What are the limits of SQL Server Express? SQL Server 2025 Express is free and permitted for production use, but limited: at most 50 GB per database, 4 processor cores and 1,410 MB of buffer pool memory per instance. In addition, it lacks SQL Server Agent for scheduled tasks, compression and encryption of backups, and all high availability features. Up to and including SQL Server 2022, the limit was 10 GB per database. If you reach one of these limits, you switch to Standard without reinstalling.
Quick decision
| Your situation | Recommendation |
|---|---|
| Database below 50 GB, few concurrent users, backup by script is acceptable | Express is enough |
| Database between 10 and 50 GB on Express 2022 or earlier | upgrade to Express 2025 |
| Database will foreseeably grow beyond 50 GB | Standard |
| Queries become slow because 1,410 MB of buffer pool is not enough | Standard |
| You need scheduled jobs, maintenance plans or notifications by email | Standard |
| The database must be encrypted (TDE) or backups must be encrypted | Standard |
| Resilience with a second server | Standard or Enterprise |
| The software vendor requires Standard | Standard |
The limits in numbers
| Feature | Express 2019 | Express 2022 | Express 2025 | Standard 2025 |
|---|---|---|---|---|
| Maximum size per database | 10 GB | 10 GB | 50 GB | 524 PB |
| Compute capacity per instance | 1 socket or 4 cores | 1 socket or 4 cores | 1 socket or 4 cores | 4 sockets or 32 cores |
| Buffer pool memory per instance | 1,410 MB | 1,410 MB | 1,410 MB | 256 GB |
| Columnstore segment cache per instance | 352 MB | 352 MB | 352 MB | 32 GB |
| Memory-optimized data per database | 352 MB | 352 MB | 352 MB | 32 GB |
For sockets and cores, the lower value applies in each case. If the computer has more cores or more memory, Express still runs; it just does not use the additional capacity.
Three points are often misunderstood:
- The size limit applies per database, not to the whole instance. Several databases may each grow up to the limit.
- The 1,410 MB concern the buffer pool, i.e. the cache for data pages. The SQL Server process uses somewhat more in total.
- The limits apply per instance. A second instance again has its own 4 cores and its own buffer pool, but shares the hardware.
What Express lacks
| Feature | Express 2025 | Standard 2025 |
|---|---|---|
| SQL Server Agent (scheduled jobs, maintenance plans) | No | Yes |
| Compressing backups | No | Yes |
| Encrypting backups | No | Yes |
| Transparent Data Encryption (TDE) | No | Yes |
| Database Mail | No | Yes |
| SQL Profiler | No | Yes |
| Resource Governor | No | Yes |
| Optimized locking | No | Yes |
| Log shipping | No | Yes |
| Basic availability group | No | Yes |
| Failover cluster | No | 2 nodes |
| Change data capture | No | Yes |
| Transactional replication | subscriber only | Yes |
What Express can do nonetheless
Express is not a stripped-down trial product. Among other things, it includes:
- full and differential database backups,
- Always Encrypted, row-level security and dynamic data masking,
- columnstore indexes, partitioning and data compression,
- full-text search (included in Express since 2025, previously in “Express with Advanced Services”),
- native JSON data type, vector data type and Query Store,
- SQL Server Management Studio as a free download.
You will find the complete feature comparison with Enterprise in the guide
SQL Server 2025: editions compared.
Backups without Agent
The missing SQL Server Agent is the most noticeable restriction in everyday use, because without it there are no built-in schedules. This is how you still back up regularly:
- Write a script file with the
BACKUP DATABASEcommand. - Call the script with the command-line utility
sqlcmd. - Schedule this call in Windows Task Scheduler, for example daily at night.
- Copy the backup file to a second device and test the restore.
Many vendors of line-of-business applications supply their own backup tool for this. Ask them before you build something yourself.
Typical cases
Trade business with 5 workstations. The order software uses a database with 3 GB. The vendor supplies Express with it and backs up with its own tool. Express is enough; no license is needed.
Tax consultancy, database at 9.5 GB on Express 2019. The old limit of 10 GB is almost reached. If the application is approved for SQL Server 2025, the upgrade to Express 2025 with 50 GB is enough. Otherwise only Standard in the approved version remains.
Online shop with 30 GB and increasing load. The size fits, but the queries become slow at peak times. A common cause is the buffer pool of 1,410 MB: the data no longer fits into the cache. Standard uses up to 256 GB.
Medical practice with an encryption requirement. If the database is to be encrypted on the disk, you need TDE and therefore Standard. Alternatively, you encrypt the whole drive with BitLocker; clarify with your data protection officer whether that meets your requirement.
Switching from Express to Standard
The switch is an edition upgrade in SQL Server Setup (“Maintenance” area, “Edition Upgrade” item). You enter the product key of the Standard edition, and the databases are retained. Setup restarts the SQL Server services; plan a short maintenance window and back up all databases beforehand.
For Standard you choose one of two licensing models: per core or server + CAL. Which one fits your number of users is covered in the guide
Licensing SQL Server: per core or server + CAL. Whether you take the latest version right away is clarified in
SQL Server 2025 or 2022.
At VivaKeys
You download Express free of charge from Microsoft; you do not need to buy anything for it. When Standard becomes necessary:
- Microsoft SQL Server 2025 Standard, 16 Core (core license, without CALs)
- SQL Server 2025 Standard 1 User CAL and 1 Device CAL for the server + CAL model
- Microsoft SQL Server 2022 Standard, in case your application is approved for 2022 only
All offers are in the SQL Server category.
Frequently asked questions
Is SQL Server 2022 Express free, also in a company? Yes. Express is free and licensed for production use. Only the Developer and Evaluation editions are limited to development and testing.
Where do I get the download of SQL Server 2022 Express? Directly from Microsoft. Download Express only from there, not from third-party sites. For new installations, Express 2025 with 50 GB per database is the better choice, provided your application is approved for it.
What happens when the database reaches the limit? The database cannot grow any further; new data can then no longer be stored. Remedies are deleting or moving out old data, upgrading to Express 2025 or switching to Standard.
How many users may access Express? Microsoft states no upper limit for users or connections. In practice, 4 cores and 1,410 MB of buffer pool limit how many people can work smoothly at the same time.
Do I need CALs for SQL Server Express? No. Express is free and needs neither core licenses nor SQL Server CALs. If Express runs on a Windows Server, however, the users accessing it still need Windows Server CALs; details are in the guide
Windows Server CAL explained.
Does SQL Server Express run on Windows 11? Yes. SQL Server 2025 Express runs on Windows 10 and 11 as well as on Windows Server 2019 or later.
What is SQL Server Express LocalDB? A particularly lightweight variant of Express for developers. It runs in the user context and needs no configuration. It is not intended for a shared server.
Sources
Checked on 2026-11-10 against the publisher’s information:
- learn.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2025
- learn.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2022
- learn.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2019
- learn.microsoft.com/en-us/sql/sql-server/what-s-new-in-sql-server-2025
- www.microsoft.com/licensing/guidance/SQL
- learn.microsoft.com/en-us/sql/database-engine/install-windows/supported-version-and-edition-upgrades-2025
- learn.microsoft.com/en-us/sql/database-engine/install-windows/upgrade-to-a-different-edition-of-sql-server-setup
- learn.microsoft.com/en-us/sql/sql-server/install/hardware-and-software-requirements-for-installing-sql-server-2025