When is your SQL Server database out of Microsoft support? This is our guide to the Microsoft SQL Server database support lifecycle.
For early versions of SQL Server, the Microsoft support lifecycle varied over time. For the last 3 releases (SQL Server 2012, 2014 and 2016) Microsoft have followed a pattern of standard support for 5 years, with extended support for 10 years.
This means that every SQL Server database before SQL Server 2014 is now out of mainstream support. SQL Server 2012 went out of mainstream support in July this year, and SQL Server 2008's extended support will end in July 2019. However, depending on a number of factors such as which edition you have and which service pack you're on, it's not quite as simple as that.
We've created a simplified list of the SQL Server versions so far, and the relevant release and support end dates. Want the full, detailed version including each product version? Click here for a PDF download (16kb).
What's the difference between mainstream and extended support?
Mainstream support includes requests to change product design and features, security updates, and non-security updates. Comparatively, extended support includes security updates, but does not include change requests or non-security updates.
Why do I need SQL Server support?
Microsoft's support is good for updating the database product with new functionality and patching security issues. However, you still need the support of a specialist database administrator (DBA) to ensure that your database continues to stay stable, available and optimised for speed and efficiency.
Our support is different to Microsoft's. We don't just support the product - we make sure that your essential data stays safe and secure, while the applications making use of the database perform optimally.
Why do I need SQL Server support from Xynomix?
We have a team of experienced SQL Server consultants who are available when you need them, 24×7×365. This could be in the form of a managed service, or something less long-term, such as advice on a project or a one-off problem you might be experiencing. Maybe you're considering an upgrade or migration, a new disaster recovery plan, or would simply like a general database health check? To find out what we can do, please see our Microsoft SQL Server database support pages.
If you want a guide to the various types of SQL Server database, please see our SQL Server Version Guide.