Quick verdict
Choose Express for small production databases, desktop and small server applications, learning and prototypes, provided each database stays under 50 GB (SQL Server 2025), the workload is happy with about 1.4 GB of buffer pool and 4 cores, and you can schedule jobs outside SQL Server. Choose Standard when you need more data, memory or cores, scheduled jobs through SQL Server Agent, Database Mail, log shipping or basic availability groups, backup compression and encryption, or Transparent Data Encryption. If you are on SQL Server 2022 or earlier, Express is limited to 10 GB per database and Standard to 24 cores and 128 GB of buffer pool, so check the version you actually run.
SQL Server Express is Microsoft's free entry-level edition. Microsoft describes it as "ideal for learning and building desktop and small server data-driven applications", and the downloads page describes it as suitable for development and production for desktop, web and small server applications. From SQL Server 2025, Express includes everything that used to be in the separate Express with Advanced Services download, which is discontinued: the editions page names SQL Server Data Tools (SSDT), machine learning integration and Full Text Search. LocalDB, a lightweight user-mode variant for developers, is still part of Express.
SQL Server Standard is the lower-priced of the two paid editions. It runs the same Database Engine and T-SQL as Express, so applications move between them without code changes, but it allows much more hardware, adds SQL Server Agent and several availability, backup and security features. In SQL Server 2025 Microsoft raised the Standard limits to the lesser of 4 sockets or 32 cores and 256 GB of buffer pool memory, and made Resource Governor available in Standard.
Two other changes in SQL Server 2025 matter if you are comparing editions: Web edition is discontinued, and the single Developer edition is replaced by Standard Developer and Enterprise Developer, free editions licensed for development and test only. See Express vs Developer for those.
Side by side
| Aspect | Express | Standard |
|---|---|---|
| Cost | Free download | Paid: per core, or Server + CAL, or subscription (see Pricing) |
| Production use | Allowed | Allowed |
| Compute per instance (2025) | Lesser of 1 socket or 4 cores | Lesser of 4 sockets or 32 cores (24 cores in 2022 and earlier) |
| Buffer pool memory per instance (2025) | 1,410 MB | 256 GB (128 GB in 2022) |
| Columnstore cache / memory-optimized data (2025) | 352 MB each | 32 GB each |
| Maximum relational database size (2025) | 50 GB per database (10 GB in 2022 and earlier) | 524 PB |
| SQL Server Agent and Database Mail | Not included | Included |
| High availability and DR | No log shipping, failover cluster instances or availability groups | Log shipping, two-node failover cluster instances, basic availability groups (two replicas, one database) |
| Backup features | No backup compression, no encrypted backup, no backup to S3-compatible storage | Backup compression, encrypted backup, backup to S3-compatible object storage |
| Security and governance | Always Encrypted, row-level security, auditing and dynamic data masking; no TDE; no Resource Governor | Adds Transparent Data Encryption and, from 2025, Resource Governor |
| Main trade-off | Free, but small memory and CPU caps and no built-in job scheduling | Licence cost, and still below Enterprise for HA and performance features |
Key differences
Resource limits, and how they changed in SQL Server 2025
Microsoft's SQL Server 2025 scale limits table sets these caps per instance of the Database Engine: Express uses at most the lesser of 1 socket or 4 cores, 1,410 MB for the buffer pool, 352 MB for the columnstore segment cache and 352 MB of memory-optimized data per database, with a 50 GB maximum relational database size. Standard uses at most the lesser of 4 sockets or 32 cores, 256 GB for the buffer pool, 32 GB for the columnstore segment cache and 32 GB of memory-optimized data per database, with a 524 PB maximum database size.
For readers on older versions: the SQL Server 2022 page lists Express at 10 GB per database (the compute and memory caps were the same as 2025), and Standard at the lesser of 4 sockets or 24 cores with a 128 GB buffer pool. Upgrading an Express instance to SQL Server 2025 raises the database size cap to 50 GB but does not raise its memory or core limits.
The buffer pool cap is the one people often miss: Express can be installed on a large server, but it will use only about 1.4 GB of memory for cached data pages, so a database near the 50 GB cap may read from disk far more than the same database on Standard. This is an editorial point, not a measured result; test with your own workload.
Scheduled jobs and alerts
Express has no SQL Server Agent and no Database Mail in either 2022 or 2025, according to Microsoft's editions pages. Agent is what Standard uses to run scheduled backups, index maintenance and other jobs, and to send alerts. On Express you need an outside scheduler, for example Windows Task Scheduler or cron running sqlcmd scripts, and your own alerting. For a production Express database, plan this before go-live: a database without scheduled backups is a serious and avoidable risk.
High availability, disaster recovery and backups
Express has no log shipping, no Always On failover cluster instances, no availability groups of any kind, and no backup compression or encrypted backup. Database mirroring, which Microsoft lists as deprecated, is available on Express only as a witness. Standard includes log shipping, failover cluster instances with two nodes, and basic availability groups, which Microsoft limits to two replicas and one database per group. Standard also supports backup compression, encrypted backups, backup to S3-compatible object storage and accelerated database recovery. Full availability groups with multiple databases and readable secondaries need Enterprise; see Standard vs Enterprise.
Features that are the same, and features Express gained in 2025
Many programmability and security features are available in every SQL Server 2025 edition, including Express: the native json data type and JSON indexing, the vector data type, Query Store, columnstore indexes, In-Memory OLTP (within the memory caps above), table partitioning, data compression, CLR integration, linked servers, temporal tables, Always Encrypted, row-level security, dynamic data masking, ledger and auditing. Because Express now includes the former Advanced Services features, Full Text Search and basic machine learning integration are part of the standard Express install in 2025; in 2022 they needed the separate Express with Advanced Services download.
Features Standard has and Express lacks in 2025 include Transparent Data Encryption, Extensible Key Management, Resource Governor, change data capture, optimized locking, buffer pool extension, Service Broker as a server (Express is client only), publishing for replication (Express is a subscriber only), SQL Profiler and the Database Engine Tuning Advisor.
Pricing and licensing
Express is a free download and needs no licence purchase.
Standard (SQL Server 2025), listed on Microsoft's SQL Server 2025 pricing sheet in October 2026, in US dollars, as open no-level estimated retail prices (your reseller price may differ): USD 3,945 per 2-core pack under per core licensing, or USD 989 per server plus USD 230 per client access licence (CAL) under Server + CAL, where every user or device that accesses the server needs a CAL. Subscription licensing through volume licensing is listed at USD 1,418 per year per 2-core pack. Microsoft also offers pay-as-you-go billing for Standard through Azure Arc. Check Microsoft's licensing guide for minimum core counts and virtualisation rules before costing a server.
Pricing checked on the vendors' official pages on 7 October 2026. Prices change; confirm before buying.
Where each one leads
Express strengths
- Free, and licensed for production use
- From SQL Server 2025, 50 GB per database and the former Advanced Services features (Full Text Search, SSDT, machine learning integration) in one edition
- Same engine and T-SQL as Standard, so applications move up without code changes
- Shares many 2025 features with paid editions, including the json and vector types, Query Store and row-level security
- LocalDB option for lightweight local development
Standard strengths
- Up to the lesser of 4 sockets or 32 cores and 256 GB of buffer pool in SQL Server 2025
- SQL Server Agent and Database Mail for scheduled jobs and alerts
- Log shipping, two-node failover cluster instances and basic availability groups
- Backup compression, encrypted backups and Transparent Data Encryption
- Resource Governor, available in Standard from SQL Server 2025
Limitations
Express limitations
- 50 GB per database in 2025 (10 GB in 2022 and earlier)
- Buffer pool capped at 1,410 MB and compute at the lesser of 1 socket or 4 cores
- No SQL Server Agent or Database Mail, so jobs and alerts need an external scheduler
- No availability groups, failover clustering, log shipping or backup compression
Standard limitations
- Paid per core, per server plus CALs, or by subscription
- Basic availability groups are limited to two replicas and one database each
- Online index operations, full availability groups and many query processing features are Enterprise only
- Batch mode operations are limited to a degree of parallelism of 2
When to choose each
Choose Express if
- Each database will stay well under 50 GB on SQL Server 2025
- The workload is small enough for about 1.4 GB of buffer pool and 4 cores
- You are learning, prototyping, or shipping a desktop or small server application
- You can run backups and maintenance from an external scheduler
Choose Standard if
- A database is approaching the Express size cap or needs more memory or cores
- You want SQL Server Agent jobs, alerts and Database Mail
- You need log shipping, failover clustering or a basic availability group
- You need Transparent Data Encryption, encrypted backups or backup compression
- You want Resource Governor without paying for Enterprise (SQL Server 2025)
When neither is right
- You only need a database for development and testing: use the free Standard Developer or Enterprise Developer edition. See Express vs Developer.
- You need multi-database availability groups, readable secondaries or online index rebuilds: those are Enterprise features. See Standard vs Enterprise.
- You would rather not manage servers or licences at all: compare a managed service in Azure SQL Database vs SQL Server.
- You have outgrown Express and want to avoid licence fees: an open source engine may fit. See SQL Server vs PostgreSQL.
Final recommendation
Start on Express if your data and load are small and you are comfortable scheduling backups outside SQL Server; in SQL Server 2025 its 50 GB per database cap and bundled Advanced Services features make it more usable than in earlier versions. Move to Standard when you need more memory or cores, SQL Server Agent, basic high availability, encrypted or compressed backups, or TDE. Before buying, check which SQL Server version you will run: the limits quoted here are for SQL Server 2025, and SQL Server 2022 Express and Standard have lower caps.
Frequently asked questions
What is the SQL Server Express database size limit?
In SQL Server 2025 the maximum relational database size for Express is 50 GB per database. In SQL Server 2022 and earlier it was 10 GB. The limit is per database, not per instance, according to Microsoft's editions pages.
Is SQL Server Express free for production?
Yes. Express is free and Microsoft describes it as suitable for production for desktop, web and small server applications, within its limits: in SQL Server 2025, 50 GB per database, 1,410 MB of buffer pool memory and the lesser of 1 socket or 4 cores.
Does SQL Server Express have SQL Server Agent?
No. Express does not include SQL Server Agent or Database Mail in SQL Server 2025 or 2022. Use an external scheduler such as Windows Task Scheduler with sqlcmd scripts, or move to Standard.
What happened to SQL Server Express with Advanced Services?
It is discontinued in SQL Server 2025. Microsoft states that Express now includes all the features previously in Express with Advanced Services, such as Full Text Search, SQL Server Data Tools and machine learning integration.
Can I upgrade from Express to Standard?
Yes. Microsoft's supported upgrades page for SQL Server 2025 lists edition upgrades from Express to Standard, Enterprise or Developer, and in-place upgrades from Express in SQL Server 2014 SP3 and later to Express, Standard or Enterprise in SQL Server 2025.
What happened to SQL Server Web edition?
Web edition is discontinued in SQL Server 2025. Microsoft's upgrade page lists Standard or Enterprise as the upgrade targets for earlier Web edition installations.
Sources
- Microsoft Learn: Editions and supported features of SQL Server 2025
- Microsoft Learn: Editions and supported features of SQL Server 2022
- Microsoft Learn: What's new in SQL Server 2025 (edition changes)
- Microsoft: SQL Server 2025 pricing sheet (PDF)
- Microsoft: SQL Server downloads (Express and Developer)
- Microsoft Learn: Supported version and edition upgrades (SQL Server 2025)
Checked October 2026.
How we research comparisons: our editorial method.