How to restore a synapse SQL pool datawarehouse database

Question

Hi All.

Working on recovering a deleted synapse analytics workspace which also has a SQL pool, is there a way to recover if its deleted ?

At the time, the deletion encountered an error and therefore was not fully deleted. but i was unable to recovery the database.

Running the command

Get-AzSynapseSqlPoolGeoBackup 

I was getting the error

Get-AzSynapseSqlPoolGeoBackup: Failed to perform 'read' on resource(s) of type 'servers/recoverableDatabases', because the parent resource '/subscriptions/xxx/resourceGroups/rg-inf-synapse-001/providers/Microsoft.Sql/servers/synapse-workspace' could not be found.

In my case I never entered the resource group rg-inf-synapse-001, but it kept defaulting to this and throwing up the error above, its not going to find it because we dont have a resource group with the name rg-inf-synapse-001

I have managed to fully delete the workspace, create a new workspace with thesame name under thesame resource group, I want to know if its possible to recover the SQL pool DB ?

Answer 1

Based on my understanding, you would need to work with MSFT support team for the same as you deleted the server.

In case if you would have just deleted the pool, you could have recovered it via below aspect:

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

https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-restore-from-deleted-server