commands

^

Invoke-DbaAdvancedUpdate

Author Kirill Kravtsov (@nvarscar)
Availability Windows, Linux, macOS

 

Want to see the source code for this command? Check out Invoke-DbaAdvancedUpdate on GitHub.
Want to see the Bill Of Health for this command? Check out Invoke-DbaAdvancedUpdate.

Synopsis

Designed for internal use, implements parallel execution for Update-DbaInstance.

Description

Invokes an update process for a single computer and restarts it if needed

Syntax

Invoke-DbaAdvancedUpdate
    [[-ComputerName] <String>]
    [[-Action] <Object[]>]
    [[-Restart] <Boolean>]
    [[-Authentication] <String>]
    [[-Credential] <PSCredential>]
    [[-ExtractPath] <String>]
    [[-ArgumentList] <String[]>]
    [-NoPendingRenameCheck]
    [-EnableException]
    [-WhatIf]
    [-Confirm]
    [<CommonParameters>]

 

Examples

 

Example: 1
PS C:\> Invoke-DbaAdvancedUpdate -ComputerName SQL1 -Action $actions

Invokes update actions on SQL1 after restarting it.

Example: 2
PS C:\> Invoke-DbaAdvancedUpdate -ComputerName SQL1 -Action $actions -ExtractPath C:\temp

Extracts required files to the specific location "C:\temp". Invokes update actions on SQL1 after restarting it.

Optional Parameters

-ComputerName

Target computer with SQL instance or instances.

Alias
Required False
Pipeline false
Default Value
-Action

An object containing the action plan

Alias
Required False
Pipeline false
Default Value
-Restart

Restart computer automatically after a successful installation of a patch and wait until it comes back online.
Using this parameter is the only way to chain-install more than 1 patch on a computer, since every single patch will require a restart of said computer.

Alias
Required False
Pipeline false
Default Value False
-Authentication

Chooses an authentication protocol for remote connections.
If the protocol fails to establish a connection
Defaults:

  • CredSSP when -Credential is specified - due to the fact that repository Path is usually a network share and credentials need to be passed to the remote host to avoid the double-hop issue.
  • Default when -Credential is not specified. Will likely fail if a network path is specified.
Alias
Required False
Pipeline false
Default Value Credssp
Accepted Values Default,Basic,Negotiate,NegotiateWithImplicitCredential,Credssp,Digest,Kerberos
-Credential

Windows Credential with permission to log on to the remote server.
Must be specified for any remote connection if update Repository is located on a network folder.

Alias
Required False
Pipeline false
Default Value
-ExtractPath

Lets you specify a location to extract the update file to on the system requiring the update. e.g. C:\temp

Alias
Required False
Pipeline false
Default Value
-ArgumentList

A list of extra arguments to pass to the execution file. Accepts one or more strings containing command line parameters.
Example: ... -ArgumentList "/SkipRules=RebootRequiredCheck", "/Q"

Alias
Required False
Pipeline false
Default Value
-NoPendingRenameCheck

Disables pending rename validation when checking for a pending reboot.

Alias
Required False
Pipeline false
Default Value False
-EnableException

By default, when something goes wrong we try to catch it, interpret it and give you a friendly warning message.
This avoids overwhelming you with "sea of red" exceptions, but is inconvenient because it basically disables advanced scripting.
Using this switch turns this "nice by default" feature off and enables you to catch exceptions with your own try/catch.

Alias
Required False
Pipeline false
Default Value False
-WhatIf

Shows what would happen if the command were to run. No actions are actually performed.

Alias wi
Required False
Pipeline false
Default Value
-Confirm

Prompts you for confirmation before executing any changing operations within the command.

Alias cf
Required False
Pipeline false
Default Value