All Questions
Tagged with cumulative-update sql-server
15 questions
-1
votes
0
answers
42
views
Does original primary need to be patched as part of CU patching or does Microsoft support a delayed patch of the original primary node?
https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/upgrading-always-on-availability-group-replica-instances?view=sql-server-ver16
This document applies for cumulative ...
- 3,489
3
votes
1
answer
794
views
SQL Server does CU+GDR also install the CU as well as the GDR
I'm trying to determine if the CU+GDR updates installs the CU in addition to the GDR.
I think I understand the differences between CUs and the GDR security fixes. And the different paths you can go ...
- 45
0
votes
0
answers
287
views
SQL 2022 ssisdb always on support - patching requires AG recreation? And does auto failover detection still apply to SQL 2022?
My setup is a 2 node AG.
SQL 2022 Enterprise.
SSISDB is part of the AG, and I have configured SSIS high availability (enabled SSIS Support for Always On) as per this documentation: https://learn....
- 3,489
0
votes
1
answer
65
views
Changes to MSSQL System databases from Cumulative Updates
What sort of changes are made to System tables (master / model / msdb) by Cumulative Updates? For context, I have SQL servers that have AlwaysOn Groups, and am looking at a way to roll back updates if ...
- 101
0
votes
1
answer
1k
views
SQL Server, CU's and Server Reboots
I'm relatively new to CU's and SQL server. We have a few SQL Servers with dev, qa and prod instances (SQL 2017) on them. This is probably not the best idea, but that's what we have right now. ...
- 3
1
vote
2
answers
7k
views
Servicing Update for SQL Server 2019 RTM GDR (KB4517790) - Install error - 0x80070643
SQL Server is still working smoothly but I noticed that I have an alert on the Windows Update that says:
Servicing Update for SQL Server 2019 RTM GDR (KB4517790)
Install error - 0x80070643
I tried ...
- 1,629
0
votes
2
answers
302
views
Can you safely log ship between primary and secondary servers on different cumulative update versions?
Need to update primary from 2019-CU14 to 2019 CU15 and a few hours/days later update secondary to CU 15 once the primary is deemed stable. Can you safely log ship between primary and secondary ...
- 1,127
2
votes
1
answer
972
views
Unable to Install SQL 2017 CU 28
I am in the process of upgrading our SQL 2017 servers to the current CU. I have ran across two systems that won't allow me to apply the update. In the SQL installer, I see below text when I click on ...
- 21
1
vote
1
answer
3k
views
Can I downgrade from SQL Server 2017 CU25 to CU20?
New instance of SQL Server 2017. I chose to install up to CU25 during the initial installation. Been using the database for a few months, but it seems to have a memory leak when using memory-optimized ...
- 123
2
votes
2
answers
1k
views
SQL cluster update - Failover to un-patched node
So when updating a two node cluster, our procedure is this:
Backup all databases.
Failover all SQL cluster roles to Node A.
Install the patches on Node B (passive).
Restart Node B.
Failover all SQL ...
- 69
2
votes
1
answer
685
views
DB_CHAINING lost on on planned Availability Group failover for SQL Server 2019 cumulative update
I'm looking for ideas on how to determine a plausible root cause for DB_CHAINNG problems encountered when we recently performed a planned AG failover.
We're using SQL Server 2019 Standard Edition with ...
- 856
-1
votes
3
answers
723
views
CVE-2021-1636 security update for SQL Server
Microsoft just released this security update CVE-2021-1636 for a Security Vulnerability. Not much information is available at the moment. Any input on the following points will be highly appreciated
...
- 11
0
votes
1
answer
1k
views
Installing an older CU over a Security Patch?
According to this Microsoft link, SQL Server 12.0.6372.1 requires any system with at least SQL 2014 SP3, so my predecessor installed it over SP3. Now the version is "2014 (SP3-CU-GDR) (KB4535288)...
- 658
0
votes
0
answers
43
views
Cumulative Update 3 & 4 Caused Synchronous Commit Failures in Availability Groups
So this week I was patching our SQL Servers that host our availability groups. Never had an issue with them in the past, fairly standard process. I have two servers (call them SQL1 and SQL2) in the ...
1
vote
0
answers
83
views
After installing SQL Server 2019 CU2, SQL Server Agent stops working [duplicate]
After installing SQL Server 2019 CU2, SQL Server Agent starts consuming too much CPU resulting into skip job schedules.
Although the agent service is running but it looks like hang and didn't process ...
- 11