Is there a way to recover a deleted database from Azure? I deleted my database two weeks ago and can't find it under "backup" or "Deleted databases". I want to recover the database instead of creating a new one.

Anonymous
2023-10-24T16:07:32.0466667+00:00

Is there a way to recover a deleted database from Azure? I deleted my database two weeks ago and can't find it under "backup" or "Deleted databases". I want to recover the database instead of creating a new one. I need to connect to the database to create a report.

Azure SQL Database
{count} votes

1 answer

Sort by: Most helpful
  1. RahulRandive 10,486 Reputation points Volunteer Moderator
    2023-10-24T16:15:14.99+00:00

    Hi @Anonymous

    If you have deleted your Azure SQL Database and can't find it under "backup" or "Deleted databases", you won't be able to restore it. However, if you had configured long-term retention (LTR) for the database, LTR backups are not deleted, and they can be used to restore databases on a different server or managed instance in the same subscription, to a point in time when an LTR backup was taken.

    It's important to note that the default backup retention period for Azure SQL Database is 7 days, and the retention policy defined in scheduled policy doesn't apply to on-demand backups.

    If you have not configured LTR for the database, and the deleted database is not available in the "Deleted databases" section, it won't be possible to recover the database.

    Let us know if you have any further questions.

    Thank you!

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.