Export (0) Print
Expand All

Installing Updates from the Command Prompt

Test and modify installation scripts to meet the needs of your organization. For information about installing updates to a SQL Server 2008 failover cluster, see How to apply a SQL Server 2008 update to a failover cluster instance in the Microsoft Knowledge Base.

The name of the update package can vary and may include a language, edition, and processor component. Apply an update at a command prompt replacing <package_name> with the name of your update package:

  • Update a single instance of SQL Server and all shared components, like Integration Services and Management Tools: <package_name>.exe /qs /Action=Patch /InstanceName=MyInstance
  • Update SQL Server shared components only, like Integration Services and Management Tools: <package_name>.exe /qs /Action=Patch
  • Update all instances of SQL Server on the computer and all shared components, like Integration Services and Management Tools: <package_name>.exe /qs /Action=Patch /AllInstances

Remove an update from the command prompt replacing <package_name> with the name of your update package:

  • Remove an update from a single instance of SQL Server and all shared components, like Integration Services and Management Tools: <package_name>.exe /qs /Action=RemovePatch /InstanceName=MyInstance
  • Remove an update from SQL Server shared components only, like Integration Services and Management Tools: <package_name>.exe /qs /Action=RemovePatch
    Dd638066.note(en-us,SQL.100).gifNote:
    The update installer ensures that the shared components are always at or above the version of the instance at the highest level.

Dd638066.note(en-us,SQL.100).gifImportant:
When possible, supply security credentials at run time. If you must store credentials in a script file, secure the file to prevent unauthorized access.

Switch Description

/?

Displays unattended installation command prompt help.

/action=Patch or /action=RemovePatch

Specifies the installation action: Patch or RemovePatch.

/allinstances

Applies the SQL Server 2008 update to all instances of SQL Server 2008 and to all SQL Server 2008 shared, instance-unaware components.

/instancename=InstanceName

Applies the SQL Server 2008 update to an instance of SQL Server 2008 named InstanceName, and to all SQL Server 2008 shared, instance-unaware components.

/quiet

Runs the SQL Server 2008 update Setup in unattended mode.

/qs

Displays only the progress UI dialog.

/CUSource

Specifies the path for the extracted cumulative update files.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft