Friday, May 4, 2012

SQL Server 2012 Product Updates (Slipstream)

Microsoft has released the first cumulative update for SQL Server 2012 last month (April 2012). It can be found here. There are about 50+ fixes that are being addressed by this cumulative update package. In order to get the cumulative update package, you will need to provide your e-mail address to request for the files and Microsoft will then send the link to download those files thru e-mail.

The cumulative updates come in two flavor, for 32-bit (x86 platform) and 64-bit (x64 platform). In addition, for each platform, there are 3 update files:

  • SQL Server 2012
    • SQLServer2012_RTM_CU1_kb2679368_11_0_2316_x86
      • Self-extracting file name: 446573_intl_i386_zip.exe
      • Extracted file name: SQLServer2012-KB2679368-x86.exe
    • SQLServer2012_RTM_CU1_kb2679368_11_0_2316_x64
      • Self-extracting file name: 446572_intl_x64_zip.exe
      • Extracted file name: SQLServer2012-KB2679368-x64.exe
  • PowerPivot for Excel
    • 2012_RTM_PPExcel_CU1_KB2679368_11_0_2316_x86
      • Self-extracting file name: 446568_intl_i386_zip.exe
      • Extracted file name: PowerPivot_for_Excel_x86.msi
    • 2012_RTM_PPExcel_CU1_KB2679368_11_0_2316_x64
      • Self-extracting file name: 446571_intl_x64_zip.exe
      • Extracted file name: PowerPivot_fot_Excel_amd64.msi
  • Data-Tier App Framework
    • 2012_RTM_DACFX_CU1_KB2679368_11_0_2316_x86
      • Self-extracting file name: 446569_intl_i386_zip.exe
      • Extracted file name: DACFramework.msi
    • 2012_RTM_DACFX_CU1_KB2679368_11_0_2316_x64
      • Self-extracting file name: 446570_intl_x64_zip.exe
      • Extracted file name: DACFramework.msi

Installing SQL Server 2012 Cumulative Update 1

Installing the cumulative update for SQL Server 2012 is pretty straightforward.

  • After you get the e-mail from Microsoft, download the appropriate file (in my case, I have the 64-bit version of SQL Server 2012, so I downloaded 446572_intl_i386_zip.exe).
  • Then I just run that file that I have just downloaded. It will run the Microsoft Self-Extractor and ask for the folder location on where you want to extract the file package. This should extract an exe file. In my case, it is SQLServer2012-KB2679368-x64.exe.
  • After that, I just run the exe file on the server where Microsoft SQL Server 2012 is installed.

Product Updates (the successor of Slipstream)

Now let say you need to deploy SQL Server 2012 with cumulative update 1 to several new servers. Obviously you can just install SQL Server 2012 on each of the new servers and then apply the cumulative update 1 after the SQL Server has been installed.

Alternatively you can combine them into one process. So basically, you would tell the install process to also apply the update(s). This process is known as slipstream. Although, as per Deprecated SQL Server Features in SQL Server 2012 article, Slipstream is being replaced by Product Updates. You still can use the command line parameters associated with Slipstream but it might be gone in the future.

The command line parameters associated with Product Updates in SQL Server 2012 are UpdateEnabled (either True or False) and UpdateSource (Specify the directory location where update file(s) are located). For more information on how to use the parameters, it can be found here.

Putting it to Practice

Using Product Updates to apply cumulative update package 1 for SQL Server 2012 is fairly simple. Let say that you want to set up SQL Server 2012 with cumulative update package 1, you can do the following:

  • On the server where you want to install SQL Server 2012 with cumulative update 1, create a new folder. Let say you create the following folder C:\Updates (don’t have to be local, it probably makes sense to run put this on a network share).
  • After you have download and extract the cumulative update file SQLServer2012-KB2679368-x64.exe, put that file onto C:\Updates.
  • Insert SQL Server 2012 installation DVD. Let say that your DVD drive is on D drive.
  • Open your command line, navigate to D drive and type in the following command:

Setup.exe /Action=Install /UpdateEnabled=True /UpdateSource=”C:\Updates”

image

  • SQL Server 2012 Setup process should then start. After the Setup Support Rules, you should then see the following screen:

image

  • Then again on the Ready to Install page, you should see the following:

image

  • And if you scroll down, you will see the following:

image

  • Once the installation has been completed, if you check the SQL Server 2012 version, you should get 11.0.2316.0.

image

7 comments:

  1. Is there any way to put the /UpdateEnabled=True /UpdateSource=”.\Updates” to DefaultSetup.ini?
    If I don't want to manually specify commandlines, I want it to run automatically?

    ReplyDelete
  2. Hi Alex, yes you can put UpdateEnabled=True and UpdateSource=".\Updates" into the DefaultSetup.ini. Actually I was going to have a blog post on this in about a day or two.

    So basically, you just need to edit the DefaultSetup.ini that are located on x86 or x64 folder and under the [OPTION], you can put those parameters. You can even put Action=Install, so that it will automatically kickoff the setup process right away.

    ReplyDelete
  3. Hi Lucas,

    Question to "slipstream" Updates in Microsoft SQL Server 2012.

    Is it possible that all updates from a cumulative update - this time e. g. - "DACFramework.msi", "PowerPivot_for_Excel_x86.msi" and "PowerPivot_for_Excel_amd64.msi" from CU1 could be included in an update folder and will be applied or just the CU1 (exe-files) itself?

    Greetings Peter

    ReplyDelete
  4. Hi Peter

    I believe the answer to that the product updates will only read and apply the SQLServer2012-KB2679368-x86.exe or SQLServer2012-KB2679368-x64.exe. Even if you put the DACFramework.msi, PowerPivot_for_Excel_x86.msi and PowerPivot_for_Excel_amd64.msi, the Product Updates will not apply them during the setup process.

    ReplyDelete
  5. Did you ever try Image preparation after specifying an updatesoource location? I am trying this with SQL 2102 with SP1 and CU2 download. I extraced CU2 C:\Updates folder and use setup.exe /UpdateEnabled="True" /UpdateSource=C:\Updates.

    After this, I am not installing but selecting image preparation from Advanced options. SQL Setup scans for updates but fails saying that the update server cannot be reached. Do you know why? I have no internet connection on the system where I am trying this.

    ReplyDelete
  6. Hi Ravi

    I have tried the Image Preparation before and has some success. Basically, what I did is use the command line:

    setup.exe /Action=PrepareImage /UpdateEnabled=True /UpdateSource="C:\Updates"

    The error that you are getting is actually similar to the error that we will get if we do not include the action parameter and do a stand alone SQL Server install (the regular install). For some reasons, it keeps defaulting to checking the Windows Update for the updates.

    Thank you
    Lucas

    ReplyDelete
    Replies
    1. I've found that you shoudl NOT extract the hotfix package and just put the exe in the spated folder instead.

      Delete