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