Misdelete table in Azure Database

Andrew Haning 0 Reputation points
2024-12-17T10:27:01.3966667+00:00

Hello, I deleted a table in Azure SQL Database, how can I restore the deleted table?

Azure SQL Database
{count} votes

1 answer

Sort by: Most helpful
  1. Nandan Hegde 32,996 Reputation points MVP
    2024-12-17T10:46:43.4833333+00:00

    Once a table is deleted, you cannot directly restore it untill you have a backup process available.

    If you have a backup strategy enabled and the deletion reversal is within the retention period,you can restore your database to a point in time before the table was deleted.

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

    Then copy the data from that table in backup database within the existing database table


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.