Loading...

Restoring SQL Databases from an On-Premises SQL Server to an Azure Cloud

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, click Solutions > Apps > Cloud Apps. Then, in the Restore column for the Azure app, click Restore.

    The Backup content dialog box appears.

  2. Optional: Select a backup. From the Showing latest backup list, select one of the following options:
    • To show the latest backup, select Show Latest Backup.
    • To show a backup at a specific time, select Show backup as a of a specific date, and then type the date and time.
    • To show backups for a date range, select Show backup for a date range, and then specify the dates.
  3. Select the data that you want to restore, and then click Restore.

    The Restore options dialog box appears.

  4. From the Destination server list, select the Azure instance 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.
  7. To overwrite the files of any other database that is currently using the database that you specify, select the Unconditionally overwrite existing databases or files check box.
  8. To restore a database after dropping all existing connections to the database, select the Drop connections to database check box.
  9. Click Submit.

Last modified: 8/14/2018 2:27:57 PM