Questions tagged [patching]

The tag has no usage guidance.

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