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
Brilliant quick and useful and worked a treat many thanks
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!
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.