Restore an Azure SQL database to a previous point in time with the Azure portal
This article shows you how to restore your database to an earlier point in time from SQL Database automated backups using the Azure portal.
Restore a SQL database to a previous point in time
Select a database to restore in the Azure portal:
- Open the Azure portal.
- On the left side of the screen, select More services > SQL databases.
- Click the database you want to restore.
At the top of your database's page, select Restore:
On the Restore page, select the date and time (in UTC time) to restore the database to, and then click OK:
Monitor the restore operation
After clicking OK in the previous step, click the notification icon at the upper right of the page, and click the Restoring SQL database notification for details.
The Restoring SQL database page opens with information about the status of the restore. You can click the line-item for more details: