Tuesday, 18 June 2013

Install SQL Server 2012 with all the latest Service packs and Patches with one command

Install SQL Server 2012 with all the latest Service packs and Patches with one command

When you are installing a new instance of SQL Server, you want to perform as few steps as possible. SQL Server 2012 setup is much better about slipstreaming both service packs and cumulative updates than SQL Server 2008 / 2008 R2. This method is deprecated, but it is still supported in SQL Server 2012. So while you can still use the old method if you wanted:
D:\setup.exe /Action=Install /PCUSource=C:\SP1ExtractedFolder /CUSource=C:\CU1ExtractedFolder
The new method, which you should be using, is much simpler – and doesn’t require you to manually extract the packages using the /x argument first:
D:\setup.exe /Action=Install /UpdateSource=C:\AllUpdatesFolder
You just need to put all of the relevant updates in the same folder. Note that any update you get with the filename [...]_zip.exe, you need to extract out to get the core executable. For example, when you first download Service Pack 1 and Cumulative Update 1, the download folder will look like this:

You need to extract 455715_intl_x64_zip.exe by double-clicking on it and choosing the output path (using /x at the command line is valid, but ignored). Once done, the folder should end up looking like this. (At which point,
you can delete the 455715... file )
Now when you run the above command line, when you get to the Product Updates screen in setup, you should see that it has included both SP1 and latest CU available in your AllUpdatesfolder:

Bob Ward does a very good job of describing this scenario in much more detail here: CSS Blog : SQL Server 2012 Setup just got smarter…
Note that you can keep all of your Service Packs and Cumulative Updates over time in the same folder – if you use the /UpdateSource argument, SQL Server Setup will be smart enough to choose the latest SP and its latest CU, regardless of what else might exist in that folder

1 comment:

  1. There is noticeably much to experience this. I believe you made several well points in Features as well. http://www.lowhosting.com/justhost-review/