Share via

Backup difference comparison

Priya Jha 896 Reputation points
2022-10-07T14:54:21.767+00:00

Hi All,

I have a below scenario wherein i accidently dropped 5 tables from my Azure SQL DB and Azure SQL Data warehouse.

I do have LTR backup for Azure SQL DB and restore point for SQL Data warehouse. Is it possible to restore just the dropped tables from the backup into my live DB/warehouse.

Azure SQL Database
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,380 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Bjoern Peters 8,921 Reputation points
    2022-10-07T15:08:22.6+00:00

    No, sorry, that is not possible.
    You have to restore the full database and then copy those tables from copy to prod.

    https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/backup-and-restore

    1 person found this answer helpful.
    0 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.