Sample Header Ad - 728x90

Azure SQL Database Backups PITR & LTR

0 votes
1 answer
76 views
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?
Asked by Abdul Khadar
Apr 28, 2025, 01:49 AM
Last activity: May 14, 2025, 09:47 PM