Questions tagged [patching]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
21 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 ...
0
votes
0answers
15 views

Error i updating SP2- CU11 on MS SQL server 2016

I am trying to update SP2-CU5 (KB4475776) to SP2-CU11 on Microsoft SQL Server 2016. I am getting below error again and again. Please suggest the possible resolution for this error.
0
votes
0answers
56 views

how to open SSIS 2016 with SSMS 18.5 or later?

I have just patched one of my sql server 2016 instances to the latest cumulative patch (at the moment CU 12 that gives you a version 13.0.5698.0 as you can see on the picture below). I had a few ...
2
votes
1answer
39 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/...
-1
votes
1answer
54 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: ...
7
votes
2answers
1k 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 ...
1
vote
2answers
47 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 (...
0
votes
0answers
22 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
0answers
54 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 ...
0
votes
1answer
25 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 ...
0
votes
1answer
1k 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
votes
1answer
76 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 ...
0
votes
0answers
96 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-...
5
votes
1answer
208 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 ...
0
votes
1answer
92 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 ...
5
votes
2answers
172 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 ...
3
votes
3answers
675 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 ...
1
vote
0answers
43 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 ...
0
votes
1answer
715 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"...
0
votes
1answer
155 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. ...
5
votes
1answer
350 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
vote
1answer
28 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 ...
0
votes
1answer
48 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-...
2
votes
1answer
354 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 / ...
0
votes
1answer
2k 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 ...
4
votes
1answer
3k 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 ...
2
votes
2answers
2k 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 ...
1
vote
1answer
1k 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 ...
0
votes
1answer
102 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 ...
4
votes
2answers
2k 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 ...
-1
votes
2answers
197 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 ...
5
votes
1answer
472 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
1answer
443 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 ...
2
votes
1answer
97 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 ...
5
votes
1answer
2k 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 ...
2
votes
1answer
193 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 ...
1
vote
4answers
4k 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
1answer
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
votes
2answers
336 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. ...
2
votes
2answers
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
vote
1answer
668 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/...
14
votes
1answer
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/...
1
vote
1answer
211 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?
0
votes
1answer
241 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 ...
1
vote
1answer
595 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?
6
votes
2answers
3k 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 ...
0
votes
1answer
38 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 ...
2
votes
2answers
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 ...
2
votes
0answers
93 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 ...
3
votes
1answer
1k 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 ...