Restoring a SQL Database to a Different Managed Instance

You can perform the following restores for Azure SQL managed instance:

Note

To use data which was recovered using the Restore to Disk option, use Restore query.
To restore data to the same or a different managed instance, move BACPAC files to a storage account, and then use Restore from URL query.

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.
Select Out of place.
To restore SQL databases to an another Azure managed SQL instance, do the following:
1. From the Restore type list, select Cross instance restore.
2. From the Destination server list, select the database server that has SQL server instance.
3. From the Destination instance list, select the on-premise SQL server to which you want to restore the data.
4. From the Access node list, select the access node to use for restore.
5. In the Staging path on destination server box, enter the location where you want to stage the Azure BACPAC file.
6. 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.
7. Click Submit.
To restore SQL databases to disk, do the following:
1. From the Destination client list, select the physical machine where you want to restore.
2. In the Destination folder box, enter the folder location where the restore dump will be saved.
3. Click Submit.