Questions tagged [cumulative-update]
The cumulative-update tag has no usage guidance.
20 questions
-1
votes
0
answers
41
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,499
3
votes
1
answer
791
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
286
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,499
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
301
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
970
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
684
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
200
views
cumulatively calculate the distance along a line
I am using Postgis to:
calculate the cumulative distance in metres along the line
store the cumulative distance in "m"
I have a table with points on this line and each row holds lat and ...
- 111
0
votes
0
answers
236
views
After a reboot and latest CU for sqlserver 2017 I get this annoying message
After a reboot and latest CU for sqlserver 2017 I get this annoying message (the xxxxx was a number)
SSBDT: Dialog timer delete during registration (did:
xxxxxxxxxxxxxxxxxxxxxxxxxxxx:Initiator, ...
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
1
answer
138
views
Install old Cumulative Update SQL Server 2016 Standard
We were running on SQL Server 2016 Standard Edition 2016 SP2-CU4 on our ALWAYS-ON HA cluster.
Due to some recent issues one of our nodes got corrupted and we had to replace it with a new node. Since ...
- 43
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
0
votes
0
answers
879
views
Should I install all cumulative updates/service packs when doing a clean install of SQL Server 2016? 2019?
Going to set up a new database instance from scratch. Debating between SQL Server 2016 and 2019.
I've never installed a service pack or cumulative update on previous instances, mostly because ...
- 123
4
votes
1
answer
15k
views
Error installing SQL Server Database Engine Services Instance Features - The User Log directory in the registry is not valid
We have a SQL Server:
Microsoft SQL Server 2017 (RTM-CU14-GDR) (KB4494352) - 14.0.3103.1 (X64) Mar 22 2019 22:33:11 Enterprise Edition (64-bit) on Windows Server 2016 Datacenter 10.0 (Build 14393:...
- 5,964