Latest Builds of SQL Server 2014

Community Team

Published On: April 16, 2019

Categories: SQL Server 2014, SQL Server Builds 49


SQL Server 2014 End-of-Life

SQL Server 2014 reaches end of mainstream support on July 9th, 2019. So you should expect one more set of cumulative updates for SP2 and SP3, and then that will be it. Please plan accordingly.

Service Pack 3 Branch

On October 30th, 2018, Microsoft released SQL Server 2014 Service Pack 3. This will almost certainly be the final service pack for SQL Server 2014; you should start thinking about your upgrade strategy now, because history tells us the older SP branches will quickly slip out of maintenance mode.

The build number for SP3 is 12.0.6024.0 and there are 31 fixes documented in KB #4022619. Many of these improvements are updates that have been back-ported after being implemented in SQL Server 2016, 2017, and 2019. The service pack includes fixes from the SP2 branch up to and including Cumulative Update #13 (the fixes from CU #14 will follow).

Build Name Build # KB Article Date New fixes (public)
SP3 Cumulative Update #3    12.0.6259.0    KB #4491539 2019-04-16 4 (4)
SP3 Cumulative Update #2    12.0.6214.1    KB #4482960 2019-02-19 5 (5)
SP3 Cumulative Update #1    12.0.6205.1    KB #4470220 2018-12-12 16 (13)
Service Pack 3    12.0.6024.0    KB #4022619 2018-10-30 31 (31)

You can download the full edition here and the new Express Edition is available here. The updated feature pack should be available sometime in November.

Previously...

Microsoft has changed their servicing model slightly, in that for any particular branch, the CU download page only offers the most recent Cumulative Update. This is true no matter which KB article you came from. However, if you are looking for a specific Cumulative Update that doesn't happen to be the most recent one, you can download it from the Microsoft Update Catalog - just don't expect that to always have the latest.

Regardless of your branch or patch level, be sure to check out this CSS blog post and KB #2964518 : Recommended updates and configuration options for SQL Server 2012 / 2014, which is full of useful advice.

For help with acronyms used here or in the resources referenced, see Definitions of SQL Server release acronyms.

And of course, please always perform full regression testing before installing any SQL Server update in production. Kendra Little has a nice post about this.

Service Pack 2 Branch

Service Pack 2 (12.0.5000) was released on July 11, 2016, and includes 133 fixes and enhancements - including all of the fixes up to and including SP1 CU7. Those from SP1 CU8 should all be found in SP2 CU1, released August 25th. The official Knowledge Base article for SP2 is KB #3171021, and you can download the service pack here and the updated feature pack here. The latest CU for SQL Server 2014 Service Pack 2 is always available here, except in the case of certain out-of-band security updates, like Spectre/Meltdown (more info below).

Build Name Build # KB Article Date New fixes (public)
SP2 Cumulative Update #17    12.0.5632.1    KB #4491540 2019-04-16 3 (3)
SP2 Cumulative Update #16    12.0.5626.1    KB #4482967 2019-02-19 3 (3)
SP2 Cumulative Update #15    12.0.5605.1    KB #4469137 2018-12-12 8 (7)
SP2 Cumulative Update #14    12.0.5600.1    KB #4459860 2018-10-15 8 (6)
SP2 Cumulative Update #13    12.0.5590.1    KB #4456287 2018-08-28 4 (4)
SP2 Cumulative Update #12    12.0.5589.7    KB #4130489 2018-06-18 27 (16)
SP2 Cumulative Update #11    12.0.5579.0    KB #4077063 2018-03-19 12 (10)
SP2 Cumulative Update #10
Security Advisory
ADV180002 (CU10)
   12.0.5571.0    KB #4057117
KB #4052725
2018-01-16 5 (4)
SP2 Cumulative Update #9 12.0.5563 KB #4055557 2017-12-18 8 (7)
SP2 Cumulative Update #8 12.0.5557 KB #4037356 2017-10-17 15 (8)
SP2 Cumulative Update #7 12.0.5556 KB #4032541 2017-08-28 15 (8)
SP2 Cumulative Update #6 12.0.5553 KB #4019094 2017-08-08 29 (29)
SP2 Cumulative Update #5 12.0.5546 KB #4013098 2017-04-17 24 (21)
SP2 Cumulative Update #4 12.0.5540 KB #4010394 2017-02-21 30 (27)
SP2 Cumulative Update #3 12.0.5538 KB #3204388 2016-12-28 44 (39)
Security Bulletin
MS16-136 (CU)
12.0.5532 KB #3194718 2016-11-08 1 (1)
SP2 Cumulative Update #2 12.0.5522 KB #3188778 2016-10-18 18 (18)
SP2 Cumulative Update #1 12.0.5511 KB #3178925 2016-08-24 45 (36)
SP2 GDR builds below - for non-CU path
Security Advisory
ADV180002 (GDR)
   12.0.5214    KB #4057120    2018-01-16    1 (1)
Security Bulletin
CVE-2017-8516 (GDR)
12.0.5207 KB #4019093 2017-08-08 1 (1)
Security Bulletin
MS16-136 (GDR)
12.0.5203 KB #3194714 2016-11-08 1 (1)
Service Pack 2 12.0.5000 KB #3171021 2016-07-11 133 (53)

Some very interesting improvements in Service Pack 2, many of which were already included in SQL Server 2016. There were others, so this list should not be considered exhaustive, just OUR TOP 20:

Service Pack 1 Branch (Retired)

Service Pack 2 has been released, and it really should be where your efforts are going, if it is possible (yes, I know some people have to stay on older service packs for a variety of reasons).

RTM Branch (Retired)

If you're on RTM still (< 12.0.4000), there is an important security GDR/QFE that has been released through Security Bulletin MS15-058 and KB #3065718. This issue does not affect Service Pack 1. (And you should start planning to move to the SP2 branch now anyway.)

These posts are provided by the collective SentryOne team!


Comments