question

sajithgh avatar image
0 Votes"
sajithgh asked Cathyji-msft answered

Patch updates for SQL Server

Can we install the below patch updates for SQL Server ? Do we have to consider any thing ?

KB5004228, 2021-07 Cumulative Update for .NET Framework 3.5 and 4.8 for Windows Server 2019 for x64 (KB5003538) Security Updates Jul 13, 2021

2021-08 Cumulative Update for Windows Server 2019 for x64-based Systems (KB5005030) (CVE-2021-36936) (CVE-2021-36942) (CVE-2021-36948) Security Updates Aug 10, 2021

2021-08 Servicing Stack Update for Windows Server 2019 for x64-based Systems (KB5005112) Security Updates Aug 10, 2021

KB5004870, 2021-08 Cumulative Update for .NET Framework 3.5 and 4.8 for Windows Server 2019 for x64 (KB5004332) Security Updates Aug 10, 2021

Cumulative Update Package 25 for SQL Server 2017 - KB5003830 Non Security Updates Jul 13, 2021
Update for SQL Server Management Studio (18.9.2) Non Security Updates Aug 17, 2021

sql-server-general
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.

Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered

Hi @sajithgh,

Can we install the below patch updates for SQL Server ? Do we have to consider any thing ?

Yes, you can. We suggest you using the latest patch for your SQL server instance.

Please perform a rolling upgrade for SQL AG. Before starting the rolling upgrade,

• Perform a practice manual failover on at least one of your synchronous-commit replica instances

• Protect your data by performing a full database backup on every availability database

• Run DBCC CHECKDB on every availability database

Please refer to the MS document Upgrading Always On Availability Group Replica Instances to get more information.


If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar thread.



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.

OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered sajithgh commented

Can we install the below patch updates for SQL Server ?

Sure, why not? That are common patches.

Do we have to consider any thing ?

An additional backup is never wrong.
And if you have a test system, test it there before.

· 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.

We don't have a test environment. The production is configured using Always On High Availabilty.

0 Votes 0 ·