Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [service-pack]

62 questions
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
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

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 Services and Reporting Services. Has someone done…
Willy Krawczyk
  • 53
  • 3
5
votes
1 answer

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 the following error: Property(S):…
user4659
4
votes
1 answer

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 are current backups of system and user…
Warrior Bob
  • 471
  • 1
  • 5
  • 15
4
votes
2 answers

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 resolve the collation conflict between…
Henrik Staun Poulsen
  • 2,249
  • 2
  • 23
  • 41
3
votes
1 answer

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 Failover Instance: Best…
EngineeringSQL
  • 579
  • 2
  • 7
  • 16
3
votes
0 answers

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 instances are standard edition 64 bit, both instances…
Cougar9000
  • 1,538
  • 1
  • 13
  • 29
3
votes
1 answer

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 http://support.microsoft.com/kb/2630458 Service Pack…
user3508934
  • 31
  • 1
  • 2
3
votes
1 answer

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 2016 Standard 10.0 (Build 14393: ). This is…
Kris
  • 452
  • 5
  • 15
3
votes
1 answer

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 between service packs? I can jump and install…
chesterman
  • 69
  • 1
  • 8
3
votes
1 answer

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\PatchLevel However, if I run SELECT @@VERSION it…
andrewbkillen
  • 31
  • 5
3
votes
1 answer

SQL Server update from SP1 to SP3

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
SQL_NoExpert
  • 1,107
  • 1
  • 21
  • 37
3
votes
2 answers

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.com/s/4tlmv3hmzvbb9l4/Log%20Files.7z?dl=0 Due to…
Chris
  • 31
  • 3
1
2 3 4 5