question

sajithgh avatar image
0 Votes"
sajithgh asked CarrinWu-MSFT commented

SQL 2017 latest update (CU23) - KB5000685 for Always Availability Group


Planning to install SQL 2017 latest update (CU23) - KB5000685 for Always Availability Group (Primary & Secondary rpelicas)

https://www.microsoft.com/en-us/download/details.aspx?id=56128

Is there any prerequisities or any other tasks needs to be performed befor the installation ? Please advise.

sql-server-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @sajithgh, we have not get a reply from you. Did the answers could help you? If there has an answer helped, do "Accept Answer". If it is not work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

0 Votes 0 ·

1 Answer

CarrinWu-MSFT avatar image
0 Votes"
CarrinWu-MSFT answered CarrinWu-MSFT edited

Hi @sajithgh,

Please get the prerequisites from How to Upgrade or Patch Alwayson Availability Group Instances?, see below:
80450-update-ag.png


When upgrading a SQL Server instance that hosts an Always On Availability Group (AG) to a new SQL Server version, to a new SQL Server service pack or cumulative update, or when installing to a new Windows service pack or cumulative update, you can reduce downtime for the primary replica to only a single manual failover by performing a rolling upgrade (or two manual failovers if failing back to the original primary). For the details, please refer to Rolling Upgrade Basics for Always On AGs


Best regards,
Carrin


If the answer is helpful, please click "Accept Answer" and upvote it.
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.



update-ag.png (179.4 KiB)
· 6
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Cumulative Update Package 23 for SQL Server 2017 - KB5000685(Non Security Updates-Feb 25, 2021) is installed as per the above steps.

Unable to install Security Update for SQL Server 2017 RTM CU(KB4583457)-Security Updates(Jan 13, 2021).
https://www.microsoft.com/en-us/download/details.aspx?id=102619

Please advise.

0 Votes 0 ·

Hi @sajithgh,

KB4583457 - Description of the security update for SQL Server 2017 CU22
KB5000685 - Cumulative Update 23 for SQL Server 2017

You cannot update it from high version to low version.


Best regards,
Carrin


If the answer is helpful, please click "Accept Answer" and upvote it.


0 Votes 0 ·

Thanks for the help. KB5000685 is Non Security Updates and KB4583457 is securty update. What is the difference between these ? Can Ignore KB4583457 since I have already installed KB5000685 ?

0 Votes 0 ·
Show more comments