When you go to the Azure portal and access your Azure SQL server, you will see that there is a Manage Backups blade:
Figure 9.18 – Manage Backups blade
This feature allows you to configure how (and which) backups are made. Before we dig into this, I would like you to understand some Azure SQL backup rules and functionalities:
- Azure SQL backups are stored on RA-GRS storage accounts, which guarantee that, even in the case of catastrophic failure, you will be able to recover. This is the default built-in position of Azure SQL and works right after your Azure SQL server has been created.
- You do not pay for those built-in backups as they are automatic and included in the service's price.
- Those automatic backups are kept for between 7 and 35 days.
As shown in the following screenshot, the default value is 35 days:
Figure 9.19 – Backup configuration
The default backup is called a Point-in-Time backup and its default retention value is...
