Restoring a SQL Database 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 or an another Azure cloud instance.

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

Procedure

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

   The Overview page appears.

2. On the Instances tab, iIn the row for the instance, click the action button , and then click Restore.

   The Backup content dialog box appears.

3. Select the content to restore, and then click Restore.

   The Restore options dialog box appears.

4. Select Out of place.

5. From the Restore type list, select Cross instance restore.

6. From the Destination server list, select the database server that has SQL server instance.

7. From the Destination instance list, select the on-premise SQL server to which you want to restore the data.

8. If you are restoring to an another Azure cloud instance, from the Access node list, select the access node.

9. In the Staging path on destination server box, enter the location where you want to stage the Azure BACPAC file.

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

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

12. Click Submit.

Related Topics

Agents and Components Requiring Additional Disk Space