< Back

New-AzureRmVMSqlServerAutoPatchingConfig

Tue Jan 29, 2019 9:38 pm

NAME New-AzureRmVMSqlServerAutoPatchingConfig



SYNOPSIS

Creates a configuration object for automatic patching on a virtual machine.





SYNTAX

New-AzureRmVMSqlServerAutoPatchingConfig [-DayOfWeek {Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Everyday}] [-Enable]

[-MaintenanceWindowDuration <Int32>] [-MaintenanceWindowStartingHour <Int32>] [-PatchCategory {Important}] [<CommonParameters>]





DESCRIPTION

The New-AzureRmVMSqlServerAutoPatchingConfig cmdlet creates a configuration object for automatic patching on a virtual machine.





PARAMETERS

-DayOfWeek <String>

Specifies the day of the week when updates should be installed.



The acceptable values for this parameter are:



- Sunday



- Monday



- Tuesday



- Wednesday



- Thursday



- Friday



- Saturday



- Everyday



Required? false

Position? named

Default value None

Accept pipeline input? False

Accept wildcard characters? false



-Enable [<SwitchParameter>]

Indicates that automated patching for the virtual machine is enabled. If you enable automated patching the cmdlet puts Windows Update into

interactive mode. If you disable automated patching, Windows Update settings do not change.



Required? false

Position? named

Default value False

Accept pipeline input? False

Accept wildcard characters? false



-MaintenanceWindowDuration <Int32>

Specifies the duration, in minutes, of the maintenance window. Automated patching avoids performing an action that can affect a virtual

machine availability outside that window. Specify a multiple of 30 minutes.



Required? false

Position? named

Default value None

Accept pipeline input? False

Accept wildcard characters? false



-MaintenanceWindowStartingHour <Int32>

Specifies the hour of the day when maintenance window starts. This time defines when updates start to install.



Required? false

Position? named

Default value None

Accept pipeline input? False

Accept wildcard characters? false



-PatchCategory <String>

Specifies whether important updates should be included.



Required? false

Position? named

Default value None

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 (http://go.microsoft.com/fwlink/?LinkID=113216).



INPUTS

None

This cmdlet does not accept any input.





OUTPUTS

AutoPatchingSettings

This cmdlet returns object contains settings for automated patching.





NOTES









Example 1: Create a configuration object to configure automatic patching



PS C:\\> $AutoPatchingConfig = New-AzureRmVMSqlServerAutoPatchingConfig -Enable -DayOfWeek "Thursday" -MaintenanceWindowStartingHour 11

-MaintenanceWindowDuration 120 -PatchCategory "Important"

Enable : True

DayOfWeek : Thursday

MaintenanceWindowStartingHour : 11

MaintenanceWindowDuration : 120

PatchCategory : Important



This command creates configuration object for patching. The command specifies the day of the week and defines the maintenance window. This

configuration enables patching that uses these values. The command stores the result in the $AutoBackupConfig variable. You can specify this

configuration item for other cmdlets, such as the Set-AzureRmVMSqlServerExtension cmdlet.







RELATED LINKS

Online Version: https://docs.microsoft.com/en-us/powers ... hingconfig

New-AzureVMSqlServerAutoBackupConfig

Set-AzureRmVMSqlServerExtension