setup-geodr-failover-database-cli.md

title	description	author	ms.author	ms.reviewer	ms.date	ms.service	ms.subservice	ms.topic	ms.devlang	ms.custom
Azure CLI example: Active geo-replication-single Azure SQL Database	Use this Azure CLI example script to set up active geo-replication for a single database 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 active geo-replication for a single database in Azure SQL Database using the Azure CLI

[!INCLUDEappliesto-sqldb]

This Azure CLI script example configures active geo-replication for a single database and fails it over to a secondary replica of the database.

[!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-single-database.sh" id="FullScript":::

Clean up resources

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

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 db replica	Database replica commands.

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.