2

A client asked me to update their SQL Server.

It's an 2016 base release (13.00.1601.00)

Microsoft already released the SP2 CU10. I know that cumulative updates are... like... cumulative, but even between service packs?

I can jump and install directly SP2 CU10 or do I need to install the last CU for SP1 before?

6

You can just install SP2 and then CU10. No need to install CU for SP1.

You can have a list of all SP + CU here

More relevant info :

If you have a large estate that needs to be patched, you can use dbatools - Update-DbaInstance

Also, dbatools has a really nice - build reference page that will tell you what the latest SP/CU is and End of support dates as well.

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.