< Back

Invoke-DbaAdvancedUpdate

Mon Jan 13, 2020 12:09 pm

NAME Invoke-DbaAdvancedUpdate



SYNOPSIS

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





SYNTAX

Invoke-DbaAdvancedUpdate [[-ComputerName] <String>] [[-Action] <System.Object[]>] [[-Restart] <Bool>]

[[-Authentication] <String>] [[-Credential] <Pscredential>] [[-ExtractPath] <String>] [-EnableException <Switch>]

[<CommonParameters>]





DESCRIPTION

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





PARAMETERS

-Action [<System.Object[]>]

An object containing the action plan



Required? false

Position? named

Default value

Accept pipeline input? False

Accept wildcard characters? false



-Authentication [<String>]

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.



Required? false

Position? named

Default value

Accept pipeline input? False

Accept wildcard characters? false



-ComputerName [<String>]

Target computer with SQL instance or instances.



Required? false

Position? named

Default value

Accept pipeline input? False

Accept wildcard characters? false



-Credential [<Pscredential>]

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.



Required? false

Position? named

Default value

Accept pipeline input? False

Accept wildcard characters? false



-EnableException [<Switch>]

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.



Required? false

Position? named

Default value

Accept pipeline input? False

Accept wildcard characters? false



-ExtractPath [<String>]

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



Required? false

Position? named

Default value

Accept pipeline input? False

Accept wildcard characters? false



-Restart [<Bool>]

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.



Required? false

Position? named

Default value

Accept pipeline input? False

Accept wildcard characters? false



<CommonParameters>

This cmdlet supports the common parameters: Verbose, Debug,

ErrorAction, ErrorVariable, WarningAction, WarningVariable,

OutBuffer, PipelineVariable, and OutVariable. For more information, see

about_CommonParameters (https:/go.microsoft.com/fwlink/?LinkID=113216).



INPUTS



OUTPUTS



-------------------------- 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.



RELATED LINKS