December 2019
Intermediate to advanced
494 pages
11h 41m
English
To avoid any issues that may cause data loss, automatic backups are performed on SQL databases (these include full, differential, and transactional 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: 7 days for the Basic tier, 35 days for the Standard tier, 35 days for the Premium tier, and 35 days for the Premium RS tier. This solution would suit a scenario where 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, follow these steps: