Restoring SQL Databases from an Azure Cloud to Another Azure Cloud

You can restore SQL databases from an Azure cloud to either the same Azure cloud instance or to another Azure cloud instance.

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

Procedure

From the CommCell Browser, click Client Computers > client > SQL Server.
Right-click the Azure SQL instance that you want to restore, and then click All Tasks > Browse and Restore.

The Browse and Restore Options dialog box appears.
Click View Content.
Select the data that you want to restore, and then click Recover All Selected.

The SQL Restore Options dialog box appears.
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.
  
  The destination instance can be the same Azure cloud instance or another Azure cloud instance.
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.
On the Job Initiation tab, choose whether to run the restore job immediately or on a schedule.
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 database files.

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.