Short answer: as of October 2026, SQL Server 2012, 2014 and 2016 are past end of support; SQL Server 2017 and 2019 are in extended support (to October 2027 and January 2030); SQL Server 2022 and 2025 are in mainstream support (extended support to January 2033 and January 2036). This page lists Microsoft’s dates for each version, explains mainstream, extended and Extended Security Updates, and links to our step-by-step guides for upgrading, migrating, tuning and reviewing SQL Server.
Updated October 13, 2026. Written by Nathan Jaskot, founder of Everconnect Data Systems, a US-based, veteran-owned database consulting firm founded in 2010. Technical facts were checked against Microsoft documentation on that date (sources at the bottom).
SQL Server support dates (2012 to 2025)
| Version | Released | Mainstream support ends | Extended support ends | Status in October 2026 |
|---|---|---|---|---|
| SQL Server 2012 | May 2012 | July 2017 | July 2022 | Past end of support. The Extended Security Updates program ended in July 2025. |
| SQL Server 2014 | June 2014 | July 2019 | July 2024 | Past end of support. Extended Security Updates year 3 runs to July 2027. |
| SQL Server 2016 | June 2016 | July 2021 | July 14, 2026 | Past end of support. Extended Security Updates available for up to three years, to July 2029. |
| SQL Server 2017 | September 2017 | October 2022 | October 2027 | In extended support (security updates only). |
| SQL Server 2019 | November 2019 | March 2025 | January 2030 | In extended support (security updates only). |
| SQL Server 2022 | November 2022 | January 2028 | January 2033 | In mainstream support. |
| SQL Server 2025 | November 2025 | January 2031 | January 2036 | In mainstream support (Microsoft’s current recommendation for on-premises and hybrid). |
Dates are from Microsoft’s lifecycle pages, checked October 13, 2026. Microsoft lists exact end times in Pacific time on each page, so we show months except where the day matters. Always confirm the date for your exact version and edition on Microsoft’s page before you plan.
What the terms mean
- Mainstream support: the first phase, with security and functional updates and full support.
- Extended support: the second phase, with security updates and limited support but no new features.
- End of support: after extended support ends, Microsoft no longer ships regular security updates or technical support for that version. The software keeps running.
- Extended Security Updates (ESUs): a paid, temporary program for certain versions that delivers critical security updates after end of support. It does not include new features or technical support for SQL Server itself. See Microsoft’s ESU documentation.
How to find out which version you run
-- Major version: 11 = 2012, 12 = 2014, 13 = 2016, 14 = 2017, 15 = 2019, 16 = 2022
SELECT @@SERVERNAME AS server_name,
SERVERPROPERTY('ProductVersion') AS product_version,
SERVERPROPERTY('ProductMajorVersion') AS major_version,
SERVERPROPERTY('Edition') AS edition,
SERVERPROPERTY('ProductLevel') AS service_pack;
Guides: upgrade, migrate, tune, protect
Upgrade and migrate
- SQL Server 2016 end of support: what to do now – what changed on July 14, 2026 and your options How to upgrade SQL Server safely: side-by-side vs in-place – side-by-side vs in-place, with rollback Upgrade SQL Server or move to Azure? A decision guide – decision table for older databases SQL Server pre-upgrade checklist – what to check before you upgrade production SQL Server migration with minimal downtime: methods compared – methods compared, with a cutover runbook Moving SQL Server to Azure: architecture options – VM vs Managed Instance vs Azure SQL Database, and sizing How to choose a SQL Server migration consultant – questions to ask and red flags
Performance, health and recovery
- Why is our SQL Server slow? A 10-step triage – ten steps with queries Vendor blames SQL Server? How to verify independently – a playbook to measure both sides SQL Server without a DBA: minimum maintenance checklist – the minimum cadence How to prove SQL Server backups and disaster recovery work – a restore-test runbook Independent SQL Server assessment: what a good one covers – scope, deliverables and a sample report outline
Earlier Everconnect posts
- How to choose between Azure SQL Database, SQL Managed Instance and SQL VM
- What we learned migrating legacy databases to Azure SQL Managed Instance
- How to minimize downtime during a database migration
- Lift-and-shift vs. refactor
- The ultimate SQL Server health checklist
- How to identify and fix blocking issues in SQL Server
Tools and services
- SQL Server Health & Risk Check – a free self-assessment (about 3 to 5 minutes, no database access required)
- SQL Server Migration & Upgrade Assessment – a free self-assessment that does not connect to your databases
- Database migration services
- Database performance tuning
- Managed database services
- Migration case studies and health check case studies
Want a fixed-price starting point? The SQL Server Health Check is $499 per server: about 200 read-only checks across 10 risk areas, a scored report in 3 business days and a walkthrough with our team. See an example report.
Frequently asked questions
SQL Server 2017 and 2019 are in extended support (security updates only), and SQL Server 2022 and 2025 are in mainstream support. SQL Server 2012, 2014 and 2016 are past end of support.
Extended support for SQL Server 2017 ends in October 2027 according to Microsoft’s lifecycle page. Mainstream support ended in October 2022.
Extended support for SQL Server 2019 ends in January 2030. Mainstream support ended in March 2025.
Mainstream support for SQL Server 2022 ends in January 2028 and extended support in January 2033.
Mainstream support for SQL Server 2025 ends in January 2031 and extended support in January 2036.
SQL Server 2016 reached end of extended support on July 14, 2026. Extended Security Updates can bridge up to three years, to July 2029.
SQL Server 2014 extended support ended in July 2024 and SQL Server 2012 in July 2022. SQL Server 2014 Extended Security Updates year 3 runs to July 2027; the SQL Server 2012 program ended in July 2025.
Mainstream support includes security and functional updates and full support. Extended support includes security updates and limited support but no new features.
Microsoft stops shipping regular security updates and technical support for that version. The software keeps running, but security and compliance risk grows, so plan an upgrade, a move to Azure, or a temporary Extended Security Updates bridge.
Run SELECT SERVERPROPERTY(‘ProductMajorVersion’). 11 is SQL Server 2012, 12 is 2014, 13 is 2016, 14 is 2017, 15 is 2019 and 16 is 2022.
Sources (checked October 13, 2026)
- SQL Server 2016 lifecycle
- SQL Server 2017 lifecycle
- SQL Server 2019 lifecycle
- SQL Server 2022 lifecycle
- SQL Server 2025 lifecycle
- SQL Server 2014 lifecycle
- Microsoft SQL Server 2012 lifecycle
- What are Extended Security Updates?
- SQL Server end of support options
About the author. Nathan Jaskot is the founder of Everconnect Data Systems, Inc., a US-based, veteran-owned database and technology consulting company he started in 2010. Everconnect works with SQL Server, PostgreSQL, MySQL, Oracle, Azure and AWS. Learn more about Everconnect.







