x

SQL Server Service Packs-do they need to be installed in order?

Hi Everyone!

I have a quick question... so I'm about to slipstream my service packs into my SQL Server installation file. However, for 2008R2, I'll specifically need SP2. Would I need to include SP1 along with SP2?

Thanks in Advance!

more ▼

asked Oct 22, 2015 at 01:02 PM in Default

avatar image

BKB
21 1 4

You have some answers below. This web site runs by you voting and marking the best answers. For each helpful answer below, indicate this by clicking on the thumbs up symbol next to those answers. If any one answer lead to a solution, indicate this by clicking on the check mark next to that answer. This helps indicate your solution for anyone else with the same question.

Nov 01, 2015 at 01:06 PM Grant Fritchey ♦♦
(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

No, the service packs are cumulative so if you install SP2 you'll also get SP1 along with it.

http://sqlserverupdates.com/frequently-asked-questions/

Hope that helps!

more ▼

answered Oct 22, 2015 at 01:36 PM

avatar image

JohnM
14.2k 3 7 14

John, thanks so much for replying so quickly! I appreciate the help!

Oct 22, 2015 at 01:48 PM BKB
(comments are locked)
10|1200 characters needed characters left

Service packs include all fixes from previous service packs. Therefore, you can skip SP1 and just install SP2 (or SP3).

I wanted to get you the official word on this, so I did a little searching and found it. https://support.microsoft.com/en-us/kb/2527041

"Service packs are cumulative. Each new service pack contains all the fixes that are in previous service packs, together with any new fixes. You do not have to install a previous service pack before you install the latest service pack."

more ▼

answered Oct 22, 2015 at 01:37 PM

avatar image

Tom Staab ♦
14.5k 7 14 21

Tom, you're awesome! Thanks so much!!!

Oct 22, 2015 at 01:47 PM BKB
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x5

asked: Oct 22, 2015 at 01:02 PM

Seen: 342 times

Last Updated: Nov 01, 2015 at 01:06 PM

Copyright 2017 Redgate Software. Privacy Policy