To avoid any issues that might cause data loss, automatic backups are performed on SQL databases (these include full, differential, and transaction log backups).

Azure SQL Database can be recovered to any point in time, within the automatic backup retention period.

The retention period varies from one tier to another: seven days for the Basic tier, 35 days for the Standard tier, and 35 days for the Premium tier. This solution would suit a scenario in which your database has been corrupted and you want to restore it to the last healthy point.

To restore your database to the last healthy point, you have to follow these steps:

1. Navigate to the database that you want to restore to the last healthy point, and click on Restore, as shown in the following screenshot:

2. Once you have clicked on Restore, a new blade will pop up, where you can provide the restored database with a new database name, determine the time that you want to restore to, and change the pricing tier for the restored database, as shown in the following screenshot:

3. When you click on OK, the database will start to be restored.