Share via

Synapse dedicated SQLPool Backup cannot be restored

Josef Prakljacic 101 Reputation points
2021-11-26T15:30:10.273+00:00

We are trying to restore a deleted SQL dedicated pool.

By using the statement Get-AzSqlDeletedDatabaseBackup. We can see the database that we are trying to restore.

Then we are using the Statement Restore-AzSqlDatabse to restore it. But we get the error that we have the permission to 'Microsoft.Sql/servers/databases/write', however do not have the permission to perform action "read" on the "0" lined scope "". It is blocked by deny assignements.

What the error is telling us - we could restore to the targetserver but we are not allowed to read from the autogenerated SynapseWorkspace Resource Group since Microsoft placed a denyassignment on this.

PLEASE Do net provide me the article you can find below since we are excatly doing this stuff and are having the issues because Synapse Workspace unfortunatley runs diffrently then the former dedicated pools.

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

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,373 questions
Accepted answer
  1. Josef Prakljacic 101 Reputation points
    2021-12-12T09:46:48.877+00:00
    1 person found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

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.