Questions tagged [service-pack]
The service-pack tag has no usage guidance.
62 questions
0
votes
1
answer
608
views
What are "Cumulative Special Build" in fixpack download web page?
On our computers Db2 v11.5.8.0 Linux/x86-64 is installed. I would like to install new fixes as regular update, specially to deploy security fixes.
Couple of weeks ago new fixpack 11.5.9.0 was released....
- 401
-1
votes
1
answer
91
views
How to find new problems since latest Db2 fixpack is released?
A weak ago new Db2 release v11.5.8.0 was released.
There is a list of problems that were solved in this release.
But as always every new release has some new bugs. Is there some list of new discovered ...
- 401
3
votes
1
answer
2k
views
Install SQL Server 2016 SP2 on SP3 - Windows Updates says that?
Currently our server is on Microsoft SQL Server 2016 (SP3) (KB5003279) - 13.0.6300.2 (X64) Aug 7 2021 01:20:37 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows Server ...
- 442
0
votes
1
answer
2k
views
MS SQL Server 2016 SP3 upgrade failing
I tried to apply the SP3 on one of my SQL Server 2016 DB server, and it kept failing with the below error.
Error description: The installer has encountered an unexpected error. The error code is 2203....
5
votes
4
answers
4k
views
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 ...
- 73
2
votes
0
answers
359
views
SQL server 2019 RTM Cumulative Update (CU) 12 KB5004524 (2) Last failed install attempt on 9/19/2021-0x80070643
What causes DEV SQL 2019 to failed when patching, this is the second time it has happened and had to restore the master and backup the entire databases.
Script level upgrade for database 'master' ...
- 21
-1
votes
1
answer
113
views
SQL Server 2016 integrated SP2 download & Install
I am installing SQL 2016 for a client across a number of VMs and looking to patch to SP2.
Can i download SQL Server 2016 integrated with SP2 so i can implement in the one go? Or does it need to be ...
- 37
0
votes
1
answer
1k
views
SQL Server Standard 2016 Service Pack and Cumulative Update [duplicate]
We are currently using SQL Server 2016 Standard Edition with ALWAYS-ON High Availability. We have two different clusters of SQL servers. We need to update it to the latest version of SQL (As per my ...
- 43
0
votes
1
answer
280
views
Sql Server 2014 update path advice
I recently inherited a SQL Server 2014 installation and I'd like to install updates. The virtual machine runs Windows Server 2016 standard. The server has about 50+ databases with 400Gb of data. I'm a ...
- 127
0
votes
0
answers
879
views
Should I install all cumulative updates/service packs when doing a clean install of SQL Server 2016? 2019?
Going to set up a new database instance from scratch. Debating between SQL Server 2016 and 2019.
I've never installed a service pack or cumulative update on previous instances, mostly because ...
- 123
0
votes
1
answer
132
views
Can I determine the service pack for all my SQL Servers using SCCM?
I'm trying to figure out a way to find out all the service packs for my sql servers. There's about 30+ databases which we hosted & to login to each of the server and check the service pack will ...
- 13
0
votes
1
answer
57
views
Upgrading to SQL Server 2014 SP3 _ Clarifications help needed [closed]
We have SQL Server 2014 SP2 GDR with below:
Availability Groups
TDE enabled for structured data
EFS enabled for unstructured data
Now the DBs are with AOAGs and encrypted , I am planning to ...
- 1,600
3
votes
1
answer
858
views
Install last CU for SP2 without installing SP1 in sql server
A client asked me to update their SQL Server.
It's an 2016 base release (13.00.1601.00)
Microsoft already released the SP2 CU10. I know that cumulative updates are... like... cumulative, but even ...
- 69
2
votes
2
answers
3k
views
How does patching work in SQL Server?
I need a clarification on how below SQL Server service pack patching works.
Few of my servers are at below patch for SQL Server 2014 which has latest meltdown patch
12.00.5214 2014.120.5214.6 ...
- 2,210
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 ...
- 16.6k
2
votes
2
answers
1k
views
When installing a service pack on one instance will this hinder the running of the other instances on a standalone SQL Server?
I have a SQL Server 2016 with an instance A and an instance B. Both have SP1 installed, no reporting server.
Can I assume that, when I install SP2 on instance B only, that, while installing, the ...
- 135
3
votes
1
answer
415
views
SQL Server Patch Level Is Inaccurate, Causing Upgrade Issues
I have a box that lists SQL Server 2014 SP2 (12.2.5000) in both add/remove programs and the registry
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\120\SQLServer2014\CurrentVersion\...
0
votes
1
answer
1k
views
Error code is 0x80131500 when applying SP4 to SQL Server 2012
This is an open request for any thoughts, advice or guidance about an issue I have while attempting to apply SP4 to a SQL Server 2012 installation.
The server is currently the secondary node of a two-...
4
votes
2
answers
6k
views
Failure during install of SQL Server 2016 sp2
I'm trying to install the new SP2 for SQL Server 2016, but it fails during the install with an Engine error.
This is what I can read in the errorlog>
Error: 468, Severity: 16, State: 9.
Cannot ...
- 2,239
2
votes
1
answer
8k
views
SQL Server update from SP1 to SP3 [duplicate]
Can I move directly from SQL Server SP1 to SP3 or do i need to install SP2 then go to SP3. I was assigned to upgrade my servers 2014 just to make sure I don't fall into problems
- 1,063
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,600
1
vote
1
answer
4k
views
Issue installing SQL Server 2012 SP4 in a cluster - missing ‘vc_red.msi’
Installed SQL Sever 2012 SP4 (from SP3) on one node of a two-node SQL Server cluster without issue. On the other node it is exiting out of the install with the following message:
The required MSI ...
- 1,784
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 ...
- 654
1
vote
0
answers
733
views
Unable to start the Integration services for SQL server 2012
Suddenly we are facing some errors in starting up the integration services.
From event viewer and ssms when we tried connecting we get below error message
The SQL Server Integration Services 11.0 ...
- 2,210
2
votes
2
answers
4k
views
Do I really Need to Upgrade to SQL Server 2014 SP2 ? -
We have a Application upgrade to next version.
SQL Server 2014 is currently on SP1.
The upgrade pre-requisite is not necessarily SQL Server SP2.
But I feel and read the below link which says SQL ...
- 123
2
votes
2
answers
449
views
Do I need to install SQL Server service packs to continue receiving security patches
It's always been my belief that SQL Server needs to be updated to the latest service pack in a timely (and tested) manner to continue receiving security/bug patches.
I'm now partially responsible for ...
2
votes
2
answers
891
views
Do SQL service packs effect SQL Compatibility mode?
We will soon be upgrading from a SQL 2008 R2 instance to a SQL 2016 instance.
One of our databases has an application which our supplier says is compatible up to SQL 2012 SP1, but not SQL 2012 SP2, ...
- 132
1
vote
1
answer
2k
views
Cant Uninstall SP3 from SQL Server 2008r2
I installed SP3 for sql server 2008r2 RTM release on windows server 2008r2. After testing i found some unknown issues in my application. Now i want to downgrade this database engine again into RTM ...
- 13
1
vote
1
answer
363
views
Error in table 'sys.sysbinobjs' on master database
We have a SQL server DatabaseIntegrityCheck job to check the SYSTEM_DATABASES, and it shows an error message below in the logs now:
Msg 2570, Level 16, State 2, Line 1 Page (1:354), slot 28 in ...
- 73
0
votes
2
answers
36
views
SQL 2008 Version Number Question
When I run the SQL Server 2008 Setup Discovery Report, all of the components (Database Engine Services, Management Tools - Complete, etc) show as version 10.3.5852.0.
However, I cannot find any ...
- 73
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
3k
views
Upgrading SQL Server 2012 from SP2 to SP3
We need to upgrade our SQL Server 2012 from Service Pack 2 to Service Pack 3. We are no database experts and would like to have some info regarding this.
We are going to be doing this upgrade on the ...
- 1
1
vote
2
answers
14k
views
Upgrading from SQL Server 2008 R2 SP1 to SP3
I have to install the Service Pack 3 on an SQL instance running with the SP1. No test, the install is directly on the production server. Well this is not a complex task and the topic has been already ...
- 325
1
vote
3
answers
2k
views
Table Partitioning in SP1 for SQL Server 2016
Can anyone validate\conclude for sure if SP1 for SQL Server 2016 now makes Table Partitioning available in the Standard Edition version? It has always been an Enterprise Edition feature in the past. I ...
- 49
2
votes
2
answers
21k
views
How to determine the service pack of Sql Server
I am having a sql server 2012 enterprise edition installed on my win 2012 r2 server.
But i am unable to determine whether its installed with service pack or not.
how to find out which service pack is ...
- 21
0
votes
1
answer
55
views
Patching SQL Server 2008 and upgrading to 2014
The environment which I am working right now is on SQL Server 2008, 2008 R2. Do you think its a good idea to first patch it with the latest service pack and then upgrade to SQL Server 2014?
Thanks
- 625
7
votes
3
answers
1k
views
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 ...
- 6,318
1
vote
1
answer
211
views
Will Installation of Service Pack 3 on SQL Server 2012 Web Edition (existing production) require database restore activity?
We are currently running our Database Server on a RTM version:
Microsoft SQL Server 2012 - 11.0.2100.60 (X64)
Feb 10 2012 19:39:15
Copyright (c) Microsoft Corporation
Standard Edition (...
- 61
2
votes
2
answers
2k
views
Should I install SQL Server 2012 SP3 when I'm already running SQL Server 2014?
We've been running SQL Server 2014 for almost a year now, but SQL Server 2012 SP3 continues to appear in the Windows Update list (as an optional install). It seemed ridiculous to install a service ...
- 756
0
votes
1
answer
3k
views
Upgrading SQL Server 2012 Enterprise SP1 (11.0.3000.0) to SP2 or SP3
We need to upgrade our production SQL Server 2012 Enterprise SP1 (11.0.3000.0) to SP2 or SP3. So which one would be more stable out of those 2 service packs and also how could this be achieved with a ...
- 59
0
votes
2
answers
120
views
A good way to verify if the update has no problems?
I don't know if this is a stupid question, but I'm upgrading my test instances to SQL Server 2014. I've installed SP1, after I will install Cumulative Updates.
It's working fine, but is there a way ...
- 7,484
2
votes
1
answer
2k
views
SQL Server 2012 Cluster Service pack 3 fail to failover node
Roughly a year ago, i had this problem with an 2008R2 cluster. I asked about it here, but i didn't grab enough logs in the process. And now i have the same problem on my 2012 failover cluster. So i'm ...
- 163
2
votes
2
answers
3k
views
Failed to update SQL Server 2008 R2 RTM to SP3
I'm trying to update SQL Server 2008 R2 RTM to SP3 by running SQLServer2008R2SP3-KB2979597-x64-ENU.exe, on Windowns Server 2008 R2 SP1.
It failed with the following error in the log,
2015-11-26 10:...
- 153
1
vote
3
answers
5k
views
Security update failed : The baseline msi is not installed
Yesterday we had to apply a security update for SQL Server 2008 SP4(
Current version: 10.0.6000.29) (from KB3045311 and MS15-058) and it failed in both the nodes of a Windows failover cluster and both ...
- 11
3
votes
2
answers
2k
views
SQL Server 2012 SP2 update failure
I have been having failures to install SQL Server 2012 SP2 on a 2-node active\passive cluster. I have uploaded detail and summary logs for the latest run on the passive node here:
https://www.dropbox....
- 31
0
votes
1
answer
2k
views
Cannot select features to install from SQL Server 2005 SP4 installation process [closed]
The issue: I cannot select MSSQLSERVER from the feature list I want to update as part of the SQL Server 2005 x64 Service Pack 4 installation process.
Please note exe file is being raised from C:\ ...
- 121
3
votes
1
answer
2k
views
Is Service Pack 2 completely installed on Passive Node of SQL Server 2012 Instance?
We are applying SQL Server 2012 Service Pack 2 (SP2) to a two-node active/passive cluster, starting with the passive node (as per best practices):
How to install a Service Pack at a SQL Server 2012 ...
- 579
2
votes
2
answers
437
views
Will adding features pick up previously installed service pack updates?
We have SQL Server 2008 R2 SP3 installed. Need to add a feature to the installation, Business Intelligence Development Studio. The question is do features installed after the application of a service ...
- 63
1
vote
1
answer
1k
views
SQL Server 2008 R2 Cluster Service pack 3 fail to failover node [duplicate]
I have a SQL Server R2 cluster on Windows 2008 R2 boxes, and today i was to install SP3. I installed it without any errors and rebooted the passive node.
When i then try to failover to the passive ...
- 163
2
votes
1
answer
2k
views
Error 29527: While upgrading from SP1 to SP4 in SQL Server 2005
We are trying to upgrade from SP1 to SP2 in SQL Server 2005 test box for a named instance.
Initially we got the error
MSP Error: 1260 Windows cannot open this program because it has been ...
- 7,177