Skip to content

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

Latest commit

 

History

History
55 lines (38 loc) · 1.8 KB

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

File metadata and controls

55 lines (38 loc) · 1.8 KB
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 a failover group, and test failover.
author rajeshsetlem
ms.author rsetlem
ms.reviewer wiassaf, mathoma
ms.date 06/10/2025
ms.service azure-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.

Related content