search
top

How To Slipstream SQL Server 2008 R2 and SQL Server 2008 R2 SP3

Introduction

You have been tasked to install SQL Server 2008 R2 on a server and you need to have the latest Service Pack as well, but want to accomplish it in one installation. Well no fear slipstream to the rescue. In this post we will cover how to slipstream SQL Server 2008 R2 SP3 to a fresh SQL Server 2008 R2 installation.

What You Need

  • SQL Server 2008 R2 installation media
  • SQL Server 2008 R2 SP3

Download SQL Server 2008 R2 SP3 from https://www.microsoft.com/en-us/download/details.aspx?id=44271

SQLServer2008R2SP3-KB2979597-x64-ENU.exe
SQLServer2008R2SP3-KB2979597-x86-ENU.exe

Perform The Slipstream

Here are the steps:

For this post I have used C:\SQLServer2008R2 as my location for the media and patch, replace with your choice of directories.

Copy your original SQL Server 2008 R2 source media to C:\SQLServer2008R2.

 

Extract each of the SQL Server 2008 SP3 packages to C:\SQLServer2008R2\SP as follows:

 SQLServer2008R2SP3-KB2979597-x64-ENU.exe /x:C:\SQLServer2008R2\SP
 SQLServer2008R2SP3-KB2979597-x86-ENU.exe /x:C:\SQLServer2008R2\SP

Ensure you complete this step for all architectures to ensure the original media is updated correctly.
Copy Setup.exe from the SP extracted location to the original source media location. Here is the robocopy command:

robocopy C:\SQLServer2008R2\SP C:\SQLServer2008R2 Setup.exe

Copy all files not the folders, except the Microsoft.SQL.Chainer.PackageData.dll, in C:\SQLServer2008R2\SP\<architecture> to C:\SQLServer2008R2\<architecture> to update the original files. Here is the robocopy command:

robocopy C:\SQLServer2008R2\SP\x86 C:\SQLServer2008R2\x86 /XF Microsoft.SQL.Chainer.PackageData.dll
robocopy C:\SQLServer2008R2\SP\x64 C:\SQLServer2008R2\x64 /XF Microsoft.SQL.Chainer.PackageData.dll

Determine if you have a DefaultSetup.INI at the following locations:

C:\SQLServer2008R2\x86
C:\SQLServer2008R2\x64

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\x86
C:\SQLServer2008R2\x64

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

Run setup.exe as normal.

 

Conclusion

As we can see the process is not hard to slipstream the latest service pack into your SQL Server 2008 R2 installation

 

One Response to “How To Slipstream SQL Server 2008 R2 and SQL Server 2008 R2 SP3”

  1. Neo says:

    Brilliant quick and useful and worked a treat many thanks

Leave a Reply

Your email address will not be published. Required fields are marked *

top