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

 

3 Responses 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

  2. Bob says:

    This is brilliant! I had to install replication as an addition to a pre-existing SQL 2008 R2 install that was updated to SP3 long after the original install. Replication services wouldn’t install for me on this server until I discovered this gem and ran through the above process. This was a HUGE help!

  3. Mahen says:

    Thank you. It worked. My requirement is i need to put SQL 2008 R2 on Windows 2012 R2. Tried normal installation it didn’t worked. Above prescribed method perfectly worked. Once again thank you very much.

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.

top