Restoring a SQL Database to a Different Managed Instance

You can perform the following restores for Azure SQL managed instance:

From one Azure SQL managed instance to another
From an Azure 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

From the Command Center navigation pane, go to Protect > Databases.

The Overview page appears.
On the Instances tab, in the row for the instance, click the action button , and then click Restore.

The Backup content dialog box appears.
Select the content to restore, and then click Restore.

The Restore options dialog box appears.
Select Out of place.
To restore SQL databases to an another Azure managed SQL instance, do the following:
1. From the Restore type list, select Cross instance restore.
2. From the Destination server list, select the database server that has SQL server instance.
3. From the Destination instance list, select the on-premise SQL server to which you want to restore the data.
4. From the Access node list, select the access node to use for restore.
5. In the Staging path on destination server box, enter the location where you want to stage the Azure BACPAC file.
6. Enter additional details so that the restore operation completes successfully:
  - Enter a location that is on the destination server.
  - Rename the database and the physical files.
  Verify that you have sufficient space in the staging path for the restore operation.
7. Click Submit.
To restore SQL databases to disk, do the following:
1. From the Destination client list, select the physical machine where you want to restore.
2. In the Destination folder box, enter the folder location where the restore dump will be saved.
3. Click Submit.
You can configure a schedule to repeat this restore operation. To create a schedule, do the following:
1. Click Schedule.
  
  The Add schedule dialog box appears.
2. In the Name box, type a name for the schedule.
3. Configure the Frequency and Repeat parameters.
4. To specify exceptions to the schedule, click Exceptions.
  
  The Exceptions dialog box appears.
5. Configure the exception parameters:
  - You can click Add Exception to save a set of exception parameters and continue adding sets of exception parameters.
  - Click Save when you have finished configuring the exception parameters.
6. Under the Range of recurrence section, specify the Start date and End date to schedule the recurrence range of the restore operation.
7. To save the schedule and return to the restore dialog box, click Schedule.
Click SUBMIT.

Restoring a SQL Database to a Different Managed Instance

Procedure

Page contents