Apply Service pack from Sql Server 2016 SP2 to Sql servr 2016 SP3

pdsqsql 411 Reputation points
2024-06-03T15:12:26.5433333+00:00

Hello,

We need to Service pack for pour Sql Server 2016 which is currently on Microsoft SQL Server 2016 (SP2-CU7-GDR) (KB4505222) - 13.0.5366.0 (X64) and need to update SP3 latest pack.

Can I know How many SP and CU version I need to apply?

I know that in Sql 2017, we can apply latest CU and it can covered all SP/CU's so don't need to apply one by one but in Sql 2016 what's the path I have to follow?

If I see the SP's and CU's from my current version of SP2 then I found following so getting confused that I need to apply SP + CU all below listed?

|User's image

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,067 questions
{count} votes

Accepted answer
  1. Olaf Helper 42,386 Reputation points
    2024-06-03T18:15:33.1233333+00:00

    Can I know How many SP and CU version I need to apply?

    For both only the latest SP and base on the the latest CU.

    Updates are cummulative and includes all previous fixes, no need to install older one-by-one.

    1 person found this answer helpful.

2 additional answers

Sort by: Most helpful
  1. MikeyQiaoMSFT-0444 1,090 Reputation points
    2024-06-04T03:30:52.2466667+00:00

    Hi,pdsqsql

    "SP" stands for "Service Pack"

    "GDR" stands for "General Distribution Release"

    Is it SP or SP + GDR makes any difference for installation?

    A General Distribution Release (GDR) focuses more on security-related fixes and is primarily used to address specific security issues.

    Therefore, applying SP + GDR can provide a more comprehensive set of security fixes and safeguards. The specific contents of the updates can be viewed in the release notes.

    Best Regards,

    Mikey Qiao


    If you're satisfied with the answer, don't forget to "Accept it," as this will help others who have similar questions to yours.

    1 person found this answer helpful.

  2. pdsqsql 411 Reputation points
    2024-06-06T03:34:21.5533333+00:00

    Thanks everyone for your help and explanation.

    0 comments No comments