Many accounting packages, ERP systems, point-of-sale software and web applications install SQL Server Express by default. It is free and works well at the start, but its limits are easy to hit as the business grows. This guide compares Express with Standard edition and lists the signs that it is time to upgrade.
Express vs Standard at a glance
| Express 2025 | Express 2022 / 2019 | Standard 2025 | Standard 2022 / 2019 | |
|---|---|---|---|---|
| CPU used | Lesser of 1 socket or 4 cores | Lesser of 1 socket or 4 cores | Lesser of 4 sockets or 32 cores | Lesser of 4 sockets or 24 cores |
| Buffer pool memory | 1,410 MB | 1,410 MB | 256 GB | 128 GB |
| Max database size | 50 GB | 10 GB | 524 PB | 524 PB |
| SQL Server Agent (scheduled jobs) | No | No | Yes | Yes |
| Backup compression | No | No | Yes | Yes |
| Basic availability groups, failover clusters | No | No | Yes | Yes |
SQL Server 2025 raised the Express database limit from 10 GB to 50 GB, which helps, but the CPU and memory caps are unchanged.
Signs your application has outgrown Express
- The database is close to the size limit. At 10 GB (or 50 GB on 2025) Express stops accepting new data, and the application usually fails with an error about the primary filegroup being full.
- Reports and month-end runs are slow even though the server has plenty of RAM: Express uses only about 1.4 GB for its buffer pool, so most data is read from disk.
- More users, same server: Express uses at most four cores, so extra users queue up instead of using the rest of the CPU.
- No scheduled backups or maintenance: without SQL Server Agent, backups and index maintenance depend on Windows Task Scheduler scripts that are easy to forget.
- Your software vendor asks for Standard once you pass a number of users or companies.
Moving from Express to Standard
You do not need to rebuild the database. SQL Server setup includes an Edition Upgrade option: run setup from the Standard installation media, choose Maintenance > Edition Upgrade, select the Express instance and enter your Standard product key. The instance name, databases and logins stay the same. Back up every database first, and check with your software vendor that the target version is supported.
You can also install Standard as a new instance and restore the databases into it, which suits a move to new hardware.
Which version of Standard?
- SQL Server 2025 Standard: the highest Standard limits (32 cores, 256 GB) and security updates until January 2036.
- SQL Server 2022 Standard: widely certified by ERP and accounting vendors, updates until January 2033.
- SQL Server 2019 Standard: for software certified only for 2019, updates until January 2030.
Always choose the newest version your application vendor supports. Compare them on our SQL Server page.
Don't forget the operating system
SQL Server runs on Windows Server, which is licensed separately. Building a new database server? See Windows Server 2025 Standard, and read how many Windows Server licences you need.
Frequently asked questions
Can I use Express in production?
Yes. Express is free for production use within its limits.
What about the Developer editions?
Developer editions are free but licensed only for development and testing, not for live business data.
Will my application notice the change from Express to Standard?
No. Applications connect the same way; they simply get more CPU, memory and database space.
Featured Products
- £29.99
£59.99- £29.99
- Unit price
- / per
- £39.99
£79.99- £39.99
- Unit price
- / per
- £29.99
£59.99- £29.99
- Unit price
- / per
- £29.99
£59.99- £29.99
- Unit price
- / per
- £29.99
£69.99- £29.99
- Unit price
- / per
- from £19.99
£39.99- from £19.99
- Unit price
- / per
- £39.99
£79.99- £39.99
- Unit price
- / per
- £24.99
£59.99- £24.99
- Unit price
- / per

