This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(80, 39%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
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 ?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(99.2, 65%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECB%3C/text%3E%3C/svg%3E)
Just checking in to see if the below suggestion provided by @ Nandan Hegde helped.
If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
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:
Just checking in to see if the above suggestion provided by @ Nandan Hegde helped.
If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.