Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [patching]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
37 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....
variable's user avatar
  • 3,636
-1 votes
1 answer
64 views

When patching SQL FCI, how to ensure there will not be a failover to the node being patched?

This is about patching a 2 node SQL FCI. Say node1 is the current active node. When I am patching the node2, how do I ensure that there won't be a automatic failover to node2 even if node1 crashes ...
variable's user avatar
  • 3,636
0 votes
0 answers
75 views

Patching 19c including MRPs

If I have 19.19 patch and latest MRP and I want to patch up to 19.22 do I need to manually remove the MRPs or are they going to be removed by the opatch ? Thanks in advance!
paganini's user avatar
  • 118
2 votes
1 answer
61 views

PostgreSQL: Update multiple data while using the binding variable

I create the new table and insert 10 records into the new table as below: userdb=> CREATE TABLE test_tbl(ID INT PRIMARY KEY, STR VARCHAR); CREATE TABLE userdb=> do $$ begin for r in 1..10 loop ...
Alvin Kam's user avatar
0 votes
0 answers
111 views

SSIS Database Always on AG and Patching

I am after clarification, when we patch a SQL Server Always on AG environment that has the SSIS database in the AG we remove the SSIS database, patch failover, patch and add the SSIS DB back into the ...
Stockburn's user avatar
  • 419
0 votes
1 answer
758 views

Oracle Patch 19.17 fails with: patch 34086870: Archive::Zip->writeToFileNamed returned 4

The current oracle patch 19.17 and OJVM was applied with opatch apply successfully with no errors. Patch 34468114: WINDOWS DATABASE BUNDLE PATCH 19.17.0.0.221018 Patch 34411846: OJVM RELEASE UPDATE ...
r0tt's user avatar
  • 1,028
0 votes
1 answer
266 views

Whether the latest GDR from Microsoft includes all prior GDRs?

I am looking at patching SQL server using the latest GDR (KB 5014356) from here: https://learn.microsoft.com/en-us/sql/database-engine/install-windows/latest-updates-for-microsoft-sql-server?view=sql-...
variable's user avatar
  • 3,636
2 votes
0 answers
23 views

What is the approach to handle failover and compatibility issues when patching FCI nodes?

I have FCI with 2 nodes. Following is steps to patch the nodes: Remove node from Possible owners Patch the inactive node Add the node to the Possible owners Failover to inactive node Leave it running ...
variable's user avatar
  • 3,636
0 votes
1 answer
699 views

Db2 Security Bulletins points to v11.5.8 fixpack that don't yet exists, is it?

I have found three security bulletins IT40893, IT40781, IT41338 that all as solution recommends: "Upgrade to DB2 Version 11.5.8 or higher", but I can't find Db2 fixpack v11.5.8 on official ...
folow's user avatar
  • 339
-2 votes
1 answer
2k views

What is the difference between CU-GDR and GDR?

There are 2 paths to patching SQL server. Either the SQL CU (cumulative) upgrade or GDR (critical) upgrade. CU includes functionality fixes and security fixes (https://support.microsoft.com/en-us/...
sqlguy's user avatar
  • 1
1 vote
2 answers
6k 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 ...
Francesco Mantovani's user avatar
5 votes
4 answers
3k views

Patching SQL Server 2016

Most of my SQL Servers are on 2016 SP2. The security group have identified that I need a later security update applied and as SP2 is out of support this year I planned to just patch it up to SP3. The ...
Garry's user avatar
  • 73
2 votes
1 answer
775 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 ...
dmcook's user avatar
  • 21
0 votes
0 answers
129 views

Process for upgrading MySQL Master-Slave to a new release series version

I have several MySQL servers that I want to upgrade from 5.7.31 to the most recent release series (5.7.36 I believe), but in one test I found that replication on one server set failed, and it required ...
vPilot's user avatar
  • 47
2 votes
2 answers
2k views

Are SQL Security Updates Cumulative? Are the vulnerabilities corrected with one Security Update also covered by the next Security Update?

I recently patched SQL Servers that had SP3 and CU4 with the latest available Security Update. After CU4 there are 2 Security Updates available, one from 2020/02/11 and the other one from 2021/01/12. ...
Sergio Cerdas's user avatar
0 votes
1 answer
388 views

How can i disable opatch job?

I have a docker 12.2 oracle db for localhoat dev. I don't care if it's patched regularly. I'm seeing constant errors In qopatch queries. I think its triggered by some batch job at startup and maybe at ...
George's user avatar
  • 127
0 votes
0 answers
293 views

MariaDB upgrade fails on replication slaves

I am having problems when a MariaDB replication slave wants to upgrade its tables after a server was patched. This happens consistently with any sort of OS patching. The system has several slave ...
WerKater's user avatar
  • 101
0 votes
0 answers
123 views

What is the intended method for automatically/streamlinedly updating minor/patch PostgreSQL versions on Windows?

I currently run PostgreSQL 12.4 on Windows 10. Since the "BigSQL" distribution is no longer around, the only choice is to use the EnterpriseDB installer for the initial installation: https://...
user16508174's user avatar
0 votes
2 answers
22k views

On what basis do we decide whether to use GDR or CU?

I have installed sql server 2019 in Jan 2021. We are planning to patch the sqlserver and from this link there are 2 options: GDR CUx (where x is a number) CUx + GDR (where x is a number) https://...
variable's user avatar
  • 3,636
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 ...
Bergmeister's user avatar
0 votes
2 answers
7k views

SQL Server Setup failure - Cached MSI files are missing

Trying to apply SQL Server 2008 SP4 to an old instance I now have to look after, but the installer is failing with TITLE: SQL Server Setup failure. SQL Server Setup has encountered the following error:...
Mike Spencer-Jones's user avatar
0 votes
0 answers
230 views

Oracle 12cR2 - Upgrade Catalog Command Taking Too Much Time

I patched my database (Windows database bundle patch 12.2.0.1.201020 (31654782)). There are 6 instances on the server. After the patch, the UPGRADE CATALOG command I ran on RMAN for the first 5 ...
jrdba123's user avatar
0 votes
1 answer
344 views

Installing Patches on MS SQL Server Tips [closed]

What is preventing Agent Service from starting after: Failing to install CU. Running a successful repair after disabling HIPS. Background: Installing CU's for Microsoft SQL Server I found I have an ...
Keybonesabi's user avatar
1 vote
4 answers
826 views

SQL Server 2012 patching failure - The language of SQL Server instance MSSQLSERVER does not match the language expected by the SQL Server update

I've picked up the support for a SQL Server 2012 instance on a server at our German site and need to apply SQLServer2012SP4-KB4018073-x64-ENU. The patching is failing with the installer showing error ...
Mike Spencer-Jones's user avatar
2 votes
1 answer
2k views

Issue patching SQL Server 2016 to SP2 CU 15

Trying to update all our SQL 2016 servers to SP2 CU 15, but am running into: The version of SQL Server instance MSSQLSERVER does not match the version expected by the SQL Server update. The installed ...
Keith Clark's user avatar
0 votes
1 answer
336 views

Any issue encountered after implementing SQL Server 2017 CU22? [closed]

We all are aware of SQL Server 2019 CU7 issue (Microsoft recalled the patch). Now I am cautiously optimistic to apply SQL Server 2017 CU22. I wanted to reach out to the SQL Server Community to know if ...
SQLSince2010's user avatar
0 votes
1 answer
897 views

Oracle 18c opatch util cleanup not working

System: [oracle@hostname:/opt/oraclegrid/18]$ uname -a SunOS hostname 5.11 11.4.24.75.2 sun4v sparc sun4v Database: Oracle 18c 18.10 (April 2020 patch), RacOneNode setup Opatch OPatch Version: 12.2....
lear1's user avatar
  • 79
0 votes
1 answer
248 views

SQl server 2008R2 Performance issue after SP3 update

We have recently applied SP3 KB2979597 and Security Update Patch KB4057113 on Sql server 2008R2 but after that our couple stored procedures runs slow, it's taking almost 4 to 5 hours, but normally it ...
pds's user avatar
  • 11
4 votes
1 answer
2k views

How do I prevent my Windows Server from being automatically rebooted by SQL Server updates?

Some SQL Server updates have happened outside the maintenance window, which have caused the server to be rebooted. How can I stop this from happening again in future? Below is what I can see when ...
RGO's user avatar
  • 423
0 votes
1 answer
183 views

Is there a way to optimize the process of uninstalling and installing SSMS?

in terms of patching sql server 2016 to the latest cumulative patches, I found out that stopping the services helps avoiding lots of inconveniences, specially if there is log shipping and replication ...
Marcello Miorelli's user avatar
2 votes
1 answer
4k views

How am I supposed to update PostgreSQL on Windows, once installed, without manually installing new installers?

I have PostgreSQL 11.5 installed on Windows 10. It was installed with the EnterpriseDB installer, which is the only one which exists these days. If I go to https://www.postgresql.org/download/windows/...
Gregorg's user avatar
  • 37
-1 votes
1 answer
615 views

The best way to patch Oracle Rac One Node [closed]

what is the best way (best practice) to patch Oracle Rac One Node (2 nodes - node1 and node2, every node has own database home and GRID home = 4 homes)? Thank you System: Oracle Solaris 11 DB: ...
lear1's user avatar
  • 1
9 votes
3 answers
23k views

How can I install the SQL Server PowerShell module on an offline machine?

I have some SQL Server machines that cannot connect to any external sites. I have been using PowerShell more and more when managing databases, so I definitely need this module to be installed so ...
Marcello Miorelli's user avatar
1 vote
2 answers
1k views

Properly determine SQL Server version and update level

I have some existing code which tries to read the current version of SQL Server that's installed for a particular instance name by using a WMI query. It checks the first dotted part of the VERSION (...
Miral's user avatar
  • 111
0 votes
0 answers
40 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 ...
TEDDY HORTON-TURNER's user avatar
0 votes
0 answers
747 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 ...
eek's user avatar
  • 123
0 votes
1 answer
116 views

Do we need to shutdown DB/Stop DB service before Windows server patching

Before patching Windows server, do we need to shut down any DB or stop DB service. If we need to shutdown a MongoDB on a node(Windows server) which is part of a replica set, what we need to before ...
satya's user avatar
  • 11
4 votes
1 answer
14k 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:...
Aleksey Vitsko's user avatar
4 votes
1 answer
198 views

Why should I apply a CU for SP2 that was released after the release of SP3?

Checking SQL Server 2014 build versions to identify the right update for my server I got a little confused as what update to use. Did some research and found out I should Apply the latest Service Pack ...
Ronaldo's user avatar
  • 5,091
0 votes
1 answer
3k views

Using WSUS to Patch SQL Server

So, it's been a while since the discussions about patching changes to SQL Server by Microsoft in these links (WSUS for SQL server patching & https://www.brentozar.com/archive/2016/08/windows-...
Melanie's user avatar
5 votes
1 answer
481 views

SQL Server CUs vs SPs + CUs? [duplicate]

I recently applied the latest SQL Server CUs (Cumulative updates) for their current SPs (Service Packs) on our SQL Servers. I'm getting the sense that I actually really need to update all of them to ...
PeterDaniels's user avatar
0 votes
1 answer
1k views

Windows Server and SQL Server updates and patching - and how to rollback (revert) if necessary

Say we have a server as SQL Server 2017 on Windows Server 2016, both have some pending updates recently Below few questions: What's the correct order of installing updates - first Windows, and then ...
Aleksey Vitsko's user avatar
5 votes
2 answers
761 views

Will one SQL instance work whilst the other 2 are patched?

My change request to patch 3 SQL instances on the same server was denied because of one instance - they say a server reboot is fine, but not a few hours downtime. Seeing as each instance is ...
jack's user avatar
  • 379
3 votes
3 answers
2k views

SQL Server Always-On Availability Groups Patching

My SQL server farm has been neglected with patching OS level & SQL server level (because they are critical systems, outages are hard to come by). An option is to patch the secondary nodes of our ...
Daniel Nash's user avatar
1 vote
0 answers
227 views

Has my repair fixed incomplete patching?

I am patching a SQL2008R2 Express Edition instance. On the first failed attempt, all seemed to be fine - SQL loaded, dbs online, @@VERSION returned the expected results, but errors were found during ...
jack's user avatar
  • 379
0 votes
1 answer
3k views

SQL Cannot patch the latest CU4 for SQL 2014 SP3

I cannot patch the latest CU4 for SQL 2014 SP3. Checked "view installed program", 4500181 is already installed. but when I use "Select @@version" against my SQL instance, it still shows "12.0.6259.0"...
DBALUKE HUANG's user avatar
0 votes
1 answer
553 views

CU8 for 2016SP2 error

When upgrading to CU8 on 2016SP2, I get the following error Final result: The patch installer has failed to update the shared features. To determine the reason for failure, review the log files. ...
jack's user avatar
  • 379
5 votes
1 answer
453 views

Does Service pack have all the changes in a cumulative update

I have always thought that all the changes in the CU's are rolled up into the next services pack. I recently was looking at changes in SQL 2016 SP2, and SQL 2016 CU15 for SP1. I was surprised to see ...
DMDM's user avatar
  • 1,738
1 vote
1 answer
104 views

Azure SQL Database patch and update doubts

It is known that Microsoft automates the patch and update of Azure SQL Database. But, some times applications must be tested before being applied any type of patch or update, because there's a ...
Art Software's user avatar
0 votes
1 answer
274 views

Error when running SQL Server 2014 64-bit Import/Export Wizard

I have previously asked this question on Stack Overflow, but I am not sure if it should be migrated to DBA Stack Exchange. https://stackoverflow.com/questions/55186094/error-when-running-sql-server-...
J Weezy's user avatar
  • 199