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
Procedure
-
From the navigation pane, go to Protect > Databases.
The Instances page appears.
-
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.
-
From the Destination server list, select the instance to restore the data to.
-
From the Proxy client list, select the access node to use for the restore.
-
In the Staging path on proxy client box, enter the location to stage the Azure BACPAC file in.
-
To drop all existing connections to the database before the restore, select the Drop connections to database check box.
-
Click Submit.