add-database-to-failover-group-cli.md

title	Azure CLI example: Add a database to a failover group
description	Use this Azure CLI example script to create a database in Azure SQL Database, add it to an auto-failover group, and test failover.
author	AbdullahMSFT
ms.author	amamun
ms.reviewer	wiassaf, 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

Add a database to a failover group using the Azure CLI

[!INCLUDEappliesto-sqldb]

This Azure CLI script example creates a database in Azure SQL Database, creates a failover group, adds the database to it, 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-single-db-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 db	Database 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.