Questions tagged [patching]
The patching tag has no usage guidance.
11
questions
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
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
5
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
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
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,834
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
0
votes
2
answers
17k
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
CU
https://learn.microsoft.com/en-us/sql/database-engine/install-...
- 1
-2
votes
1
answer
1k
views
What is the difference between CU-GDR and GDR?
There are 2 paths to patching SQL server. Either the SQL CU (cumulative) upgrade or GDR (critical) upgrade.
CU includes functionality fixes and security fixes (https://support.microsoft.com/en-us/...
- 1
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
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
0
votes
1
answer
104
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 ...
- 15.8k