any posiblility to restore sql backup from more than 7 days?

ACConsultor 20 Reputation points
2024-07-02T08:11:50.0533333+00:00

I didn't set up backup and now I want to restore the database that is more than 2 weeks old. Do I have any chance to recover that database or did I lose the changes permanently?

Azure Backup
Azure Backup
An Azure backup service that provides built-in management at scale.
1,188 questions
Azure SQL Database
0 comments No comments
{count} votes

Accepted answer
  1. akinbade abiola 8,705 Reputation points
    2024-07-02T08:19:36.3933333+00:00

    Hello ACConsultor,

    Thanks for your question.

    Your options are a bit limited under the circumstances. Recovering a database from a backup older than 7 days in Azure SQL Database depends on the service tier you're using.

    Basic tier: 7 days. There's no way to recover data from backups older than that in the Basic tier.

    Standard tier: 35 days.

    Premium tier: 35 days.

    https://learn.microsoft.com/en-us/azure/azure-sql/database/service-tiers-sql-database-vcore?view=azuresql

    I would recommend you check your service tier. If your database is within the retention period, you can perform a point-in-time restore. If not, data is most likely lost.

    https://learn.microsoft.com/en-us/azure/azure-sql/database/recovery-using-backups?view=azuresql&tabs=azure-portal

    You can mark it 'Accept Answer' and 'Upvote' if this helped you

    Regards,

    Abiola

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful