5

I have always thought that all the changes in the CU's are rolled up into the next services pack. I recently was looking at changes in SQL 2016 SP2, and SQL 2016 CU15 for SP1.

I was surprised to see that none of the KB in SP1CU15 was mentioned in the SP2. What am I missing?

7

According to SQLServerBuilds SP1 CU15 was released after SP2.

SP1 CU15 was released on 2019-05-16, SP2 was released on 2018-04-24.

Given that from SQL 2017 there will no longer be any service packs, this is no longer relevant moving forwards, but in the past Microsoft would release fixes in parallel for supported service packs. As an example this kb article describes an issue that had a fix that was included in two separate CU's, CU15 for SP1 and CU7 for SP2.

For confirmation of the data on SQLServerBuilds we can check the file details on both SP2 and CU15 SP1

In addition to this as pointed out by David Browne, there is a development and test overhead for all new SP's, meaning an SP does not necessarily contain all fixes in previous CU's by date - this is due to the time taken for finalising and testing the SP.

  • 3
    Also a SP may not have all the fixes released in the previous CU, as the SP takes a while to finalize and test. – David Browne - Microsoft Jun 17 at 14:32
  • Thanks Guys, I have a server which is at 13.0.4224.16. Originally I thought I will install SP2 and then latest CU(CU7) to get to the latest version. But after this question and clarification about dates, I was wondering if I can get by, by just installing the latest SP1CU which is CU 15 and get all the fixes? Does Microsoft release latest CU's with latest fixes to all the services packs? Probably not for ever, if not how long do I have before Microsoft stops releasing CU for a previous SP. – jesijesi Jun 18 at 1:03

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.