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

Updated

On this page

You can restore SQL databases from an Azure cloud to an on-premises SQL server.

The destination instance must be the same version as 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 on-premise SQL server to which you want to restore the data.

    The destination instance can be the same Azure cloud instance or another Azure cloud instance.

  5. From the Proxy client list, select the proxy server that you want to use for the restore.

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

    Perform one of the following operations 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. For more information on the additional disk space requirement, see Agents and Components Requiring Additional Disk Space.

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

  8. Click Submit.