SQL Server 2012 ISO has come with SP1 for a while now. But we still have 8 CU at present (The latest coming out in Jan of this year).

To install a CU along during your install follow these steps.

Preparation Steps

Download your ISO to a directory. (For me this is “C:\Software\SQL Server 2012\”)

Download the CU / Patch you want to install. For me that was CU 8

Extract your zip file to the location that the SQL Server install will pick it up from

For me this is “C:\Software\SQL Server 2012 SP1 CU”

clip_image001

You get asked if you want to run this file

clip_image002

You’ll then get notified that you are about to unzip some files.

clip_image003

Pick your location to Extract to:

clip_image004

Select the … to pick the location

clip_image005

clip_image006

The app will then extract the file to the location

clip_image007

Hopefully you will the see the Successfully unzipped notification

clip_image008

This should give you a exe file you can now delete the zip file or save it to a location of your choice.

clip_image009

Install Steps

Now we want to install SQL Server and link to that folder with CU 8.

To do so you need run the setup.exe with some switches those being

/Action=Install

Guess what that does!

/UpdateSource=”\\DC\Software\SQL Server 2012 SP1 CU”

Full Text:

setup.exe /Action=Install /UpdateSource=”\\DC\Software\SQL Server 2012 SP1 CU”

Note the .\setup.exe is due to dot sourcing in PowerShell

Points to the folder with the CU we extracted on the DC server earlier.

clip_image010

We then get the UAC notification

clip_image011

Here we are just following the normal Install steps

clip_image012

clip_image013

clip_image014

Here is where we can confirm the update is being installed! As the Product update page should show the HotFix

clip_image015

From here. Simply follow on the steps you would normally to install.

Advertisements