This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](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)
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?
|
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!
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.
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?
Again, first install latest service pack (SP) and then install latest cummulative update (CU) base on latest SP, see
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?
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
Erland,
Thanks for the tips, Link is very useful, appreciate it!
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.
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!
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.
Thanks everyone for your help and explanation.