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

Updated

On this page

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

The destination instance must be the same version or a later version of SQL than the source instance.

Note: When you restore an on-premises database to the Azure cloud, the restored database uses the standard tier model.

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 SQL managed 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.

    When you select the staging path, do one of the following so that the restore completes successfully:

    • Enter a location that is on the destination server.

    • Rename the database and the physical files.

      Note: The location must have enough space for the backup data and the Azure BACPAC file.

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

  8. Click Submit.