Skip to content

installing-updates-from-the-command-prompt.md

Latest commit

 

History

History
93 lines (72 loc) · 5.49 KB

installing-updates-from-the-command-prompt.md

File metadata and controls

93 lines (72 loc) · 5.49 KB
title Installing Updates from the Command Prompt | Microsoft Docs
ms.custom
ms.date 09/08/2017
ms.prod sql-non-specified
ms.prod_service database-engine
ms.service
ms.component install-windows
ms.reviewer
ms.suite sql
ms.technology
database-engine
ms.tgt_pltfrm
ms.topic article
ms.assetid bc98ba2b-aae9-4d01-aa85-d4c36428cb0b
caps.latest.revision 18
author MikeRayMSFT
ms.author mikeray
manager craigg

Installing Updates from the Command Prompt

[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md] Test and modify installation scripts to meet the needs of your organization.

Sample Syntax for Installation

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 [!INCLUDEssNoVersion] and all shared components, like [!INCLUDEssISnoversion] and Management Tools: You can specify the instance either by using the InstanceName parameter or the InstanceID parameter. To update a prepared instance of [!INCLUDEssNoVersion], you must specify the InstanceID parameter.

    <package_name>.exe /qs /IAcceptSQLServerLicenseTerms /Action=/proxy/https/github.com/MicrosoftDocs/sql-docs/blob/45df11126d69a5f81fd92de5876bf0aa5e3f32d4/docs/database-engine/install-windows/Patch /InstanceName=MyInstance

    or

    <package_name>.exe /qs /IAcceptSQLServerLicenseTerms /Action=/proxy/https/github.com/MicrosoftDocs/sql-docs/blob/45df11126d69a5f81fd92de5876bf0aa5e3f32d4/docs/database-engine/install-windows/Patch /InstanceID=\<Instance ID>.

  • Setup can integrate the latest product updates with the main product installation so that the main product and its applicable updates are installed at the same time. You can prepare an installation of database engine instance to include product update:

    setup.exe /q /IAcceptSQLServerLicenseTerms /ACTION=/proxy/https/github.com/MicrosoftDocs/sql-docs/blob/45df11126d69a5f81fd92de5876bf0aa5e3f32d4/docs/database-engine/install-windows/PrepareImage /UpdateEnabled=True /UpdateSource=\<path where the update is downloaded> /INSTANCEID=\<Instance ID> /FEATURES=SQLEngine.

  • Update [!INCLUDEssNoVersion] shared components only, like [!INCLUDEssISnoversion] and Management Tools:

    <package_name>.exe /qs /IAcceptSQLServerLicenseTerms /Action=/proxy/https/github.com/MicrosoftDocs/sql-docs/blob/45df11126d69a5f81fd92de5876bf0aa5e3f32d4/docs/database-engine/install-windows/Patch

  • Update all instances of [!INCLUDEssNoVersion] on the computer and all shared components, like [!INCLUDEssISnoversion] and Management Tools:

    <package_name>.exe /qs /IAcceptSQLServerLicenseTerms /Action=/proxy/https/github.com/MicrosoftDocs/sql-docs/blob/45df11126d69a5f81fd92de5876bf0aa5e3f32d4/docs/database-engine/install-windows/Patch /AllInstances.

  • Remove an update from a single instance of [!INCLUDEssNoVersion] and all shared components, like [!INCLUDEssISnoversion] and Management Tools:

    <package_name>.exe /qs /Action=/proxy/https/github.com/MicrosoftDocs/sql-docs/blob/45df11126d69a5f81fd92de5876bf0aa5e3f32d4/docs/database-engine/install-windows/RemovePatch /InstanceName=MyInstance.

  • Remove an update from [!INCLUDEssNoVersion] shared components only, like [!INCLUDEssISnoversion] and Management Tools:

    <package_name>.exe /qs /Action=/proxy/https/github.com/MicrosoftDocs/sql-docs/blob/45df11126d69a5f81fd92de5876bf0aa5e3f32d4/docs/database-engine/install-windows/RemovePatch

    [!NOTE] The update installer ensures that the shared components are always at or above the version of the instance at the highest level.

Supported parameters

Important

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=/proxy/https/github.com/MicrosoftDocs/sql-docs/blob/45df11126d69a5f81fd92de5876bf0aa5e3f32d4/docs/database-engine/install-windows/Patch or /action=/proxy/https/github.com/MicrosoftDocs/sql-docs/blob/45df11126d69a5f81fd92de5876bf0aa5e3f32d4/docs/database-engine/install-windows/RemovePatch%3C/strong> Specifies the installation action: Patch or RemovePatch.
/allinstances Applies the [!INCLUDEssNoVersion] update to all instances of [!INCLUDEssNoVersion] and to all [!INCLUDEssNoVersion] shared, instance-unaware components.
/instancename=InstanceName* Applies the [!INCLUDEssNoVersion] update to an instance of [!INCLUDEssNoVersion] named InstanceName, and to all [!INCLUDEssNoVersion] shared, instance-unaware components.
/InstanceID=Inst1 Applies the [!INCLUDEssNoVersion] update to an instance of [!INCLUDEssNoVersion] Inst1, and to all [!INCLUDEssNoVersion] shared, instance-unaware components.
/quiet Runs the [!INCLUDEssNoVersion] update Setup in unattended mode.
/qs Displays only the progress UI dialog.
/UpdateEnabled Specifies whether [!INCLUDEssNoVersion] setup should discover and include product updates. The valid values are True and False or 1 and 0. By default, [!INCLUDEssNoVersion] setup will include updates that are found.
/IAcceptSQLServerLicenseTerms Required only when the /Q or /QS parameter is specified for unattended installations.

*You cannot specify this parameter to apply an update to a prepared instance of [!INCLUDEssNoVersion]. You must specify the /instanceID parameter instead.

See also

Overview of SQL Server Servicing Installation