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.

During the restore operation, the database is restored to a staging path on the source client and then exported to a Azure BACPAC file. Therefore, the staging path must have at least twice the amount of space as the database size to accommodate the staged database and the exported Azure BACPAC file.

Procedure

  1. From the CommCell Browser, click Client Computers > client > SQL Server.

  2. Right-click the on-premise SQL instance from to which you want to restore the data, and then click All Tasks > Browse and Restore.

    The Browse and Restore Options dialog box appears.

  3. Click View Content.

  4. Select the data that you want to restore, and then click Recover All Selected.

    The SQL Restore Options dialog box appears.

  5. On the General tab, complete the following steps:

    1. From the Destination Server list,select the Azure instance to which you want to restore the data.

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

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

    4. In the Staging path on Source Client box, enter the location where you want to stage the Azure BACPAC file.

  6. On the Job Initiation tab, choose whether to run the restore job immediately or on a schedule.

  7. Optional: To further customize the restore operation, click Advanced.

    The Advanced Restore Options dialog box appears.

    1. To restore databases to a disk, on the Options tab, select the Restore to Disk check box.

    2. In the Path box, enter the location where you want to restore the SQL databases.

If you run the restore job immediately, you can monitor the progress of the restore job in the Job Controller window. For more information, see Job Controller.

After the restore job is complete, you can view the restore job history. For more information, see Job History.

Loading...