#Restore Backup Databases

To restore the databases, follow the steps below:

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

2. In the Restore wizard, a calendar displays all the data recovery points. Click Azure SQL backup.

3. You can choose whether to display the finished with the exception jobs in the calendar by selecting the Include jobs with only partial backup data option.

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

5. Click a data recovery point in the calendar. The Azure SQL databases backed up in the selected backup job are displayed in the table.

6. You can use the Subscription filter and Resource group filter to find the databases or use the Search box to search for databases via keywords in the name. You can also manage the columns to adjust the view of databases.

7. Select the database that you want to restore and click Restore.

8. In the Restore options step, select how to restore the database. You can choose to replace the existing database or create a new database. If you choose to create a new database, you need to provide a new database name in the Destination step.

9. You can enter a description for this restore job for further reference. Click Next.

10. If you choose to create a new database, enter a new database name in the Destination step. Otherwise, you will go to the Overview step.

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

12. Click Restore to run the restore job.