Questions tagged [patching]
104 questions
14
votes
1 answer
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/spectre vulnerabilities on InfoSec.SE.
As a SQL…
BradC
- 10,073
- 9
- 51
- 89
9
votes
3 answers
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 that I can use my PowerShell routines.
It has been…
Marcello Miorelli
- 17,274
- 53
- 180
- 320
8
votes
1 answer
What are the "GDR" vs "QFE" hotfixes for SQL Server 2008 R2 SP3?
I'd always assumed that higher patch numbers were necessarily later releases, but now I'm not so sure.
Looking at the SQL Server Build List for SQL Server 2008 R2 SP3, there are two possible ways to apply security update MS15-058, one labeled "GDR",…
BradC
- 10,073
- 9
- 51
- 89
7
votes
2 answers
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 without applying the old Service Pack 1 and the…
SqlNovice
- 654
- 3
- 13
- 21
7
votes
3 answers
How far to go when Validating a SQL Service Pack install?
When applying a Service Pack to a production SQL server, I usually have a planned downtime window of around 30 minutes.
Having been bitten before, and discovering that a required precondition like a patch is not in place, that can add several…
James Jenkins
- 6,318
- 6
- 49
- 88
6
votes
2 answers
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 machine, the VMware Tools core service.
Is it safe…
Marcello Miorelli
- 17,274
- 53
- 180
- 320
5
votes
4 answers
Patching SQL Server 2016
Most of my SQL Servers are on 2016 SP2. The security group have identified that I need a later security update applied and as SP2 is out of support this year I planned to just patch it up to SP3.
The problem is I have never actually patched SQL…
Garry
- 53
- 1
- 6
5
votes
1 answer
SQL Server CUs vs SPs + CUs?
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 the latest SP + CU. For example, we have a 2014…
PeterDaniels
- 141
- 6
5
votes
2 answers
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 standalone, should it not be fine to patch 2 instances and…
jack
- 419
- 3
- 8
- 18
5
votes
1 answer
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 that none of the KB in SP1CU15 was mentioned in…
DMDM
- 1,750
- 2
- 16
- 36
5
votes
1 answer
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 the remote code execution vulnerability hotfix…
John G Hohengarten
- 674
- 1
- 7
- 18
5
votes
1 answer
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 being queued but not sent and we could find no…
Jonas Olsson
- 91
- 1
- 7
5
votes
2 answers
What is the different between GDR security update and CU security update
What is the different between GDR security update and CU security update?
I am looking to understand difference between the below two updates. If I apply KB3194724, would it also include KB 3194721?
Build 11.00.6567 (3194724 MS16-136: Description…
Farhan
- 51
- 1
- 1
- 3
4
votes
1 answer
How do I prevent my Windows Server from being automatically rebooted by SQL Server updates?
Some SQL Server updates have happened outside the maintenance window, which have caused the server to be rebooted. How can I stop this from happening again in future?
Below is what I can see when looking at the Windows Update Settings:
RGO
- 423
- 6
- 13
4
votes
1 answer
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: ) (Hypervisor)
Tried to install "Cumulative…
Aleksey Vitsko
- 6,148
- 5
- 39
- 70