Configure maintenance window in Azure SQL Managed Instance

To configure the maintenance window when you create a SQL managed instance, set the desired Maintenance window on the Additional settings page.

Set the maintenance window while creating a SQL managed instance

For step-by-step information on creating a new managed instance, see Create an Azure SQL Managed Instance.

The following examples show how to configure the maintenance window using Azure PowerShell. You can install Azure PowerShell.

Discover available maintenance windows

When setting the maintenance window, each region has its own maintenance window options that correspond to the timezone for the region.

Discover SQL Managed Instance maintenance windows

The following example returns the available maintenance windows for the chinaeast2 region using the Get-AzMaintenancePublicConfiguration cmdlet. For managed instances, set MaintenanceScope to SQLManagedInstance.

$location = "chinaeast2"

Write-Host "Available maintenance schedules in ${location}:"
$configurations = Get-AzMaintenancePublicConfiguration
$configurations | ?{ $_.Location -eq $location -and $_.MaintenanceScope -eq "SQLManagedInstance"}

Set the maintenance window while creating a SQL managed instance

The following example creates a new managed instance and sets the maintenance window using the New-AzSqlInstance cmdlet. The maintenance window is set on the instance, so all databases in the instance have the same maintenance window schedule. For -MaintenanceConfigurationId, the MaintenanceConfigName must be a valid value for your instance's region. To get valid values for your region, see Discover available maintenance windows.

New-AzSqlInstance -Name "your_mi_name" `
  -ResourceGroupName "your_resource_group_name" `
  -Location "your_mi_location" `
  -SubnetId /subscriptions/{SubID}/resourceGroups/{ResourceGroup}/providers/Microsoft.Network/virtualNetworks/{VNETName}/subnets/{SubnetName} `
  -MaintenanceConfigurationId "/subscriptions/{SubID}/providers/Microsoft.Maintenance/publicMaintenanceConfigurations/SQL_{Region}_{MaintenanceConfigName}"

The following examples show how to configure the maintenance window using Azure CLI. You can install Azure CLI.

Sign in to Azure

Use the following script to sign in using a different subscription, replacing <Subscription ID> with your Azure Subscription ID. If you don't have an Azure trail subscription, create a trial subscription before you begin.

subscription="<subscriptionId>" # add subscription here

az account set -s $subscription # ...or use 'az login'

For more information, see set active subscription or sign in interactively

Discover available maintenance windows

When setting the maintenance window, each region has its own maintenance window options that correspond to the timezone for the region.

Discover SQL Managed Instance maintenance windows

The following example returns the available maintenance windows for the chinaeast2 region using the az maintenance public-configuration list command. For managed instances, set maintenanceScope to SQLManagedInstance.

az maintenance public-configuration list --query "[?location=='chinaeast2'&&contains(maintenanceScope,'SQLManagedInstance')]"

Set the maintenance window while creating a SQL managed instance

The following example creates a new managed instance and sets the maintenance window using az sql mi create. The maintenance window is set on the instance, so all databases in the instance have the same maintenance window schedule. MaintenanceConfigName must be a valid value for your instance's region. To get valid values for your region, see Discover available maintenance windows. Replace <password> with a valid password.

az sql mi create -g mygroup -n myinstance -l mylocation -i -u myusername -p <password> --subnet /subscriptions/{SubID}/resourceGroups/{ResourceGroup}/providers/Microsoft.Network/virtualNetworks/{VNETName}/subnets/{SubnetName} -m /subscriptions/{SubID}/providers/Microsoft.Maintenance/publicMaintenanceConfigurations/SQL_{Region}_{MaintenanceConfigName}

The following steps set the maintenance window on an existing SQL managed instance using the Azure portal:

Set the maintenance window for an existing managed instance

1. Navigate to the SQL managed instance you want to set the maintenance window for.

2. In the Settings menu select Maintenance, then select the desired maintenance window.

   

Set the maintenance window on an existing managed instance

The following example sets the maintenance window on an existing managed instance using the Set-AzSqlInstance cmdlet. It's important to make sure that the $maintenanceConfig value must be a valid value for your instance's region. To get valid values for a region, see Discover available maintenance windows.

Set-AzSqlInstance -Name "your_mi_name" `
  -ResourceGroupName "your_resource_group_name" `
  -MaintenanceConfigurationId "/subscriptions/{SubID}/providers/Microsoft.Maintenance/publicMaintenanceConfigurations/SQL_{Region}_{MaintenanceConfigName}"

The following examples show how to configure the maintenance window using Azure CLI. You can install Azure CLI.

Set the maintenance window on an existing managed instance

The following example sets the maintenance window using az sql mi update. The maintenance window is set on the instance, so all databases in the instance have the same maintenance window schedule. For -MaintenanceConfigurationId, the MaintenanceConfigName must be a valid value for your instance's region. To get valid values for your region, see Discover available maintenance windows.

az sql mi update -g mygroup  -n myinstance -m /subscriptions/{SubID}/providers/Microsoft.Maintenance/publicMaintenanceConfigurations/SQL_{Region}_{MaintenanceConfigName}