Skip to main content

Expert Database Advice

24/7 Cover Available

UK Based DBAs

4.6 Google Rating

Trusted Channel Partner

Home » SQL Server End of Support Dates

SQL Server
End of Support Dates

All the latest SQL Server End of Support Dates, brought to you by The Database Experts

SQL Server Database Experts

SQL Server Database Experts

Running an SQL Server Database?

Whether you’re on SQL Server 2008, SQL Server 2019, or anything in between – it’s prudent to keep an eye on the SQL Server end of support dates.

Running an SQL Server Database?

Whether you’re on SQL Server 2008, SQL Server 2019, or anything in between – it’s prudent to keep an eye on the SQL Server end of support dates.


Contact an expert

Oracle Database Extended Support Deadlines

Oracle Partner Logo

SQL Server End of Support



Mainstream End of Support Date

SQL Server mainstream support typically covers the first five years from the date of initial release.

Updates include new features, performance, security, and quality of life additions.



Extended End of Support Date

SQL Server extended support delivers critical security patches for a limited time and, if you’re running on an Azure VM, it’s free.

For on-premises or hosted environments, extended support is available on a three-year agreement.

Be mindful that extended support does not include new features, functional improvements, or customer-requested fixes.

Why Does The Extended Support Deadline Matter?

If running an SQL Server estate, it’s essential to keep an eye on both the mainstream and extended support deadlines.

For a start, running any end of life software after support has ended poses grave security risks. Without security patch updates from Microsoft, there is an increased risk of a cyber attack or data loss.

Secondly, system performance will be impacted. Incremental updates provide stability for your database, so once these end, a database’s performance will begin to spiral downwards – sometimes rapidly. This affects BAU (business as usual) and puts organisations at increased risk of downtime.

Finally, it also means missing out on improvements and quality of life features available in newer versions of SQL Server

To bolster security, guarantee strong performance, and benefit from quality of life updates, it’s always best to migrate to the latest version of SQL Server. This is why keeping an eye on extended support deadlines is highly recommended.

SQL Server End of Life Dates

SQL Server Product Mainstream Support End Date Extended Support End Date
Microsoft SQL Server 2005 Apr 12, 2011 Apr 12, 2016
Microsoft SQL Server 2008 Jul 8, 2014 Jul 9, 2019
Microsoft SQL Server Compact 3.5 Apr 9, 2013 Apr 10, 2018
Microsoft SQL Server 2008 R2 Jul 8, 2014 Jul 9, 2019
Microsoft SQL Server 2008 R2 Parallel Data Warehouse Jul 8, 2014 Jul 9, 2019
Microsoft SQL Server Compact 4.0 Jul 12, 2016 Jul 13, 2021
Microsoft SQL Server 2012 Jul 11, 2017 Jul 12, 2022
Microsoft SQL Server 2012 Parallel Data Warehouse (Analytics Platform System) Oct 8, 2019 Mar 31, 2026
SQL Server 2014 Jul 9, 2019 Jul 9, 2024
SQL Server 2016 Jul 13, 2021 Jul 14, 2026
SQL Server 2017 Oct 11, 2022 Oct 12, 2027
SQL Server 2019 Jan 7, 2025 Jan 8, 2030
SQL Server Management Studio Continued support in line with Microsoft’s Modern Lifecycle Policy


Contact an expert

What are my Options If Extended Support has Already Expired?

Once Extended Support ends, your estate will receive no further updates.

This raises a handful of problem. Firstly, your performance will deteriorate over time. Secondly, you’ll no longer benefit from important quality of life features. And finally, any cyber security exploits will no longer be patched by Microsoft – putting you at potential risk of a data breach. 

The recommended option is upgrade to a more current version of SQL Server. This way, you’ll benefit from years of performance and security improvements, whilst benefiting from new features.

Independent Database Support, Delivered By Experts

Xynomix (zai-nom-icks) is one of the UK’s most experienced, independent providers of database support, managed services and strategic consultancy.

As a trusted Microsoft Gold Partner, our technical consultants are certified in all things SQL Server, making Xynomix one of the most qualified to help you identify your next steps.

Contact us if you’re approaching the end of extended support for your implementation of SQL Server, or have any additional questions.


Questions About SQL Server Database Support?

Recent Projects

Testimonials

“The optimisation, support and management of our Oracle database arrangement by Xynomix have increased the efficiency of the Oracle database and reduced the total running cost, whilst at the same time allowing us to provide a better service for staff and student end-users.”
IT ManagerFurther Eductaion
IT Manager
“A good on-site DBA team, optimised database systems and 24×7 Oracle Support from Xynomix mean that not much goes wrong for us. We are confident enough to make promises of excellent availability to our clients and employees, and they always get it.”
IT ManagerManufacturing Industry
IT Manager
“The Oracle database supports a key ERP application which holds information on our customers, invoicing and fulfilment and is therefore essential to the successful day to day running of our business. For over 6 years, Xynomix has provided us with outstanding database support and expertise. We work with a number of Xynomix senior Oracle DBA’s who know our systems inside and out.”
Application ManagerBanham Group
Application Manager
“Since 2003 Xynomix have provided support and consultancy for our Oracle and SQL Server databases. We’ve found their knowledge to be extensive and they’ve ensured that our databases run smoothly with very little downtime. The flexibility and creativity that Xynomix show when working with us enables us to meet budgets and hit our project timescales.”
IT ManagerTrade Union
IT Manager
“We chose Xynomix from the multiple providers approached for our support requirement for a number of reasons. Initially we were impressed with their responsiveness and deep technical knowledge of both Oracle and Microsoft SQL Server databases. Their flexibility in providing mentoring to our on-site team meant increased cost efficiency against the already competitive annual costs and consultancy rates. We’re fully confident in their understanding of our needs and see them as an extension of our own team.”
ICT Group ManagerSouthend-on-sea Borough Council
ICT Group Manager
“Xynomix worked with us on our recent Oracle License Review and provided us with valuable independent and confidential advice to help us through what can be a confusing and complex process. They provided useful expert knowledge on Oracle Licensing policy and also suggested how any gaps could be most effectively licensed. I would certainly recommend working with Xynomix on any future Oracle License Review.”
Enterprise ArchitectNorth Yorkshire County Council
Enterprise Architect
“We first approached Xynomix for advice on Oracle licensing. They saved us money there, and a year on we have a full database management contract with them.”
IT ManagerPubplic Sector
IT Manager
“As close to perfection as you can get! Overall a very successful conclusion to an important and complex technical transition and the entire process with Xynomix, from the initial discussions all the way through to this point, having been a very positive experience.” David Thomson, Forth Ports
David ThomasForth Ports
David Thomas
“We have been running Microsoft SQL Server for around two years now and the systems have been supported by Xynomix. Their SQL DBAs are competent and very customer-facing.”
Lead Database AdministratorManufacturing Industry
Lead Database Administrator
“We recently installed a new application which ran on Oracle but was unsure how to correctly license the environment. As a result, we engaged with Xynomix to advise on how best to do so. Xynomix ran an Independent Oracle License Review, which gave us full visibility on our license compliance. They highlighted the restrictions around various license types, whilst also detailing how to avoid any pitfalls moving forward.”
Network AdministratorDragon LNG Ltd
Network Administrator
“My team are always flat out ensuring that the Oracle database system is up and running without any problems. Sometimes when there is a larger issue we need a helping hand. Xynomix give us that option.”
Lead Database AdministratorRetail Sector
Lead Database Administrator
“We first approached Xynomix for advice on Oracle licensing. They saved us money there, and a year on we have a full database management contract with them.”
IT ManagerPublic Sector
IT Manager
“My team are always flat out ensuring that the Oracle database system is up and running without any problems. Sometimes when there is a larger issue we need a helping hand. Xynomix give us that option.”
Lead Database AdministratorRetail Sector
Lead Database Administrator
“Oracle knowledge is clearly excellent.”
Head of IFSManufacturing Industry
Head of IFS
Previous
Next

Protect your databases

If you’d like to know more about the security services we offer or would simply like peace of mind that your current database security setup is adequate, get in touch with us for a no obligation chat.

Get SQL Server Database Support now







    We may store your details and may contact you about our services. You can unsubscribe from these communications at any time. For more information on our commitment to protecting your privacy, please see our privacy policy.

    Close Menu