Restoring a SQL Database to an Azure Cloud

You can restore SQL databases from an Azure cloud to either the same Azure cloud instance or to another Azure cloud instance.

The destination instance must be the same version or a later version of SQL than the source instance.

Procedure

From the navigation pane, go to Protect > Databases.

The Overview page appears.
On the Instances tab, in the row for the instance, click the action button , and then click Restore.

The Backup content dialog box appears.
Select the content to restore, and then click Restore.

The Restore options dialog box appears.
To restore SQL databases to the same Azure cloud instance, do the following:
1. Select In place.
2. Click Submit.
To restore SQL databases to another Azure cloud instance, do the following:
1. Select Out of place.
2. From the Restore type list, select Cross instance restore.
3. From the Destination server list, select the database server that has the SQL server instance.
4. From the Destination instance list, select the on-premise SQL server to which you want to restore the data.
5. From the Access node list, select the access node.
6. In the Staging path on destination server box, enter the location where you want to stage the Azure BACPAC file.
7. Enter additional details so that the restore operation completes successfully:
  - Enter a location that is on the destination server.
  - Rename the database and the physical files.
  Verify that you have sufficient space in the staging path for the restore operation.
8. If you want to rename the database, in the Data Files section, type the new name for the database.
  
  If you change the name of the database to a name of a database that already exists on the destination instance, the database will be overwritten.
9. To specify the database pricing tier, in the Advanced Options section, select the Database Tier for the database.
  
  If you don't select a database pricing tier, the default Pricing Tier Standard S0 will be applied by default.
10. Click Submit.