How to upgrade MSSQL server SP1 13.0.4451.0 to SP3 13.0.6300.2 ?

Anonymous
2022-12-21T09:44:55.537+00:00

Hi Team,

we are having a windows server 2016 Data center with following specifications :

Processor

Intel - compatible processor with a minimum speed of 1 GHz or a faster processor

RAM

Minimum 512MB

Hard Disk Space

4.2 GB of Disk Space

-In this windows server we are having a MSSQL server 2016 SP1 version 13.0.4451.0

-we need to upgrade this SQL server to 2016 SP3 version 13.0.6300.2

-May i know the proccess ?

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,705 questions
SQL Server | Other
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Bjoern Peters 8,921 Reputation points
    2022-12-21T09:59:59.373+00:00

    Hi @Anonymous

    according to Microsoft installation instruction for the SQL Server 2016 Service Pack 3:

    Install Instructions

    Note: You must have administrative rights on the computer to install SQL Server 2016 SP3.

    Microsoft SQL Server 2016 SP3 Update:

    Review the Microsoft SQL Server 2016 SP3 Release Notes
    Download the following file from the "DOWNLOAD" section on this page to your device:
    SQLServer2016SP3-KB5003279-architecture-language.exe
    Once the download is complete, click RUN to begin the installation process immediately or SAVE to install at a later time.

    If you want to have more detailed instructions, you may refer to the following blog post:
    https://sqlmastersconsulting.com.au/SQL-Server-Blog/applying-sql-server-service-packs/

    This post is related to SQL Server Availability Groups, but you also can follow it for a standalone (with a small adaption)

    I hope my answer is helpful to you,

    Your
    Bjoern Peters

    If the reply was helpful, please upvote and/or accept it as an answer, as this helps others in the community with similar questions. Thanks!

    1 person found this answer helpful.
    0 comments No comments

  2. NikoXu-msft 1,916 Reputation points
    2022-12-22T07:55:00.823+00:00

    Hi @Anonymous ,

    List of fixes included in SQL Server 2016 SP3
    Microsoft SQL Server 2016 service packs are cumulative updates. SQL Server 2016 SP3 upgrades all editions and service levels of SQL Server 2016 to SQL Server 2016 SP3. In addition to the fixes that are listed in this article, SQL Server 2016 SP3 includes hotfixes that were included in SQL Server 2016 Cumulative Update 1 (CU1) to SQL Server 2016 SP2 CU17.
    For more information about the cumulative updates that are available in SQL Server 2016, see SQL Server 2016 build versions.

    You can download it in this article. Then update as Peter said.

    Best regards,
    Niko

    ----------

    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.

    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.