#Restore Monitored 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 monitoring points. Click Native Azure SQL backup monitoring.

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 monitoring 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 monitoring point in the calendar to view the recovery points (PTR and LTR) retrieved for the protected databases.

6. By default, all the native Azure backups for PITR are displayed in the table. The Earliest recovery point column displays the earliest available backup, which indicates the retention period that you configured for the PITR backups. You can click the Point-in-time restore list to change the backups to Long-term retention (LTR) and use the Subscription filter and Resource group filter to find the databases that you want to restore. You can also manage the columns to adjust the view of databases.

7. Select a PITR/LTR recovery point that you want to restore.

8. Click the Restore button.

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

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

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

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

13. Click Restore to run the restore job.