az sql failover-group

Manage SQL Failover Groups. Azure CLI reference

3 commands 14 options Its page in the Azure CLI reference

Commands

3, each with its page

createCreates a failover group.set-primarySet the primary of the failover group by failing over all databases from the current primary server.updateUpdates the failover group.

Options

14 in the Azure CLI reference

--add-dbList of databases to add to Failover Group

--allow-data-lossComplete the failover even if doing so may result in data loss.

--failover-policyThe failover policy of the Failover Group

--grace-periodInterval in hours before automatic failover is initiated if an outage occurs on the primary server.

--name, -nThe name of the Failover Group

--partner-resource-groupThe name of the resource group of the partner server

--partner-server-idsThe list of partner server resource id's of the Failover Group

--partner-serverThe name of the partner server of a Failover Group

--remove-dbList of databases to remove from Failover Group

--ro-endpoint-targetThe resource id of the read only endpoint target server

--ro-failover-policyThe policy of the read only endpoint of the Failover Group

--secondary-typeDatabases secondary type on partner server

--server, -sName of the Azure SQL Server.

--try-planned-before-forced-failover, --tpbffPerforms a planned failover as the first step, and if it fails for any reason, then initiates a forced failover with potential data loss.