Skip to content

setup-geodr-failover-pool-cli.md

Latest commit

 

History

History
57 lines (39 loc) · 2.01 KB

setup-geodr-failover-pool-cli.md

File metadata and controls

57 lines (39 loc) · 2.01 KB
title Azure CLI example: Configure active geo-replication for an elastic pool
description Use this Azure CLI example script to set up active geo-replication for a pooled database in Azure SQL Database and fail it over.
author WilliamDAssafMSFT
ms.author wiassaf
ms.reviewer mathoma
ms.date 01/26/2022
ms.service sql-database
ms.subservice high-availability
ms.topic sample
ms.custom
sqldbrb=1
devx-track-azurecli
ms.devlang azurecli

Configure active geo-replication for a pooled database in Azure SQL Database using the Azure CLI

[!INCLUDEappliesto-sqldb]

This Azure CLI script example configures active geo-replication for a pooled database in Azure SQL Database and fails it over to the 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-elastic-pool.sh" id="FullScript":::

Clean up resources

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

az group delete --name $resourceGroup
az group delete --name $secondaryResourceGroup

Sample reference

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

Command Description
az sql elastic-pool Elastic pool commands
az sql db replica Database replication 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.