> Expert > Backup and Restore Agents > Databases > Microsoft SQL Server > Solutions > Back Up and Restore Azure SQL Databases

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

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

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

Procedure

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

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

  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 on-premise SQL server 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.

      To ensure that the restore operation completes successfully, you must do one of the following:

      • Enter a location that is on the destination server.

      • Rename the database and the physical files.

  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.

    Goal

    Action on the Options tab

    Restore databases to a disk.

    Select Restore to Disk.

    Restore a database after dropping all existing connections to the database.

    Select Drop Connections to Database.

    Restores the most recent backup data to one or more non system-secured databases on the SQL server.

    Select Latest Backup Data.

  8. Click OK.

If you run the restore job immediately, you can monitor the progress of your 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...