By: Ben Snaidero
Overview
As with most Microsoft products, Microsoft provides mainstream support for a product for 5 years after its initial release. This means that for the first 5 years you may see new smaller features or enhancements added to the product along with any bug fixes and security patches. After this mainstream support ends you will usually get another 5 years of extended support at which time you can only expect bug fixes and security patches.
The below table outlines these dates (MM/DD/YYY) for the versions of SQL Server since 2005. For an up-to-date listing of the dates you can use the following link: Microsoft Product Lifecycle.
| Version | Release Date | End of Mainstream Support | End of Extended Support |
|---|---|---|---|
| SQL Server 2005 | 01/14/2006 | 04/12/2011 | 04/12/2016 |
| SQL Server 2008 | 11/06/2008 | 07/08/2014 | 07/09/2019 |
| SQL Server 2008 R2 | 07/20/2010 | 07/08/2014 | 07/09/2019 |
| SQL Server 2012 | 05/20/2012 | 07/11/2017 | 07/12/2022 |
| SQL Server 2014 | 06/05/2014 | 07/09/2019 | 07/09/2024 |
| SQL Server 2016 | 06/01/2016 | 07/13/2021 | 07/14/2026 |
| SQL Server 2017 | 09/29/2017 | 10/11/2022 | 10/12/2027 |
| SQL Server 2019 | 11/04/2019 | 02/28/2025 | 01/08/2030 |
| SQL Server 2022 | 11/16/2022 | 01/11/2028 | 01/11/2033 |
