Service Pack upgrade of Microsoft SQLServer 2016

Avyayah 1,271 Reputation points
2022-11-10T21:56:39.67+00:00

Currently we are on Microsoft SQL Server 2016 (SP2-GDR) (KB4583460) - 13.0.5108.50 (X64) May 20 2022 20:28:29 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows Server 2016 Standard 10.0 <X64> (Build 14393: ) (Hypervisor) .

Latest SP release is 5003279 Microsoft SQL Server 2016 Service Pack 3 (SP3) Latest SP CVE-2015-6420. Should I go for this release or
SP3 + GDR 13.0.6419.1 KB5014355 June 14, 2022

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,948 questions
0 comments No comments
{count} votes

Accepted answer
  1. Seeya Xi-MSFT 16,471 Reputation points
    2022-11-11T02:38:08.47+00:00

    Hi @Avyayah ,

    Introducing some concepts for you.
    SQL Patch Description:
    RTM: stands for Release to Manufacturing, which is the original release version of the product and the default version when downloaded from the CD or MSDN. However, nowadays, when you download the SQL Server version, there is also a version with SP integrated.
    Hotfix: An issue that needs to be fixed. Every year, there are many bugs or vulnerabilities in SQL Server, and the fixes for these issues are defined as Hotfix.
    Cumulative Update (CU): Cumulative update package, which consists of Hotfixes. CU is released every 8 weeks, so there will be CU1, CU2 ......, etc. Each latest CU version contains Hotfixes from the previous CU. CU is installed based on the original version (RTM) or SP.
    Service Package (SP): SP is the package with the most integrated Hotfixes, which are officially and fully tested. SP is the largest patch file for a SQL Server product release, and is released every 12 to 18 months.
    GDR (General Distribution Release) is different from CU in that each latest CU contains cumulative updates based on RTM/SP, while GDR contains only serious updates. They have the same baseline.
    Each latest CU contains fixes for issues integrated with the previous CU, and each SP contains fixes for issues included in the previous SP. Now look at the picture again.
    259275-image.png

    According to SQL Server 2016 build versions, you can install it step by step, installing SP3 first and then GDR.
    259322-image.png

    Best regards,
    Seeya


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


1 additional answer

Sort by: Most helpful
  1. Bjoern Peters 8,876 Reputation points
    2022-11-10T23:08:26.917+00:00

    Hi @Avyayah

    as you are on the GDR track...

    YES, I would also suggest - as you already mentioned - installing SP3 and then the corresponding Security Update KB5014355.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.