Restoring a SQL Managed Database

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

You can perform the following restores:

  • From one SQL managed instance to another

  • From SQL managed instance to disk

Note

  • To use data which was recovered using the Restore to Disk option, use Restore query.
  • To restore data to the same or a different managed instance, move BACPAC files to a storage account, and then use Restore from URL query.

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 Client list, select the Azure destination client to which you want to restore the data.

    2. From the Destination Server list, select the managed instance to which you want to restore the data.

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

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

    5. In the Staging path on Proxy Client box, enter the location where you want to stage the managed Azure backup file.

    6. In the box listing the database and its files, you can rename the database in the Database column, but you cannot change the filename in the Physical Path column.

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

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