CmdID

CmdID / az / az sql

az sql instance-failover-group

Manage SQL Instance Failover Groups. Azure CLI reference

3 commands 10 options Its page in the Azure CLI reference

Opens CmdID with your command. It is read in your browser and sent nowhere.

Commands

3, each with its page
createCreates an instance failover group between two connected managed instances.set-primarySet the primary of the instance failover group by failing over all databases from the current primary managed instance.updateUpdates the instance failover group.

Options

10 in the Azure CLI reference
--allow-data-lossComplete the failover even if doing so may result in data loss.
--failover-policyThe failover policy of the Instance Failover Group
--grace-periodInterval in hours before automatic failover is initiated if an outage occurs on the primary server.
--location, -lLocation of the secondary instance in the Instance Failover Group.
--name, -nThe name of the Instance Failover Group
--partner-miThe name of the partner managed instance of a Instance Failover Group
--partner-resource-groupThe name of the resource group of the partner managed instance
--resource-group, -gName of resource group of the secondary instance in the Instance Failover Group.
--secondary-typeIntended usage of the secondary instance in the Failover Group.
--source-mi, --miName of the Azure SQL Managed Instance.