This project has moved. For the latest updates, please go here.

Previous Install SQL Pre Install Tasks Manual Configuration Setup MSDTC CID Next

Setup Slipstream Install Media

FineBuild can setup Slipstream Install Media for SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2. SQL Server 2012 and above do not need Slipstream Install Media.

For SQL Server 2005, the slipstream is only partial and does not include any Cumulative Updates. The Install SQL Service Pack processing is always needed if SQL 2005 install media is slipstreamed.

Like all software, the SQL Server Setup program contains bugs. For SQL Server 2008 and SQL Server 2008 R2, Microsoft has provided a method to update the Setup program by building a slipstream media set. This process will merge the desired SQL Server SP and CU into a temporary install media folder, so that these fixes are installed during the SQL Server install process.

FineBuild Slipstream Install Media configuration

The Slipstream Install Media configuration relates to Process Id 2AA and is controlled by the parameters below:
Parameter Build SQL2005 SQL2008 SQL2008R2 SQL2012 SQL2014
SetupSlipstream FULL Yes Yes Yes N/A N/A
SetupSlipstream WORKSTATION Yes Yes Yes N/A N/A
SetupSlipstream CLIENT Yes Yes Yes N/A N/A

FineBuild will always use slipstream media when installing SQL Server 2005, SQL Server 2008 or SQL Server 2008 R2. The slipstream media can either be built automatically by FineBuild, or it can be supplied to FineBuild as a pre-configured slipstream media set.

If a pre-configured slipstream media set is used, the following parameter settings are required:
/SetupSlipstream:Done
/PathSQLMedia:path to slipstream media

FineBuild also uses the following parameters to help setup Slipstream Install Media:
Parameter Default Value Description
SPLevel latest SP Service Pack level to be used in Slipstream Media
SPCULevel latest CU for SP Cumulative Update level to be used in Slipstream Media
PathSQLMedia none Path to pre-prepared Slipstream Media, only required if pre-prepared Slipstream Media is supplied

If FineBuild builds the slipstream media, then about 700MB space is required on the drive holding the Windows \Temp folder.
Top

Manual Slipstream Install Media configuration

The following steps show what you would have to do for manual Slipstream Install Media configuration. FineBuild does all of this work for you automatically.

The example below shows how to create Slipstream media for SP1 CU6. The same process can be used for other combinations of Service Pack and Cumulative Update.
1) Create a folder in the Windows \Temp folder called \Temp\SQLMediaPCU, and then create the following subfolders.

The example shows the subfolders needed to create slipstream media for SP1 and CU6 for x64 processors. Replace y with the relevant drive letter for your system.
Folder Name Description
y:\Temp\SQLMediaPCU Folder to hold slipstream media
y:\Temp\SQLMediaPCU\SP1 SP folder (e.g. \SP1 or \SP2, etc)
y:\Temp\SQLMediaPCU\CU6 CU folder (e.g. \CU4, \CU6, \CU1, etc)
y:\Temp\SQLMediaPCU\X64 Processor architecture folder (i.e. \X86 or \X64)

The folder name PCU can be used instead of the folder name SPx.

The folder name CU can be used instead of the folder name CUx.

2) Copy the RTM media to the \SQLMediaPCU folder

For all editions except SQL Express, use the following commands:
XCOPY SQL...\*.*  y:\Temp\SQLMediaPCU
XCOPY SQL...\X64\*.*  y:\Temp\SQLMediaPCU\X64

For SQL Express Edition use the following example command:
SQL...\SQLEXPRADV_x64_ENU.exe /QUIET /X:y:\Temp\SQLMediaPCU

3) Copy the SP1 media to the \Temp\SQLMedia\SP1 folder

Extract the SP1 media using the following command:
SQL...\Service Packs\SP1\sp1file.exe /QUIET /X:y:\Temp\SQLMediaPCU\SP1

4) Update RTM media with SP1 updates

This process should not be done for SQL 2005. This process will copy all updates needed for SP1 into the new install media folder. It is important to exclude all occurrences of a specific dll, so that the install process knows it should install a full copy of SQL Server, not just the SP1 update.
  • Create a text file called y:\Temp\FBTemp.txt
  • Edit this file and type the following text:
Microsoft.SQL.Chainer.PackageData.dll

Copy the SP1 updates using the following commands:
XCOPY y:\Temp\SQLMediaPCU\SP1\Setup.*  y:\Temp\SQLMediaPCU
XCOPY y:\Temp\SQLMediaPCU\SP1\X64\*.*  y:\Temp\SQLMediaPCU\X64 /EXCLUDE:y:\Temp\FBTemp.txt

5) Copy the CU6 media to the \SQLMedia\CU6 folder

Extract the CU6 updates using the following command:
SQL...\Service Packs\SP1\Hotfix\sp1cu6file.exe /QUIET /X:y:\Temp\SQLMediaPCU\SP1CU6

Copy the CU6 updates using the following commands:
XCOPY y:\Temp\SQLMediaPCU\SP1CU6\Setup.*  y:\Temp\SQLMediaPCU
XCOPY y:\Temp\SQLMediaPCU\SP1CU6\X64\*.*  y:\Temp\SQLMediaPCU\X64 /EXCLUDE:y:\Temp\FBTemp.txt

6) The Slipstream Install Media is now ready for use

Copyright © 2013 - 2014 Edward Vassie. License and Acknowledgements
Previous Install SQL Pre Install Tasks Top Setup MSDTC CID Next

Last edited Aug 21, 2014 at 12:31 PM by EdVassie, version 3