SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Slipstream - Makes installs simple

I was recently working on building a test environment for myself while I was studying for the MCITP-Database Administration exams.  SQL Server 2008 supports creating a slipstream install for service packs and cumulative updates so you can install to the latest SP or cumulative update in one step.

The problem with a slipstream install is that you need to set it up first, so for a single install I'm not sure how much time you actually save, but for multiple installs or for creating media it is great.  I followed the instructions Peter Saddow's blog on msdn.  I'm not going to duplicate those instructions here, as they are easy to follow and worked. 

Once I finished setting up the slipstreamed install location, I downloaded ISO Recorder and used it to create an ISO image of the install directory.  ISO Recorder adds "Create ISO image file" to the right-click menu.  I did the ISO image as I was installing SQL Server on some virtual machines and didn't want to have to share the install location and I also wanted to be able to easily burn it to DVD.  The only issue I had was that Virtual PC would not successfully mount the created ISO image.  Fortunately I had already downloaded Virtual Clove Drive, which would allow me to mount the ISO image.  I'm not sure why Virtual PC would not allow me to mount it.  Once I got the ISO image mounted I was able to install SQL Server 2008 + SP1 without issue on a couple of VM's.  It was definitely worth the time to create the slipstream.

Anyone else have any experiences to share or issues they encountered?


Posted by Jason Brimhall on 29 March 2010

This brings back memories of my netadmin days.  Slipstreaming was an excellent tool.  We used it to build bootable PE disks as well.  Thanks for sharing this with us.

Posted by Glenn Berry on 29 March 2010

I can see where a slipstreamed install can save time if you need to do a number of fresh installs. The more common scenario for me is applying the latest CU to a number of existing servers.

Posted by Jack Corbett on 30 March 2010

Thanks for the comments guys.


I just learned the hard way this afternoon that Slipstream just makes sense.  See my newest blog post.

Leave a Comment

Please register or log in to leave a comment.