0

I have so much confusion how Azure SQL database backups PITR & LTR Works. I have observed few things from the backup as follows;

  1. PITR - Earliest Point in Time Retention happening every day. for example:
  2. PITR configured for 7 Days

example 1:

2025-4-28 - current Day,
2025-4-27,
2025-4-26,
2025-4-25,
2025-4-24,
2025-4-23,
2025-4-22,
2025-4-21 - Earliest PITR restore point

example 2:

2025-4-29 - current Day,
2025-4-28,
2025-4-27,
2025-4-26,
2025-4-25,
2025-4-24,
2025-4-23,
2025-4-22 - Earliest PITR restore point

so, are we able to restore 2025-4-20 also? or only able to restore from (Earliest PITR restore point) 2025-4-21 to current day (2025-4-28)?

Please someone explain me how this actually works.

And LTR?

Improve this question
1
  • I have configured PITR: 7 days. my earliest PITR is (2025-4-21) up to today, 7 days cycle completed. Again PITR move forward one day (2025-4-22) now I will lose restore point (2025-4-21) right? Commented Apr 28 at 3:13

1 Answer 1

Reset to default
0

Azure SQL Database Backups PITR & LTR

PITR: You can restore an Azure SQL Database to any earlier point within its retention period. The restored database can have a different service tier or compute size and must fit within the elastic pool if used. Restoration creates a new database on the same server.

Refer the below document: https://learn.microsoft.com/en-us/azure/azure-sql/database/recovery-using-backups?view=azuresql&tabs=azure-portal#point-in-time-restore

LTR: Azure SQL's Long-Term Retention (LTR) lets you store full database backups in redundant Azure Blob storage for up to 10 years, beyond the default 1–35 days of short-term retention. LTR copies are created automatically in the background without impacting performance, and you can restore these backups as new databases when needed.

Refer the below document: https://learn.microsoft.com/en-us/azure/azure-sql/database/long-term-retention-overview?view=azuresql#how-long-term-retention-works

Improve this answer