Azure SQL Database Restore from PITR but full backup expired

Nuria Arévalo Martínez-Raposo 0 Reputation points
2023-04-03T08:19:25.77+00:00

Hi there,

I have noticed that PITR backups in Azure SQL and Azure Managed Instance do not maintain the full backup necessary to restore the database. As a result, even though the retention period is set to 7 days, there are days when the full backup is not available, making it impossible to restore the database to certain points in time. For example, I have an Azure SQL Database where the full backup is taken every Friday. If I want to restore the database to a point in time from the previous Tuesday, I can't because only the log backups are available and not the full backup.

Do you have any plans to fix this issue in Azure?

Azure SQL Database
Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
998 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Rahul Randive 8,826 Reputation points Microsoft Employee
    2023-04-03T11:48:38.0166667+00:00

    Thanks for your question.

    Could you please provide a screenshot or error details to help us understand where your see "full backup has expired"

    All Basic, Standard, and Premium databases are protected by automatic backups. Full backups are taken every week, differential backups every day, and log backups every 5 minutes.

    As per blog https://azure.microsoft.com/en-us/blog/azure-sql-database-point-in-time-restore/

    For basic tier you can perform restore 'any restore point within 7 days' and for Standard & Premium, 'any restore point within 35 days'

    If you are seeing no restore point available, kindly refer below blog for more information.

    https://techcommunity.microsoft.com/t5/azure-database-support-blog/learning-from-expertise-10-why-no-restore-point-available/ba-p/3482699

    Thank you!