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