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 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." :