Slipstream SQL Server 2008 R2 and SQL Server 2008 R2 Service Pack 1 (SP1)

Now that SQL Server 2008 R2 SP1 has been released, if you are looking to create slipstream pack, then read this post, the SQL Server Setup compiled the list of steps to create a slipstream drop."Once you've created this slipstream drop, you can install the original release of SQL Server 2008 R1 and SP1 at […]

Now that SQL Server 2008 R2 SP1 has been released, if you are looking to create slipstream pack, then read this post, the SQL Server Setup compiled the list of steps to create a slipstream drop.

"Once you've created this slipstream drop, you can install the original release of SQL Server 2008 R1 and SP1 at the same time. The slipstream functionality performs a single installs that is quicker when compared to installing the original release and then applying the service pack. Additionally this slipstream drop fixes any Setup issues that prevent a successful installation or upgrade that has been addressed in SP1," blooged Peter Saddow.

This slipstream drop is for new installation or upgrades, to patch existing SQL Server 2008 features, you can download SP1 here.

Here are the steps:

  1. Copy your original SQL Server 2008 R2 source media to C:\SQLServer2008R2_SP1
  2. Download SQL Server 2008 R2 SP1 packages using the link above. You need to download all Service Pack 1 architecture packages:
    • SQLServer2008R2SP1-KB2528583-IA64-ENU.exe
    • SQLServer2008R2SP1-KB2528583-x64-ENU.exe
    • SQLServer2008R2SP1-KB2528583-x86-ENU.exe
  3. Extract each of the SQL Server 2008 SP1 packages to C:\SQLServer2008R2_SP1\SP as follows:
    • SQLServer2008R2SP1-KB2528583-IA64-ENU.exe /x:C:\SQLServer2008R2_SP1\SP
    • SQLServer2008R2SP1-KB2528583-x64-ENU.exe /x:C:\SQLServer2008R2_SP1\SP
    • SQLServer2008R2SP1-KB2528583-x86-ENU.exe /x:C:\SQLServer2008R2_SP1\SP

    Ensure you complete this step for all architectures to ensure the original media is updated correctly.

  4. Copy Setup.exe from the SP extracted location to the original source media location. Here is the robocopy command:
    • robocopy C:\SQLServer2008R2_SP1\SP C:\SQLServer2008R2_SP1 Setup.exe
  5. Copy all files not the folders, except the Microsoft.SQL.Chainer.PackageData.dll, in C:\SQLServer2008R2_SP1\SP\<architecture> to C:\SQLServer2008R2_SP1\<architecture> to update the original files. Here is the robocopy command:
    • robocopy C:\SQLServer2008R2_SP1\SP\x86 C:\SQLServer2008R2_SP1\x86 /XF Microsoft.SQL.Chainer.PackageData.dll
    • robocopy C:\SQLServer2008R2_SP1\SP\x64 C:\SQLServer2008R2_SP1\x64 /XF Microsoft.SQL.Chainer.PackageData.dll
    • robocopy C:\SQLServer2008R2_SP1\SP\ia64 C:\SQLServer2008R2_SP1\ia64 /XF Microsoft.SQL.Chainer.PackageData.dll
  6. Determine if you have a DefaultSetup.INI at the following locations:
    • C:\SQLServer2008R2_SP1\x86
    • C:\SQLServer2008R2_SP1\x64
    • C:\SQLServer2008R2_SP1\ia64

    If you have a DefaultSetup.INI at the above locations, add the following lines to each DefaultSetup.INI:

    PCUSOURCE=".\SP"

    If you do NOT have a DefaultSetup.INI, create one with the following content:

    ;SQLSERVER2008 R2 Configuration File

    [SQLSERVER2008]

    PCUSOURCE=".\SP"

    and copy to the following locations

      • C:\SQLServer2008R2_SP1\x86
      • C:\SQLServer2008R2_SP1\x64
      • C:\SQLServer2008R2_SP1\ia64

    This file will tell the setup program where to locate the SP source media that you previously extracted.

  7. Run setup.exe as you normally would.

[Source: SQL Server Setup]