Skip to content

Latest commit

 

History

History
55 lines (38 loc) · 2.23 KB

setup-geodr-failover-group-cli.md

File metadata and controls

55 lines (38 loc) · 2.23 KB
title description author ms.author ms.reviewer ms.date ms.service ms.subservice ms.topic ms.devlang ms.custom
Azure CLI example: Configure a failover group for a group of databases in Azure SQL Database
Use this Azure CLI example script to set up a failover group for a set of databases in Azure SQL Database and fail it over.
WilliamDAssafMSFT
wiassaf
mathoma
01/26/2022
azure-sql-database
high-availability
sample
azurecli
devx-track-azurecli

Configure a failover group for a group of databases in Azure SQL Database using the Azure CLI

[!INCLUDEappliesto-sqldb]

[!INCLUDE quickstarts-free-trial-note]

[!INCLUDE azure-cli-prepare-your-environment.md]

Sample script

[!INCLUDE cli-launch-cloud-shell-sign-in.md]

Run the script

:::code language="azurecli" source="~/../azure_cli_scripts/sql-database/setup-geodr-and-failover/setup-geodr-and-failover-database-failover-group.sh" id="FullScript":::

Clean up resources

[!INCLUDE cli-clean-up-resources.md]

az group delete --name $failoverResourceGroup -y
az group delete --name $resourceGroup

Sample reference

This script uses the following commands. Each command in the table links to command specific documentation.

Command Description
az sql failover-group create Creates a failover group.
az sql failover-group set-primary Set the primary of the failover group by failing over all databases from the current primary server
az sql failover-group show Gets a failover group
az sql failover-group delete Deletes a failover group

Next steps

For more information on Azure CLI, see Azure CLI documentation.

Additional SQL Database CLI script samples can be found in the Azure SQL Database documentation.