| title | description | services | ms.service | ms.subservice | ms.custom | ms.devlang | ms.topic | author | ms.author | ms.reviewer | ms.date |
|---|---|---|---|---|---|---|---|---|---|---|---|
Azure CLI: Backup a database in Azure SQL Database |
Azure CLI example script to backup an Azure SQL single database to an Azure storage container |
sql-database |
sql-database |
backup-restore |
devx-track-azurecli |
azurecli |
sample |
SQLSourabh |
sourabha |
mathoma |
12/06/2021 |
This Azure CLI example backs up a database in SQL Database to an Azure storage container.
If you choose to install and use the CLI locally, this article requires that you are running the Azure CLI version 2.0 or later. Run az --version to find the version. If you need to install or upgrade, see Install the Azure CLI.
Cloud Shell is automatically authenticated under the initial account signed-in with. Use the following script to sign in using a different subscription. Sign in to Azure using the appropriate subscription. [!INCLUDE quickstarts-free-trial-note]
subscription="<subscriptionId>" # add subscription here
az account set -s $subscription # ...or use 'az login'
For more information, see set active subscription or log in interactively
:::code language="azurecli" source="~/azure_cli_scripts/sql-database/backup-database/backup-database.sh" range="4-40":::
Use the following command to remove the resource group and all resources associated with it.
az group delete --name $resource
This script uses the following commands. Each command in the table links to command specific documentation.
| Command | Notes |
|---|---|
| az sql server | Server commands. |
| az sql db | Database commands. |
For more information on the Azure CLI, see Azure CLI documentation.
Additional SQL Database CLI script samples can be found in the Azure SQL Database documentation.