question

BKB avatar image
BKB asked

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!
service pack
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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.
0 Likes 0 ·
JohnM avatar image
JohnM answered
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!
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

John, thanks so much for replying so quickly! I appreciate the help!
0 Likes 0 ·
Tom Staab avatar image
Tom Staab answered
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][1] "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." [1]: https://support.microsoft.com/en-us/kb/2527041
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Tom, you're awesome! Thanks so much!!!
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.