Questions tagged [service-pack]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
2
votes
2answers
492 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 ...
1
vote
1answer
513 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 ...
2
votes
2answers
368 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 ...
2
votes
1answer
119 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
1answer
301 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-...
3
votes
2answers
3k 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 ...
1
vote
1answer
904 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
2
votes
2answers
1k 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
vote
1answer
2k 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 ...
4
votes
2answers
2k 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
0answers
309 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
votes
2answers
3k 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 ...
1
vote
2answers
131 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
2answers
515 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, ...
1
vote
1answer
968 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 ...
1
vote
1answer
196 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 ...
0
votes
2answers
35 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 ...
1
vote
1answer
664 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 ...
0
votes
1answer
2k 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
vote
2answers
9k 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 ...
1
vote
3answers
1k 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 ...
0
votes
2answers
6k 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 ...
0
votes
1answer
46 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
7
votes
3answers
911 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 ...
0
votes
0answers
3k views

Service Pack 2 Installation Failure from 12.1.4457.0

During our recent monthly maintenance window I ran into an error installing SP2 on SQL 2014. The following is a screenshot and the associated error messages. Let me know if you need anything more. ...
1
vote
1answer
182 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 (...
2
votes
2answers
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 ...
0
votes
1answer
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 ...
0
votes
2answers
44 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 ...
1
vote
1answer
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 ...
2
votes
2answers
2k 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:...
1
vote
3answers
3k 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 ...
3
votes
2answers
1k 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....
0
votes
1answer
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:\ ...
2
votes
1answer
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 ...
1
vote
2answers
373 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 ...
1
vote
1answer
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 ...
2
votes
1answer
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 ...
1
vote
3answers
2k views

SQL Server 2014 Latest CU / Service Pack

Where can you find the latest SQL Server 2014 Cumulative Update (CU) and/or Service Pack? Note: I added this question and answered my own question to make this easier to find for others in the future....
3
votes
0answers
9k views

SQL Server 2008 R2 Service pack 3 won't recognize all instances

I have two instances on one of my servers, and when installing service pack 3 the GUI installer does not recognize one of the instances. Server is Windows Server 2008R2 Enterprise x64 SP1 Both ...
2
votes
1answer
1k views

Breaking changes between 2008R2 RTM going to 2008R2 SP3?

I have a few A/P FCIs running 2008R2 RTM, and I'd like to upgrade the passive node to SP3, fail over, and then upgrade the formerly passive node. Has anyone else attempted this? Are there breaking ...
2
votes
2answers
6k views

Error during SQL Server 2008 R2 SP3 upgrade: MODIFY FILE failed. File 'MSDBLog' does not exist

I have just installed SQL Server 2008 R2 SP3 and after installing it and trying to start the SQL Server instance again, it won't come online. In the SQL Server error log I can see that the following ...
3
votes
1answer
2k views

How to pull a list of applied service packs and cumulative updates from SQL Server 2008 R2?

I want to list all the SPs and CUs applied to a SQL Server 2008R2 instance. Example: 10.50.4260 2720425 http://support.microsoft.com/kb/2720425 CU#1 for SQL Server 2008 R2 SP2 10.50.4000 2630458 ...
1
vote
1answer
1k views

How to update SQL Server 2005 clustered instances?

We have a 3 node cluster with an instance running on each. Windows 2003 R2 32bit (16GB) / SQL Server 2005 I want to bring them all up to build 9.00.5266 (SP 4 + CU3) (1 Node is already updated) The ...
0
votes
0answers
56 views

How Can I Convert SQL Server 2012 Version 11.0.3000.0 to SQL Server 2012 Version 11.1.3000.0? [duplicate]

I have SQL Server 2012 with version 11.0.3000.0 . I need upgrade my version to SQL Server 2012 SP1 because I need install Cumulation 4 in Sql Server 2012 Cumulative Update 4 for use PowerPivot in ...
1
vote
2answers
21k views

How Can I Convert SQL Server 2012 Version 11.0.3000.0 to SQL Server 2012 Version 11.1.3000.0?

I have SQL Server 2012 with version 11.0.3000.0 . I need upgrade my version to SQL Server 2012 SP1 because I need install Cumulation 4 in Sql Server 2012 Cumulative Update 4 for use PowerPivot in ...
1
vote
2answers
805 views

Install SP 3 on SQL Server 2008, where merge replication is running

I have a SQL Server 2008 and I should install Service Pack 3 for it. On my server there are several databases replicated, and mobile devices sync data via merge replication. Can problems occur, if I ...
4
votes
1answer
2k views

What are the hazards of upgrading a SQL Server service pack?

Are there any specific pitfalls/standard considerations when upgrading an instance of MS SQL Server to a higher service pack? Is there anything special that is generally done besides making sure there ...
4
votes
1answer
977 views

Updating directly from SP1 to SP3

I am considering applying the Service Pack 3 in a SQL Server 2008 with Service Pack 1; however, I was not able to find if there are any drawbacks in this process, specially regarding to Replication ...
5
votes
1answer
3k views

Failed Upgrade from SQL Server 2005 sp2 to SQL Server 2005 sp4

SQL Server Standard 2005 sp2 32bit running on Windows 2003 Standard 32bit service pack 2. I attempted a service pack upgrade from sp2 to sp4 using SQLServer2005SP4-KB2463332-x86-ENU.exe and received ...