Backups that Azure SQL takes on its own, allowing point-in-time restore over a window of 1 to 35 days. Keeping backups longer requires long-term retention (LTR).
Also called Azure SQL.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains Automatic backups in context, with comparison tables and the common traps.
Terms in this definition
- Auditing
Azure SQL capability that sends database audit logs to Log Analytics, Event Hubs or a storage account; that account is allowed to be in a different region.
- Point-in-time restore
Lets you wind block blobs in a general-purpose v2 account back to how they were at an earlier moment. Before it works, soft delete, blob versioning and the change feed all have to be on.
- OVER
Gives a T-SQL window function its window: PARTITION BY, ORDER BY and, if wanted, a ROWS or RANGE frame. Rankings and running totals can then be worked out while every row is kept.
- WINDOW
Returns rows from a sorted, optionally partitioned table, either at fixed positions (ABS) or relative to the current row (REL). Running totals plus moving averages are common uses.
- Long-term retention
Azure SQL feature for holding on to full backups well beyond the normal window: weekly, monthly or yearly copies can be retained for a decade.