Restoring a SQL Database to a Different Azure Cloud

Updated

On this page

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

  1. From the navigation pane, go to Protect > Databases.

    The Instances page appears.

  2. In the row for the instance, click the action button , and then click Restore.

    The Backup content dialog box appears.

  3. Select the content to restore, and then click Restore.

    The Restore options dialog box appears.

  4. From the Destination server list, select the Azure cloud instance to restore the data to.

  5. From the Proxy client list, select the access node to use for the restore.

  6. In the Staging path on proxy client box, enter the location to stage the Azure BACPAC file in.

  7. To drop all existing connections to the database before the restore, select the Drop connections to database check box.

  8. Click Submit.