Questions tagged [patching]
The patching tag has no usage guidance.
101
questions
0
votes
1
answer
5k
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 ...
- 6,178
4
votes
1
answer
7k
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,169
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 ...
- 15.8k
0
votes
1
answer
397
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 ...
- 15.8k
6
votes
2
answers
6k
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 ...
- 15.8k
-1
votes
2
answers
401
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 ...
- 15.8k
5
votes
1
answer
815
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
573
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
2
votes
1
answer
183
views
Vulnerability in Server from SQL Server 2008 R2
We scanned our systems and got a high vulnerability reported in a server.
One of the thing that got flagged was MS12-060, which is related to MS Office 2003 Web Components that gets installed along ...
- 71
5
votes
1
answer
5k
views
Missing DatabaseMail.exe.config after applying SQL Server 2016 SP2 CU1
After applying SQL Server 2016 SP2 CU1 (SP2 was already applied) to SQL Server 2016 on several different Windows Server 2016 installations, we noticed that Database Mail stopped working. Mails were ...
- 91
2
votes
1
answer
328
views
Can't resume synchronization after patch failed on secondary node of Availability Group
I applied Service Pack 4 on secondary node of an Availability Group. It failed so I restored the whole VM for the secondary node to an earlier version, and now the data is not synchronizing.
I have ...
- 392
1
vote
4
answers
5k
views
Never do SQL Server patching? [closed]
I am aware of Brent's post Why Nobody Ever Patches Their SQL Servers in this regard.....and with one of my friend, please assume one such scenario, where nearly 100 SQL Servers are never patched. ...
0
votes
1
answer
25
views
Meltdown Patching can be turned on as needed
Experts,
Need to know if anyone has witnessed or found such settings while patching SQL servers for Meltdown patches.
Our sys admins informed that OS patches for Meltdown can be turned ON/OFF bases ...
- 2,169
2
votes
2
answers
457
views
Windows patching on 3 node Always On Availability Group [closed]
We have a three node Always On Availability Group cluster. We normally patch the passive nodes (N2, N3), fail over from N1 to N2, patch N1, and then fail back to N1. N1 and N2 are sync, N3 is async.
...
- 93
2
votes
2
answers
2k
views
Recent patches for vulnerability attacks for SQL Server 2014 SP2 version
Keeping in mind the recent vulnerability attacks patches like Spectre and Meltdown , I would like to patch my SQL Server 2014 SP2 (12.0.5000)
1.Description of the security update for SQL Server 2014 ...
- 1,580
1
vote
1
answer
709
views
As a MongoDB DBA, what do I need to know about the meltdown/spectre vulnerabilities?
If you didn't hear, a set of related vulnerabilities were recently discovered that impact virtually all processors sold over the last decade. You can find more technical detail about the meltdown/...
- 10.9k
14
votes
1
answer
2k
views
As a SQL Server DBA, what do I need to know about the meltdown/spectre vulnerabilities?
If you didn't hear, a set of related vulnerabilities were recently discovered that impact virtually all processors sold over the last decade. You can find more technical detail about the meltdown/...
- 9,954
1
vote
1
answer
563
views
how long can CU and SP be different across a SQL Server Always on Cluster nodes
Does Microsoft support running SQL Server Always On clusters for a short period of time on different CU and/or SP levels. For a week or a couple of days?
- 11
0
votes
1
answer
365
views
How to know which security updates to install?
I am using KB2977316 and KB3045324 for this example. These are security updates for SQL Server 2014 RTM.
KB2977316 is version 12.0.2381.0 published 6/2/2015
KB3045324 is version 12.0.2269.0 ...
- 7,919
1
vote
1
answer
968
views
What is the difference between SQL Server 2012 SP4 vs SP3 with CU-10?
Sorry, may be very stupid question but what is the difference between SQL Server 2012 SP4 and SQL Server 2012 SP3 + CU-10?
- 1,163
7
votes
2
answers
5k
views
Apply the latest Service Pack and Cumulative Update
I have given an RTM version of SQL Server 2014 and I need to apply the latest SP (currently SP2) and CU (currently CU8). Do I need to apply SP1 first? Or can I straight move to SQL Server 2014 SP2 CU8 ...
- 644
0
votes
1
answer
40
views
Un-Install OS Patch (KBs) in Physical PRODUCTION Servers - Consequences [closed]
We have our PRODUCTION Database and Application Servers which are Physical Servers .
Recently , the October month OS Patches (specific KBs) are little problematic and reported by Microsoft too that ...
- 1,580
2
votes
2
answers
2k
views
Error after applying SQL Server 2008 R2 Upgrade 10.50.6542 (Latest Build)
First the problem: Since I applied the latest patch to SQL Server 2008 R2 (released on March 3, 2016) that should have taken my server to build 10.50.6542 I can't connect anymore. This patch is to ...
- 773
2
votes
0
answers
207
views
Cannot apply patches to SQL Server 2016
I have a SQL Server 2016 instance version is SP1-GDR - 13.0.4202.2. I want to apply the Cumulative Update packages but they will not install. When you step through them, you cannot select any options ...
- 51
3
votes
1
answer
3k
views
Uninstall SQL Patch with SkipRules
I've recently installed Cumulative Update 6 for SQL Server 2014 SP2. I installed it on the passive node of a 2 node cluster. To install the patches I paused the role in cluster manager and ran the ...
- 464
4
votes
2
answers
4k
views
Automate the patching of SQL Severs on Windows
We are getting approximately 50-100 lower environments SQL Servers newly build.
We are assigned some basic task of SQL DBA which includes one as patching SQL Servers.
How can this be achieved, ...
- 2,169
0
votes
1
answer
239
views
Oracle CPU vulnerabilities and Database Proactive Bundle Patch
I've applied the latest Oracle 12c Database Proactive Bundle Patch (DBBP).
My security team runs scans and April 2015 CPU (amongst other CPUs) continues to show up as vulnerabilities.
I need to ...
- 197
0
votes
1
answer
2k
views
Datapatch -verbose fails with erros
After succsessfuly doing the opatch apply for Oracle Patch Apr 2017, datapatch Fails with the following error:
D:\oracle\cfgtoollogs\sqlpatch\sqlpatch_4540_2017_07_07_22_18_44
MOS Note 1609718.1
D:\...
- 998
0
votes
1
answer
8k
views
Oracle 12c Opatch failed with error code 73
I don't find a solution for the following Opatch Error:
D:\oracle\product\12.1.0\dbhome_1\cfgtoollogs\opatch\opatch2017-07-05_22-29-53PM_1.log
05.07.2017 22:29:53] OPatch invoked as follows: '...
- 998
0
votes
1
answer
36
views
Will OS Patching affect the SQLLOG file Growth in SQL Server
Last Sunday we have the OS Patch for the month of June.
Can someone help me understand if the monthly OS patching increases the SQLLOG file in SQL Server ?
Is there any linkage between the OS Patch ...
- 1,580
5
votes
2
answers
11k
views
What is the different between GDR security update and CU security update
What is the different between GDR security update and CU security update?
I am looking to understand difference between the below two updates. If I apply KB3194724, would it also include KB 3194721?
...
- 51
1
vote
2
answers
635
views
CU Update to Sql Server 2014 hangs for 7 hours
How to improve time for patching installs? Applying patches on test Hyper-V VM's prior to production patching. It is a two node Always-On AG.
From Detail.txt when I let it run:
(01) 2017-04-26 15:...
- 21
1
vote
1
answer
639
views
SQL Server 2008 Patch on Clustered Server
I am patching SQL server, going from SP1 to SP3, on a cluster while following Microsoft's instructions on how to do it.
Every single place I read tells me to do the following:
Pause the passive ...
- 111
0
votes
2
answers
35
views
SQL 2008 Version Number Question
When I run the SQL Server 2008 Setup Discovery Report, all of the components (Database Engine Services, Management Tools - Complete, etc) show as version 10.3.5852.0.
However, I cannot find any ...
- 73
1
vote
1
answer
2k
views
SQL Server Service Pack Questions
We are currently running our database server on SQL Server RTM; i.e. no service packs or cumulative updates have been installed.
We need to install the latest Service Pack for SQL Server.
I had the ...
- 13
1
vote
1
answer
2k
views
Remove a SQL Server Patch only visible in View Installed Update List
Kindly help me regarding our issue with a Clustered Environment's applied patch.
The situation is: We removed a SQL Patch: GDR 6248 for SQL Server 2012 (KB3194721) (64 bit). When we successfully ...
- 11
2
votes
4
answers
3k
views
How often to update SQL Server? [duplicate]
I am a new DBA at a company that has never had a DBA before me. SQL Servers are never upgraded unless it is part of a Windows Update on the server. Service Packs (or CUs) are never installed. We have ...
- 103
2
votes
1
answer
1k
views
Installing service packs with SQL Server services stopped
I always installed Service Packs on the servers with running SQL Server Services. This time I am faced with the situation where I have to patch multi-instance SQL Server that has its services stopped ...
- 498
1
vote
1
answer
3k
views
SQL Server updates missing from WSUS
I don't use WSUS for SQL Server patching because we have so many different compatibility issues, requirements and downtime OLA's that it makes it impossible to deploy anything in this way - not sure ...
- 1,774
7
votes
3
answers
1k
views
How far to go when Validating a SQL Service Pack install?
When applying a Service Pack to a production SQL server, I usually have a planned downtime window of around 30 minutes.
Having been bitten before, and discovering that a required precondition like ...
- 6,178
1
vote
0
answers
3k
views
ORA-20013: DBMS_QOPATCH ran mostly in non install area
I have problems with patching p23054246_121020_Linux-x86-64 on an oracle database 12.1.0.2.0 on a Red Hat Enterprise 7.2. The patch installation seems to work but when I do the datapatch it fails:
-...
- 998
2
votes
1
answer
833
views
SQL Server 2014 (12.0.4439.1) to SP2 (12.5000) service start failure
In what seems to be eerily familiar to the oh-so-famous SSISDB SP1 fiasco, I've hit a snag while upgrading our DEV server to SQL 2014 SP2.
The base version was SP1+CU5 (12.0.4439.1). We have SSISDB ...
- 3,804
8
votes
1
answer
5k
views
What are the "GDR" vs "QFE" hotfixes for SQL Server 2008 R2 SP3?
I'd always assumed that higher patch numbers were necessarily later releases, but now I'm not so sure.
Looking at the SQL Server Build List for SQL Server 2008 R2 SP3, there are two possible ways to ...
- 9,954
0
votes
1
answer
673
views
SQL Server 2012 Patching Service Pack and CU Question
I am tasked with updating a SQL Server 2012 from a version(11.0.5623.0) before SP3 all the way to SP3 CU2. Can I install both patches without a reboot until afterwards? All the documents I have found ...
- 932
4
votes
4
answers
4k
views
patching SQL Server with Availability Group and Secondary Replica
Scenario: SQL Server 2014 CU6. 1 AG with 2 databases (compatibility level 100). Failover Cluster with 3 nodes on Windows Server 2012 R2. Primary Availability Replica on node 1 and node 2. Secondary ...
- 974
0
votes
0
answers
446
views
How do I create a oracle database patch list overview?
I need to create an list for Oracle database patch versions for a recurring audit on patch states. It will check whether the current patch state of Oracle database meets the required patch state of a ...
- 998
3
votes
1
answer
467
views
Apply SQLServer Service Pack to a Single Node Cluster
I have to apply a SQL Server 2008 R2 Service Pack to a Single Node Cluster.
The other node died and new hardware has been ordered.
Is there anything weird to worry about?
Normally we'd apply the ...
- 79
0
votes
1
answer
115
views
Patching SQL Server 2012
If I apply Cumulative Update 3 in SQL Server 2012 SP1, do I still have to do Cumulative update 1 and 2 before I can apply CU 3? And also, how would you know what CU's or hot fixes that has already ...
- 617
0
votes
1
answer
1k
views
Pointing DB to new Oracle home in primary and standby oracle database
I needed to apply a security patch to production database. To minimize the outage time, I cloned the oracle home and applied the patch to this newly created oracle home. With production DB there is a ...
- 45