| title | Azure CLI example: Restore a backup |
|---|---|
| description | Use this Azure CLI example script to restore a database in Azure SQL Database to an earlier point in time from automatic backups. |
| author | SudhirRaparla |
| ms.author | nvraparl |
| ms.reviewer | wiassaf, mathoma |
| ms.date | 02/11/2022 |
| ms.service | sql-database |
| ms.subservice | backup-restore |
| ms.topic | sample |
| ms.custom | devx-track-azurecli |
| ms.devlang | azurecli |
[!INCLUDEappliesto-sqldb]
This Azure CLI example restores a single database in Azure SQL Database to a specific point in time.
[!INCLUDE quickstarts-free-trial-note]
[!INCLUDE azure-cli-prepare-your-environment.md]
[!INCLUDE cli-run-local-sign-in.md]
:::code language="azurecli" source="~/../azure_cli_scripts/sql-database/restore-database/restore-database.sh" id="FullScript":::
[!INCLUDE cli-clean-up-resources.md]
az group delete --name $resourceGroup
This script uses the following commands. Each command in the table links to command specific documentation.
| Command | Description |
|---|---|
| az sql db restore | Restore database command. |
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.