az sql instance-failover-group
Manage SQL Instance Failover Groups.
Name | Description | Type | Status |
---|---|---|---|
az sql instance-failover-group create |
Creates an instance failover group between two connected managed instances. |
Core | GA |
az sql instance-failover-group delete |
Deletes a failover group. |
Core | GA |
az sql instance-failover-group set-primary |
Set the primary of the instance failover group by failing over all databases from the current primary managed instance. |
Core | GA |
az sql instance-failover-group show |
Gets a failover group. |
Core | GA |
az sql instance-failover-group update |
Updates the instance failover group. |
Core | GA |
Creates an instance failover group between two connected managed instances.
If an outage occurs on the primary server, the grace period indicates that Azure SQL Managed Database will not initiate automatic failover before the grace period expires. Please note that failover operation with --allow-data-loss option might cause data loss due to the nature of asynchronous synchronization.
az sql instance-failover-group create --mi
--name
--partner-mi
--partner-resource-group
--resource-group
[--failover-policy {Automatic, Manual}]
[--grace-period]
[--secondary-type]
Name of the Azure SQL Managed Instance.
The name of the Instance Failover Group.
The name of the partner managed instance of a Instance Failover Group.
The name of the resource group of the partner managed instance.
Name of resource group. You can configure the default group using az configure --defaults group=<name>
.
The failover policy of the Instance Failover Group.
Interval in hours before automatic failover is initiated if an outage occurs on the primary server. This indicates that Azure SQL Database will not initiate automatic failover before the grace period expires. Please note that failover operation with --allow-data-loss option might cause data loss due to the nature of asynchronous synchronization.
Intended usage of the secondary instance in the Failover Group. Standby indicates that the secondary instance will be used as a passive replica for disaster recovery only.
Global Parameters
Increase logging verbosity to show all debug logs.
Show this help message and exit.
Only show errors, suppressing warnings.
Output format.
JMESPath query string. See http://jmespath.org/ for more information and examples.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Increase logging verbosity. Use --debug for full debug logs.
Deletes a failover group.
az sql instance-failover-group delete --location
--name
--resource-group
Location. Values from: az account list-locations
. You can configure the default location using az configure --defaults location=<location>
.
The name of the Instance Failover Group.
Name of resource group. You can configure the default group using az configure --defaults group=<name>
.
Global Parameters
Increase logging verbosity to show all debug logs.
Show this help message and exit.
Only show errors, suppressing warnings.
Output format.
JMESPath query string. See http://jmespath.org/ for more information and examples.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Increase logging verbosity. Use --debug for full debug logs.
Set the primary of the instance failover group by failing over all databases from the current primary managed instance.
az sql instance-failover-group set-primary --location
--name
--resource-group
[--allow-data-loss]
Location of the secondary instance in the Instance Failover Group. Values from: az account list-locations
. You can configure the default location using az configure --defaults location=<location>
.
The name of the Instance Failover Group.
Name of resource group of the secondary instance in the Instance Failover Group. You can configure the default group using az configure --defaults group=<name>
.
Complete the failover even if doing so may result in data loss. This will allow the failover to proceed even if a primary database is unavailable.
Global Parameters
Increase logging verbosity to show all debug logs.
Show this help message and exit.
Only show errors, suppressing warnings.
Output format.
JMESPath query string. See http://jmespath.org/ for more information and examples.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Increase logging verbosity. Use --debug for full debug logs.
Gets a failover group.
az sql instance-failover-group show --location
--name
--resource-group
Location. Values from: az account list-locations
. You can configure the default location using az configure --defaults location=<location>
.
The name of the Instance Failover Group.
Name of resource group. You can configure the default group using az configure --defaults group=<name>
.
Global Parameters
Increase logging verbosity to show all debug logs.
Show this help message and exit.
Only show errors, suppressing warnings.
Output format.
JMESPath query string. See http://jmespath.org/ for more information and examples.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Increase logging verbosity. Use --debug for full debug logs.
Updates the instance failover group.
az sql instance-failover-group update --location
--name
--resource-group
[--add]
[--failover-policy {Automatic, Manual}]
[--force-string]
[--grace-period]
[--remove]
[--secondary-type]
[--set]
Location. Values from: az account list-locations
. You can configure the default location using az configure --defaults location=<location>
.
The name of the Instance Failover Group.
Name of resource group. You can configure the default group using az configure --defaults group=<name>
.
Add an object to a list of objects by specifying a path and key value pairs. Example: --add property.listProperty <key=value, string or JSON string>
.
The failover policy of the Instance Failover Group.
When using 'set' or 'add', preserve string literals instead of attempting to convert to JSON.
Interval in hours before automatic failover is initiated if an outage occurs on the primary server. This indicates that Azure SQL Database will not initiate automatic failover before the grace period expires. Please note that failover operation with --allow-data-loss option might cause data loss due to the nature of asynchronous synchronization.
Remove a property or an element from a list. Example: --remove property.list <indexToRemove>
OR --remove propertyToRemove
.
Intended usage of the secondary instance in the Failover Group. Standby indicates that the secondary instance will be used as a passive replica for disaster recovery only.
Update an object by specifying a property path and value to set. Example: --set property1.property2=<value>
.
Global Parameters
Increase logging verbosity to show all debug logs.
Show this help message and exit.
Only show errors, suppressing warnings.
Output format.
JMESPath query string. See http://jmespath.org/ for more information and examples.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Increase logging verbosity. Use --debug for full debug logs.
Azure CLI feedback
Azure CLI is an open source project. Select a link to provide feedback: