Restoring a SQL Database from an Azure Cloud to an On-Premises SQL Server

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.


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

    The Overview page appears.

  2. On the Instances tab, iIn the row for the instance, click the action button 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. Select Out of place.

  5. From the Restore type list, select Cross instance restore.

  6. From the Destination server list, select the database server that has SQL server instance.

  7. From the Destination instance list, select the on-premise SQL server to which you want to restore the data.

  8. If you are restoring to an another Azure cloud instance, from the Access node list, select the access node.

  9. In the Staging path on destination server box, enter the location where you want to stage the Azure BACPAC file.

  10. 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.

  11. Click Submit.

Agents and Components Requiring Additional Disk Space