add-elastic-pool-to-failover-group-cli.md

title	description	author	ms.author	ms.reviewer	ms.date	ms.service	ms.subservice	ms.topic	ms.devlang	ms.custom
Azure CLI example: Failover group - Azure SQL Database elastic pool	Use this Azure CLI example script to create an Azure SQL Database elastic pool, add it to a failover group, and test failover.	WilliamDAssafMSFT	wiassaf	mathoma	01/26/2022	sql-database	high-availability	sample	azurecli	devx-track-azurecli

Add an Azure SQL Database elastic pool to a failover group using the Azure CLI

[!INCLUDEappliesto-sqldb]

This Azure CLI script example creates a single database, adds it to an elastic pool, creates a failover group, and tests failover.

[!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/failover-groups/add-elastic-pool-to-failover-group-az-cli.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 elastic-pool	Elastic pool commands.
az sql failover-group	Failover group 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.