![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 26%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
Azure SQL Database
An Azure relational database service.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(262.40000000000003, 18%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVP%3C/text%3E%3C/svg%3E)
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(291.2, 38%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMP%3C/text%3E%3C/svg%3E)
Refer to https://free.blessedness.top/en-us/azure/azure-sql/database/automated-backups-overview?view=azuresql
Azure SQL Database creates:
- Full backups every week.
- Differential backups every 12 or 24 hours.
- Transaction log backups approximately every 10 minutes.
The exact frequency of transaction log backups is based on the compute size and the amount of database activity. When you restore a database, the service determines which full, differential, and transaction log backups need to be restored.
The Hyperscale architecture doesn't require full, differential, or log backups. To learn more, see Hyperscale backups.
| Backup property | PITR | Geo-restore | LTR |
|---|---|---|---|
| Types of SQL backup | Full, differential, log. | Most recent geo-replicated copies of PITR backups. | Only the full backups. |
| Types of SQL backup | Full, differential, log. | Most recent geo-replicated copies of PITR backups. | Only the full backups. |
| Retention | 7 days by default, configurable between 1 and 35 days (except Basic databases, which are configurable between 1 and 7 days). | Enabled by default, same as source.2 | Not enabled by default. Retention is up to 10 years. |
| Azure Storage | Geo-redundant by default. You can optionally configure zone-redundant or locally redundant storage. | Available when PITR backup storage redundancy is set to geo-redundant. Not available when PITR backup storage is zone-redundant or locally redundant. | Geo-redundant by default. You can configure zone-redundant or locally redundant storage. |
| Configure backups as immutable | Not supported | Not supported | Supported (in Preview) |
| Restoring a new database in the same region | Supported | Supported | Supported |
| Restoring a new database in another region | Not supported | Supported in any Azure region | Supported in any Azure region |
| Restoring a new database in another subscription | Not supported | Not supported3 | Not supported3 |
| Restoring via Azure portal | Yes | Yes | Yes |
| Restoring via PowerShell | Yes | Yes | Yes |
| Restoring via Azure CLI | Yes | Yes | Yes |
If the above response helps answer your question, remember to "Accept Answer" so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.
hth
Marcin