After you back up your databases, you can restore the complete database to a consistent state from a recovery point.
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.
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): 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.