Skip to main content

Questions tagged [patching]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
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 ...
SqlNovice's user avatar
  • 644
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 ...
Marcello Miorelli's user avatar
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 ...
Marcello Miorelli's user avatar
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 ...
Razvan Zoitanu's user avatar
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/...
BradC's user avatar
  • 10k
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 ...
Learning_Learning's user avatar
0 votes
2 answers
23k 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 CUx (where x is a number) CUx + GDR (where x is a number) https://...
variable's user avatar
  • 3,476
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, ...
BeginnerDBA's user avatar
  • 2,180
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 ...
shawnshutt's user avatar
0 votes
1 answer
211 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 ...
Marcello Miorelli's user avatar