| title | PowerShell: Restore an Automatic Backup of a Database | |
|---|---|---|
| description | Use an Azure PowerShell example script to restore a database in SQL Database to an earlier point in time from automatic backups. | |
| author | SudhirRaparla | |
| ms.author | nvraparl | |
| ms.reviewer | wiassaf, mathoma | |
| ms.date | 06/10/2025 | |
| ms.service | azure-sql-database | |
| ms.subservice | backup-restore | |
| ms.topic | sample | |
| ms.custom |
|
|
| ms.devlang | powershell |
[!INCLUDEappliesto-sqldb]
This PowerShell script example restores a database in SQL Database to a specific point in time.
[!INCLUDE quickstarts-free-trial-note] [!INCLUDE updated-for-az] [!INCLUDE cloud-shell-try-it.md]
If you choose to install and use PowerShell locally, this tutorial requires Az PowerShell 1.4.0 or later. If you need to upgrade, see Install Azure PowerShell module. If you are running PowerShell locally, you also need to run Connect-AzAccount to create a connection with Azure.
[!code-powershell-interactivemain]
Use the following command to remove the resource group and all resources associated with it.
Remove-AzResourceGroup -ResourceGroupName $resourcegroupnameThis script uses the following commands. Each command in the table links to command-specific documentation.
| Command | Notes |
|---|---|
| New-AzResourceGroup | Creates a resource group in which all resources are stored. |
| New-AzSqlServer | Creates a server that hosts databases and elastic pools. |
| New-AzSqlDatabase | Creates a database in a server. |
| Get-AzSqlDatabaseGeoBackup | Gets a geo-redundant backup of a standalone or pooled database. |
| Restore-AzSqlDatabase | Restores a database. |
| Remove-AzSqlDatabase | Removes a database. |
| Get-AzSqlDeletedDatabaseBackup | Gets a deleted database that you can restore. |
| Remove-AzResourceGroup | Deletes a resource group including all nested resources. |