Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [cumulative-update]

19 questions
4
votes
1 answer

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: ) (Hypervisor) Tried to install "Cumulative…
Aleksey Vitsko
  • 6,148
  • 5
  • 39
  • 70
3
votes
1 answer

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 down, CU or GDR. However, for SQL Server 2019 this…
Simon A
  • 45
  • 1
  • 4
2
votes
1 answer

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 the SQL Instance name. The version of SQL Server…
dmcook
  • 21
  • 5
2
votes
1 answer

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 tables which causes it to crash overnight…
eek
  • 133
  • 1
  • 5
2
votes
2 answers

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 cluster roles to Node B. Install the patches on…
Bergmeister
  • 69
  • 5
2
votes
1 answer

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 "Basic" AGs (meaning that every database is in…
Rob Dalzell
  • 856
  • 7
  • 12
1
vote
2 answers

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 to reboot and update sever times but it's still…
Francesco Mantovani
  • 1,695
  • 14
  • 28
1
vote
0 answers

After installing SQL Server 2019 CU2, SQL Server Agent stops working

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 / kick off any jobs. Once I re-start the Agent…
Gaurav Gupta
  • 11
  • 1
0
votes
0 answers

SQL Server 2017 - Instance not applicable for update (CU31 GDR Build 14.0.3485.1)

I have a 2017 SQL Server, and I have tried applying the latest update to the instance (CU31 GDR, 14.0.3485.1) However, when running the update wizard, it shows that the instance is greyed out and "not applicable" for the update, even though it is…
Charles Humphries
  • 1
  • 1
0
votes
1 answer

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 it causes issues. All data and log files are on…
Brett
  • 101
  • 2
0
votes
1 answer

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. Currently, we routinely have the GDR updates applied by…
Eric
  • 3
  • 2
0
votes
2 answers

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 servers on different cumulative update versions (CU-15…
user2368632
  • 1,133
  • 1
  • 15
  • 33
0
votes
1 answer

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 lon coordinates. The "m" value is 0 for all rows. The…
bluppfisk
  • 111
  • 4
0
votes
0 answers

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, OpType: CloseDialog OpResult: Null) I've read that it…
Gabriele D'Onufrio
  • 277
  • 3
  • 14
0
votes
1 answer

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) - 12.0.6372.1". Since that security patch only fixes…
RonJohn
  • 694
  • 2
  • 12
  • 31
1
2