After you back up your databases, you can restore the complete database to a consistent state. You can restore a database either from a recovery point or to a point-in-time.
Before you restore databases, ensure that you read the following considerations.
Consideration
You can select only one resource at a time for restoring.
Cross-deployment restores are not supported, meaning you can only restore within the same resource type. For example, a backup from a managed instance can only be restored to another managed instance.
Backward compatibility on SQL servers is not supported. For example, you cannot restore from a SQL server version 22 to version 19.
Ensure enough space is available on the target SQL resources for restoring.
If you cancel the restore job, make sure you clean the target database on Azure.
You can perform a point-in-time restore only if you have CDC backups scheduled for your database.
Recovery Point Restore
Procedure
On the Management Console, on the SQL Resources listing page, go to the SQL Backup Sets tab.
Select the backup set that you want to restore and click Restore.
Select the database for restore.
Select a recovery point and click Restore.
On the Restore Databases page, provide the following details depending on the deployment type and click Next:
Subscription: The subscription for which the backups need to be restored.
Region: Select the restore Region: You may choose to restore the SQL resource to the original region with pre-defined settings, or to an alternate region with custom restore settings.
Virtual Machine: If you’re restoring from a SQL server on a virtual machine, select the virtual machine for restoring the database.
SQL Server: If you’re restoring from a SQL server on a virtual machine or a SQL database instance, select the SQL server instance to which you want to restore the database.
Resource Group: The resource group of the selected virtual machine.
Managed Instance: If you’re restoring from a Managed instance, select the instance name for restoring.
(Optional) Restored Database Name: You can change the name of the restored database. By default, the restored database name will be in the format <original_database_>. For example, if you are restoring a database named sql_db_org, the default name of the restore database would be sql_db_org_.
Click Finish.
Next steps
You can check the restore job status on the All Jobs page.
Point-in-Time Restore (PITR)
You can restore Azure SQL databases to a specific point-in-time, provided CDC backups are scheduled. CDC backups serve as logs of changes made to your data and are essential for restoring data to a specific point-in-time. The restore process involves selecting a timestamp and configuring restore details, with the option to rename the restored database.
See the following procedure to perform a point-in-time restore.
Prerequisites
Make sure CDC backups are scheduled for your databases.
Procedure
On the Management Console, on the SQL Resources listing page, go to the SQL Backup Sets tab.
Select the backup set that you want to restore and click Restore.
Select the database for restore.
On the Restore Data page:
Select Restore Type as Point in Time Recovery.
Select the time range till which you want to restore and click Show Databases.
Note: The timezone corresponds to the timezone of the admin performing the restore.Select the database that you want to restore and click Restore.
Select a recovery point and click Restore.
On the Restore Databases page, provide the following details depending on the deployment type and click Next:
Subscription: The subscription for which the backups need to be restored.
Region: Select the restore Region: You may choose to restore the SQL resource to the original region with pre-defined settings, or to an alternate region with custom restore settings.
Virtual Machine: If you’re restoring from a SQL server on a virtual machine, select the virtual machine for restoring the database.
SQL Server: If you’re restoring from a SQL server on a virtual machine or a SQL database instance, select the SQL server instance to which you want to restore the database.
Resource Group: The resource group of the selected virtual machine.
Instance Name: If you’re restoring from a Managed instance, select the instance name for restoring.
(Optional): Restored Database Name: You can change the name of the restored database. By default, the restored database name will be in the format
<original_database_>. For example, if you are restoring a database namedsql_db_org, the default name of the restore database would besql_db_org_.Click Finish.
Next steps
You can check the restore job status on the All Jobs page.