#Restore Managed SQL Server Databases

To restore the managed SQL Server databases, follow the steps below:

1. Go to the Restore page and click the SQL Server tile.

2. In the Restore wizard, a calendar displays all the data recovery points for managed and self-managed SQL servers. Navigate to the Managed tab. You can choose to display jobs that finished with exceptions in the calendar by selecting the Include jobs with only partial backup data option.

3. Hover over the data recovery point to view the job details, including the job status, job start time, scope name, scope ID, job ID, backup size, and the number of objects in a backup.

4. Click the data recovery point that you want to use in the calendar. The databases backed up in the selected backup job are displayed in the table.

5. You can use the search box to search for the databases by name, use the server and instance filters and manage the columns to adjust the view of databases.

6. Select the databases that you want to restore, and then click the Restore button.

7. In the Restore options step, choose where would you like to restore the data, choose how you would like to restore the data, select a gateway from the drop-down list, and provide an optional description for further reference.

   • Where would you like to restore the data? - You can choose to restore the data to the original location or to a new location.

     • Restore the data to the original location - To restore the data to its original location, you must note that the database in the original location will be overwritten.

     • Restore the data to another location - Complete the following settings in the Destination step to configure destination location settings for the container being restored.

       • Tenant - Select a destination tenant for the database being restored. You can choose to restore this database to the same tenant when it is being backed up or select a new tenant.

       • Subscription - Select a destination subscription for the database being restored. You can choose to restore this database to the same subscription when it is being backed up or select a new subscription.

       • Resource group - Select a resource group for the destination container.

       • Database - Select a database for the destination container.

   • How would you like to restore the data - You can choose to replace the existing database or create a new database.

     • Overwrite – The databases in the original location will be overwritten.

     • Create a new database – This option will generate new databases in the original location. Click Next to proceed with configuring of the new database names. In the Database step, you can specify the desired name for each new database by entering it in the New database name column corresponding to each database in the original location.

       

8. Click Next.

9. Review the restore settings in the Overview step. You can click Back to go back to the previous steps in the restore wizard to modify the settings.

10. Click Restore to run the restore job.