locked
Upgrade SQLExpress2008 to SQLExpress2008 SP1 RRS feed

  • Question

  • I am trying to upgrade from SQL Express 2008 to SQL Express 2008 SP1 through command prompt. From what I have read so far, instanceid is required when you need to upgrade. So I used /INSTANCEID = SQLExpress. It is complaining that the instanceid already exists. When I upgraded SQL 2005 Express SP2 to SP3 through command prompt, I used UPGRADE=SQL_Engine and it worked fine. Then why I am not able to upgrade from SQLExpress 2008 to SQLExpress2008 SP1 without uninstalling?
    Tuesday, April 20, 2010 4:30 PM

Answers

  • Hi KParikh,

    In order to patch SP1 to the instance of SQL Server 2008 Express Edition from command prompt, please follow the steps:
    1. Download SQL Server 2008 SP1 from the following link
      http://www.microsoft.com/downloads/details.aspx?FamilyID=66ab3dbb-bf3e-4f46-9559-ccc6a4f9dc19&displaylang=en
    2. Run the following command to patch SP1 to the instance:
      SQLServer2008SP1-KB968369-x86-ENU.exe /Q /ACTION=PATCH /INSTANCENAME=<instance name>

    Note: If you are working on an operating system with User Account Control, please execute command prompt(cmd.exe) with "run as administrator".

    If there is anything unclear, please let me know.

    Regards,
    Tom Li
    • Proposed as answer by Tom Li - MSFT Thursday, April 22, 2010 9:02 AM
    • Marked as answer by Tom Li - MSFT Friday, April 23, 2010 1:18 AM
    Thursday, April 22, 2010 9:01 AM

All replies

  • Hello,

    You can install “SQL.Server 2008 Express Edition SP1” to upgrade your current SQL Server 2008 Express to Service Pack 1.

    http://download.microsoft.com/download/1/6/3/163A851B-D956-42E9-B426-F5C0EBE6B654/ReleaseNotes.htm

    I found the following on the Release Notes of this service pack:

    “The SQL Server 2008 Express (SQL Server Express) Service Pack installs new instances of SQL Server Express including the service pack or upgrades instances of SQL Server Express to the service pack”

    You don’t need to install this service pack from the command prompt to upgrade your SQL Server instance to SP1.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    Tuesday, April 20, 2010 6:48 PM
  • Alberto,

    Thank you for replying.

    I had already read the above statement from the release notes and thats why i am trying to use /ACTION=UPGRADE command. In my scenario I prefer to use command prompt, since there are lots of machines that i will be upgrading.

    Here is the command that i am using for upgrading SQL Server Express 2008 to SQL Server Express 2008 SP1. Name of the existing instance is SQLExpress:

    SQLEXPR32_x86_ENU.exe /QS /ACTION=UPGRADE /INSTANCENAME=SQLEXPRESS

    Please note that i have not passed /INSTANCEID command. But in the error below which is logged in the log file, it assumes that instanceid is SQLExpress2531, i dont know why.

    Error from log file: "The registry key SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.SQLExpress2531\Setup is missing"

     If i pass /INSTANCEID = SQLEXPRESS, it complains that it already exists.

     

    Tuesday, April 20, 2010 7:32 PM
  • Any solution?

    Thursday, April 22, 2010 2:43 AM
  • Hi KParikh,

    In order to patch SP1 to the instance of SQL Server 2008 Express Edition from command prompt, please follow the steps:
    1. Download SQL Server 2008 SP1 from the following link
      http://www.microsoft.com/downloads/details.aspx?FamilyID=66ab3dbb-bf3e-4f46-9559-ccc6a4f9dc19&displaylang=en
    2. Run the following command to patch SP1 to the instance:
      SQLServer2008SP1-KB968369-x86-ENU.exe /Q /ACTION=PATCH /INSTANCENAME=<instance name>

    Note: If you are working on an operating system with User Account Control, please execute command prompt(cmd.exe) with "run as administrator".

    If there is anything unclear, please let me know.

    Regards,
    Tom Li
    • Proposed as answer by Tom Li - MSFT Thursday, April 22, 2010 9:02 AM
    • Marked as answer by Tom Li - MSFT Friday, April 23, 2010 1:18 AM
    Thursday, April 22, 2010 9:01 AM
  • Tom Li,

    Finally this worked. Thanks a lot! Where do I find this info? I didnt see it in the release notes for SP1.

    Thursday, April 22, 2010 4:16 PM