Skip to content

Latest commit

 

History

History
56 lines (38 loc) · 1.88 KB

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

File metadata and controls

56 lines (38 loc) · 1.88 KB
Raw
title description author ms.author ms.reviewer ms.date ms.service ms.subservice ms.topic ms.custom ms.devlang
Azure CLI example: Add a database to a failover group
Use this Azure CLI example script to create a database in Azure SQL Database, add it to a failover group, and test failover.
rajeshsetlem
rsetlem
wiassaf, mathoma
01/26/2022
sql-database
high-availability
sample
sqldbrb=1
devx-track-azurecli
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.