# Restoring a SQL Database to an 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

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

   The Overview page appears.

2. On the Instances tab, in 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. To restore SQL databases to the same Azure cloud instance, do the following:

   1. Select In place.

   2. Click Submit.

5. To restore SQL databases to another Azure cloud instance, do the following:

   1. Select Out of place.

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

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

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

   5. From the Access node list, select the access node.

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

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

   8. If you want to rename the database, in the Data Files section, type the new name for the database.

      If you change the name of the database to a name of a database that already exists on the destination instance, the database will be overwritten.

   9. To specify the database pricing tier, in the Advanced Options section, select the Database Tier for the database.

      If you don't select a database pricing tier, the default Pricing Tier Standard S0 will be applied by default.

   10. Click Submit.

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

7. Click SUBMIT.

×

Loading...