Questions tagged [patching]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
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 ...
4
votes
2answers
3k 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
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 ...
4
votes
3answers
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 ...
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 ...
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/...
4
votes
2answers
3k 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, ...