Skip to content

Latest commit

 

History

History
71 lines (46 loc) · 3.06 KB

backup-database-cli.md

File metadata and controls

71 lines (46 loc) · 3.06 KB
title description services ms.service ms.subservice ms.custom ms.devlang ms.topic author ms.author ms.reviewer ms.date
Azure CLI example: Backup a database in Azure SQL Database
Use this 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/23/2021

Use CLI to backup an Azure SQL single database to an Azure storage container

[!INCLUDEappliesto-sqldb]

This Azure CLI example backs up a database in SQL Database to an Azure storage container.

[!INCLUDE azure-cli-prepare-your-environment.md]

Sample script

Launch Azure Cloud Shell

The Azure Cloud Shell is a free interactive shell that you can use to run the steps in this article. It has common Azure tools preinstalled and configured to use with your account.

To open the Cloud Shell, just select Try it from the upper right corner of a code block. You can also launch Cloud Shell in a separate browser tab by going to https://shell.azure.com.

When Cloud Shell opens, verify that Bash is selected for your environment. Subsequent sessions will use Azure CLI in a Bash environment, Select Copy to copy the blocks of code, paste it into the Cloud Shell, and press Enter to run it.

Sign in to Azure

Cloud Shell is automatically authenticated under the initial account signed-in with. Use the following script to sign in using a different subscription, replacing <Subscription ID> with your Azure Subscription ID. [!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

Run the script

:::code language="azurecli" source="~/azure_cli_scripts/sql-database/backup-database/backup-database.sh" range="4-40":::

Clean up resources

Use the following command to remove the resource group and all resources associated with it using the az group delete command - unless you have an ongoing need for these resources. Some of these resources may take a while to create, as well as to delete.

az group delete --name $resourceGroup

Sample reference

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.

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.