You can restore SQL databases from an Azure cloud to an on-premises SQL server or an another Azure cloud instance.
The destination instance must be the same version as 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, iIn 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.
-
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.
-
If you are restoring to an another Azure cloud instance, from the Access node list, select the access node.
-
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.