14,501 questions
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.
Apply Service pack from Sql Server 2016 SP2 to Sql servr 2016 SP3
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 17%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
pdsqsql
431
Reputation points
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?
|
SQL Server | Other
{count} votes
-
MikeyQiaoMSFT-0444 3,300 Reputation points2024-06-05T03:23:06.45+00:00 Hi，pdsqsql
To successfully close the thread, please select and "Accept it" for an answer below that you are satisfied with. This will greatly benefit the forum and also enhance the searchability and reference value of the thread. We would greatly appreciate any effort you make towards the development of the forum!
Sign in to comment
Accepted answer
-
Olaf Helper 47,441 Reputation points2024-06-03T18:15:33.1233333+00:00 -
pdsqsql 431 Reputation points
2024-06-03T19:06:21.2133333+00:00 Olaf,
Thank you very much!
So I can directly install SP3 or SP3 + GDR?
Do I need to install any CU after CU7 for SP2?
-
Olaf Helper 47,441 Reputation points
2024-06-03T19:11:20.54+00:00 Again, first install latest service pack (SP) and then install latest cummulative update (CU) base on latest SP, see
-
pdsqsql 431 Reputation points
2024-06-03T21:13:37.41+00:00 Thanks so much, I got it!
I have currently Sql 2016 (SP2-CU7-GDR) so I need just Install SP3 and then any CU for SP3.
Is it SP or SP + GDR makes any difference for installation?
-
Erland Sommarskog 121.9K Reputation points MVP Volunteer Moderator2024-06-03T21:24:55.65+00:00 Install SQL 2016 SP3. Then apply the most recent GDR, see https://learn.microsoft.com/en-us/troubleshoot/sql/releases/sqlserver-2016/build-versions#sql-server-2016-service-pack-3-sp3-cumulative-update-cu-builds
-
pdsqsql 431 Reputation points
2024-06-04T03:55:10.95+00:00 Erland,
Thanks for the tips, Link is very useful, appreciate it!
Sign in to comment -
2 additional answers
Sort by: Most helpful
-
MikeyQiaoMSFT-0444 3,300 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.
-
pdsqsql 431 Reputation points
2024-06-04T03:57:40.95+00:00 Mikey,
Thank you very much for the providing SP and SP+GDR understanding details.
It's very helpful to know which one needs to be applied.
Appreciate your help!
-
MikeyQiaoMSFT-0444 3,300 Reputation points
2024-06-06T03:31:51.9633333+00:00 Hi，pdsqsq
I'm sorry to disturb you, we are waiting for your generous 'Accept it' response, which will greatly encourage and help our work.
Sign in to comment -
-
pdsqsql 431 Reputation points
2024-06-06T03:34:21.5533333+00:00 Thanks everyone for your help and explanation.