Questions tagged [patching]
The patching tag has no usage guidance.
92
questions
5
votes
3
answers
883
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 ...
- 63
2
votes
0
answers
86
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
0
votes
0
answers
21
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 ...
- 37
2
votes
2
answers
222
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.
...
0
votes
1
answer
66
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 ...
- 127
0
votes
0
answers
66
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 ...
- 101
0
votes
0
answers
30
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://...
- 227
0
votes
1
answer
2k
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
CU
https://docs.microsoft.com/en-us/sql/database-engine/install-...
- 2,070
2
votes
2
answers
274
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 ...
- 59
0
votes
2
answers
1k
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:...
0
votes
0
answers
68
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 ...
- 29
0
votes
1
answer
120
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 ...
- 21
1
vote
3
answers
258
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
...
2
votes
1
answer
1k
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 ...
- 197
0
votes
0
answers
136
views
What happens when using SCCM I deploy SQL server patch to a server with a different SQL version?
I have about 80 SQL servers that I want to patch. I have decided to use SCCM to get this done by preparing the following:
Create a device collection with all SQL servers.
Create a software update ...
- 175
0
votes
1
answer
259
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 ...
0
votes
1
answer
573
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....
- 54
0
votes
1
answer
151
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 ...
- 11
4
votes
1
answer
692
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 ...
- 403
0
votes
1
answer
30
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 ...
- 14.8k
2
votes
1
answer
1k
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/...
- 37
-1
votes
1
answer
289
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: ...
- 1
9
votes
3
answers
10k
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 ...
- 14.8k
1
vote
2
answers
255
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 (...
- 111
0
votes
0
answers
29
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 ...
0
votes
0
answers
304
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
0
votes
1
answer
59
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 ...
- 11
3
votes
1
answer
8k
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:...
- 4,408
4
votes
1
answer
108
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 ...
- 4,384
0
votes
0
answers
847
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-...
- 1
5
votes
1
answer
355
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 ...
- 141
0
votes
1
answer
410
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 ...
- 4,408
5
votes
2
answers
385
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 ...
- 339
3
votes
3
answers
1k
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 ...
- 193
1
vote
0
answers
97
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 ...
- 339
0
votes
1
answer
2k
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"...
- 417
0
votes
1
answer
357
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.
...
- 339
5
votes
1
answer
397
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 ...
- 1,678
1
vote
1
answer
57
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 ...
- 11
0
votes
1
answer
102
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-...
- 199
2
votes
1
answer
457
views
Error when upgrading SQL 2016 to SP2 - "The given key was not present in the dictionary."
I am trying to patch one node in a SQL Server 2016 Standard FCI. I removed the node from the cluster, and ran the installer, but it failed.
The summary file contained the following exit code / ...
- 21
0
votes
1
answer
3k
views
Methods for automating SQL CU patching?
For reasons that are not mine to address, we are looking for alternatives to WSUS and SCCM to automate SQL CU patching (particularly on SQL 2017+)
There are some neat Powershell solutions like this ...
- 5,998
4
votes
1
answer
5k
views
Oracle Database Server TNS Listener Remote Registration Vulnerability (CVE-2012-1675)
Some of our Internal DBs Oracle installed in Linux and Windows servers have been highlighted with the issue Oracle TNS Listener Remote Poisoning (CVE-2012-1675).
This security alert addresses the ...
- 41
2
votes
2
answers
3k
views
How does patching work in SQL Server?
I need a clarification on how below SQL Server service pack patching works.
Few of my servers are at below patch for SQL Server 2014 which has latest meltdown patch
12.00.5214 2014.120.5214.6 ...
- 2,117
1
vote
1
answer
2k
views
error code 3417 - after installing CU for SQL SERVER 2016 SP1
I am getting below error message after installing cumulative updates for SQL Server 2016 Sp1.
The description for Event ID 7024 from source Service Control Manager
cannot be found. Either the ...
- 14.8k
0
votes
1
answer
285
views
what is a safe way to stop the logreader?
Applying cumulative updates and service packs on sql server 2016 -
The server is involved in transactional replication, being a publisher,
The server is also a virtual machine.
I need to stop the ...
- 14.8k
4
votes
2
answers
4k
views
when applying a sql server cumulative update or service pack on a virtual machine - what could be a safe way of stopping VMWaretools?
While applying cumulative updates to sql server 2016 SP1, there are a bunch of services and applications that need to be stopped for the update to go on.
Among those is the very core of the virtual ...
- 14.8k
-1
votes
2
answers
324
views
information about licensing and patching SSAS [closed]
I have one server for data warehousing, and it has 2 instances of SSAS (SQL SERVER Analysis Services).
The data warehouses are not that big, less that 200GB, and I backup the whole thing on a daily ...
- 14.8k
5
votes
1
answer
731
views
Does SQL Server 2017 CU10 include CVE-2018-8273 hotfix?
Microsoft released SQL Server 2017 CU10 KB4342123 (14.0.3037.1) yesterday. I tried looking through the Hotfixes included list, but didn't see any reference to the recently released security update for ...
2
votes
1
answer
552
views
SQL Server Patching question [duplicate]
If I have an instance at SQL Server 2016 SP1-CU7-GDR (KB4057119) and want to jump over to the latest SP2 path, which patch or patches do I have to run?
SP2 = KB4052908
SP2-CU2 = KB4340355
SP2-CU2-GDR ...
- 21