How to recover deleted synapse workspace and its dedicated sql pool?

Question

How to recover deleted synapse workspace and its dedicated sql pool?

Ahadjon Ismatov 0

Dear Support Team,
I have deleted Azure Synapse Workspace. And it deleted the dedicated SQL pool too. How can I recover the workspace and dedicated sql pool?

Best,

J N S S Kasyap 1,520 Reputation points Microsoft External Staff

2025-04-02T02:27:44.63+00:00

Hi @Ahadjon Ismatov

Once an Azure Synapse Workspace is deleted, it cannot be restored. Azure does not provide a soft-delete or recovery mechanism for Synapse Workspaces. When you delete a workspace, all associated resources, including dedicated SQL pools, Spark pools, linked services, and pipelines, are permanently deleted.
When a dedicated SQL pool is dropped, a final snapshot is created and retained for seven days, allowing restoration to that point.

To restore a dedicated SQL pool in Azure Synapse Analytics after an accidental drop of a workspace using PowerShell.
https://learn.microsoft.com/en-us/azure/synapse-analytics/backuprestore/restore-sql-pool-from-deleted-workspace
https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/backup-and-restore

I hope this information helps. Please do let us know if you have any further queries.

Kindly consider upvoting the comment if the information provided is helpful. This can assist other community members in resolving similar issues.

Thank you.
J N S S Kasyap 1,520 Reputation points Microsoft External Staff

2025-04-02T11:28:07.6333333+00:00

@Ahadjon Ismatov
Could you please review the private message and provide the necessary details? This will help me reach out internally to restore the dedicated SQL pool.
J N S S Kasyap 1,520 Reputation points Microsoft External Staff

2025-04-03T00:12:05.1266667+00:00

@Ahadjon Ismatov
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Ahadjon Ismatov 0 Reputation points

2025-04-03T11:47:23.91+00:00

Hi Kasyap,

Thank you for your reply.
I have sent the details over private message.
Although whole workspace with dedicated sql pool was deleted, it is fine if we can only the dedicated sql pool.

Best,
J N S S Kasyap 1,520 Reputation points Microsoft External Staff

2025-04-04T03:39:31.59+00:00

@Ahadjon Ismatov
Please check the private message and provide the necessary details?
AnnuKumari-MSFT 34,451 Reputation points Microsoft Employee

2025-04-07T06:54:29.1533333+00:00

@Ahadjon Ismatov ,

Did you had integrated the workspace with source control , any GIT repo ?
J N S S Kasyap 1,520 Reputation points Microsoft External Staff

2025-04-07T19:20:44.25+00:00

@Ahadjon Ismatov
Please help us on the above ask from Annu

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
J N S S Kasyap 1,520 Reputation points Microsoft External Staff

2025-04-09T00:12:54.9+00:00

@Ahadjon Ismatov

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Ahadjon Ismatov 0 Reputation points

2025-04-11T02:57:16.0266667+00:00

Hi Kaysyap,

Thank you for your message.

I don't have a resolution yet. To you question regarding GIT, yes I was using Azure DevOps Git repository to collaborate with Synapse workspace pipelines.

But I am more interested in recovering my dedicated sql pool data.

Best,

Ahadjon
J N S S Kasyap 1,520 Reputation points Microsoft External Staff

2025-04-11T05:21:40.01+00:00

@Ahadjon Ismatov
Did you try the steps mentioned in the below Documentation which we have mentioned in the first comment and Nandan Hegde shared as well. Please do let us know if you have any further queries.
Restore a dedicated SQL pool from a dropped workspace - Azure Synapse Analytics | Microsoft Learn
J N S S Kasyap 1,520 Reputation points Microsoft External Staff

2025-04-14T03:18:00.36+00:00

@Ahadjon Ismatov
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. Otherwise, will respond with more details and we will try to help.

1 answer

Your answer

J N S S Kasyap 1,520 Reputation points Microsoft External Staff

2025-04-02T02:27:44.63+00:00

Hi @Ahadjon Ismatov

Once an Azure Synapse Workspace is deleted, it cannot be restored. Azure does not provide a soft-delete or recovery mechanism for Synapse Workspaces. When you delete a workspace, all associated resources, including dedicated SQL pools, Spark pools, linked services, and pipelines, are permanently deleted.
When a dedicated SQL pool is dropped, a final snapshot is created and retained for seven days, allowing restoration to that point.

To restore a dedicated SQL pool in Azure Synapse Analytics after an accidental drop of a workspace using PowerShell.
https://learn.microsoft.com/en-us/azure/synapse-analytics/backuprestore/restore-sql-pool-from-deleted-workspace
https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/backup-and-restore

I hope this information helps. Please do let us know if you have any further queries.

Kindly consider upvoting the comment if the information provided is helpful. This can assist other community members in resolving similar issues.

Thank you.
J N S S Kasyap 1,520 Reputation points Microsoft External Staff

2025-04-02T11:28:07.6333333+00:00

@Ahadjon Ismatov
Could you please review the private message and provide the necessary details? This will help me reach out internally to restore the dedicated SQL pool.
J N S S Kasyap 1,520 Reputation points Microsoft External Staff

2025-04-03T00:12:05.1266667+00:00

@Ahadjon Ismatov
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Ahadjon Ismatov 0 Reputation points

2025-04-03T11:47:23.91+00:00

Hi Kasyap,

Thank you for your reply.
I have sent the details over private message.
Although whole workspace with dedicated sql pool was deleted, it is fine if we can only the dedicated sql pool.

Best,
J N S S Kasyap 1,520 Reputation points Microsoft External Staff

2025-04-04T03:39:31.59+00:00

@Ahadjon Ismatov
Please check the private message and provide the necessary details?
AnnuKumari-MSFT 34,451 Reputation points Microsoft Employee

2025-04-07T06:54:29.1533333+00:00

@Ahadjon Ismatov ,

Did you had integrated the workspace with source control , any GIT repo ?
J N S S Kasyap 1,520 Reputation points Microsoft External Staff

2025-04-07T19:20:44.25+00:00

@Ahadjon Ismatov
Please help us on the above ask from Annu

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
J N S S Kasyap 1,520 Reputation points Microsoft External Staff

2025-04-09T00:12:54.9+00:00

@Ahadjon Ismatov

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Ahadjon Ismatov 0 Reputation points

2025-04-11T02:57:16.0266667+00:00

Hi Kaysyap,

Thank you for your message.

I don't have a resolution yet. To you question regarding GIT, yes I was using Azure DevOps Git repository to collaborate with Synapse workspace pipelines.

But I am more interested in recovering my dedicated sql pool data.

Best,

Ahadjon
J N S S Kasyap 1,520 Reputation points Microsoft External Staff

2025-04-11T05:21:40.01+00:00

@Ahadjon Ismatov
Did you try the steps mentioned in the below Documentation which we have mentioned in the first comment and Nandan Hegde shared as well. Please do let us know if you have any further queries.
Restore a dedicated SQL pool from a dropped workspace - Azure Synapse Analytics | Microsoft Learn
J N S S Kasyap 1,520 Reputation points Microsoft External Staff

2025-04-14T03:18:00.36+00:00

@Ahadjon Ismatov
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. Otherwise, will respond with more details and we will try to help.

Answer 1

Nandan Hegde 34,856 MVP

Hey, In case if the workspace is deleted; there is no way from the user end to recover it back.

So the only way/option would be to work with MSFT team by raising a support request for them to try it out.

As most of the objects can be Git/Devops controlled, you can create a new workspace and deploy the changes back. but to recover the deleted the dedicated pool, plz follow the below blog :

https://learn.microsoft.com/en-us/azure/synapse-analytics/backuprestore/restore-sql-pool-from-deleted-workspace

Share via

How to recover deleted synapse workspace and its dedicated sql pool?

1 answer

Your answer