SQL Server with Service Pack Slipstream will make your SQL Server installation faster and this is also required when installing on new multi-instance when the installer version has latest Service Pack.
I have created a script to automate the slipstream process into ISO files.
Once ISO generated is completed, I advise you to read companion tools to test.
Pre-Requisites:
- Download Admin Scripts and Unzip
1. YLNotes__SqlServer_Slipstream_Scaffolding_SP.cmd
2. YLNotes__SqlServer_Slipstream_Engine_SP.cmd
3. YLNotes__SqlServer_Slipstream_Config_SP-[PROFILE].cmd
Note: Change [PROFILE] with the name of SQL Server Slipstream Configuration set
- Download ISO Extraction program
1. 7-Zip (Windows 32-bit exe installer)
- Download Make ISO program
1. MKISOFS (Windows) (mkisofs.exe)
2. CDBurnerXP (Portable version)
SlipStream Steps:
- Execute Admin Script #1 YLNotes__SqlServer_Slipstream_Scaffolding_SP.cmd
to create the slipstream scaffolding. It will create a folder in root drive where the script is located.
- Save all Admin Scripts into __SqlServer_SlipStream__\CMD
-
Add binary program into __SqlServer_SlipStream__\BIN
3.1. ISO Extraction program
Install 7-Zip (EXE) or extract using other archival software and copy binary:
– 7z.exe
– 7z.dll
3.2. Make ISO program
a. MKISOFS
Extract mkisofs.exe program
b. CDBurnerXP
Extract Portable ZIP file and rename the root folder to CDBurnerXP
- SQL Server Sources
4.1. SQL Server Installer Sources
Sources can be copied from DVD or ISO file. ISO sources must be copied into
__SqlServer_SlipStream__\SOURCES\<SS_VERSION>\ISO
4.2. SQL Server Service Pack files
Download all supported architecture and store according to Service Pack
version. e.g. SQL Server 2008 SP3 files to be stored at
__SqlServer_SlipStream__\SOURCES\SS2008\SP3
- Set SQL Server SlipStream Configuration File and Change Profile Name
eg. YLNotes__SqlServer_Slipstream_Config_SP-SS2008R2_wSP2.cmd
- Execute SQL Server SlipStream Configuration File
eg. YLNotes__SqlServer_Slipstream_Config_SP-SS2008R2_wSP2.cmd
- Once the process is completed, the log will appear
-
Your SQL Server SlipStream ISO is ready at the following location:
__SqlServer_SlipStream__\DEPLOYMENT\<SS_VERSION>\ISO
How to check SQL Server Slipstream is successful
SQL Server 2008
SQL Server 2008 R2
Admin Scripts
- Download YLNotes__SqlServer_Slipstream.zip
Downloads Count: 231
Log Sample Output
- Download YLNotes__SqlServer_Slipstream_Engine_SP__LOG.zip
Downloads Count: 206
Companion Tools