Setup Slipstream Install Media - SQL-FineBuild/Common GitHub Wiki

Previous Setup Windows Pre Requisite Components	Manual Configuration	Setup MSDTC Next

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 2AB and is controlled by the parameters below:

SQL Version	Parameter	FULL Build	WORKSTATION Build	CLIENT Build
SQL2019	/SetupSlipstream:	N/A	N/A	N/A
SQL2017	/SetupSlipstream:	N/A	N/A	N/A
SQL2016	/SetupSlipstream:	N/A	N/A	N/A
SQL2014	/SetupSlipstream:	N/A	N/A	N/A
SQL2012	/SetupSlipstream:	N/A	N/A	N/A
SQL2008R2	/SetupSlipstream:	Yes	Yes	Yes
SQL2008	/SetupSlipstream:	Yes	Yes	Yes
SQL2005	/SetupSlipstream:	Yes	Yes	Yes

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

The FineBuild setup Slipstream Media process includes the following:

Prepare Base Media
Apply Service Pack Media
Apply Cumulative Update Media

Top

Manual Setup Slipstream Install Media

The following steps show what you would have to do for manual Slipstream Install Media setup. 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.

Prepare Base Media

Create a folder in the Windows \Temp folder called \Temp\SQLMediaPCU

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.

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
```

Apply Service Pack Media

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
```
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
```

Apply Cumulative Update Media

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

The Slipstream Install Media is now ready for use

Previous Setup Windows Pre Requisite Components	Top	Setup MSDTC Next