Azure Synapse Serverless SQL backup/recovery

Darren-1990 21 Reputation points
2022-07-29T12:06:48.387+00:00

We use Azure Synapse Workspaces, with Serverless SQL pools. How would one implement a disaster recovery solution to support this (across Azure regions, with geo-replicated StorageV2 (general purpose v2) datalake storage accounts.)?

The automated backup/restore points only appear to be supported when using Dedicated SQL pools in Synapse.

Please assist/advise

Thanks

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.
4,395 questions
0 comments
Accepted answer
  1. Vidya Narasimhan 2,201 Reputation points Microsoft Employee
    2022-07-29T16:14:08.14+00:00

    Hi @Darren-1990 , Synapse Serverless SQL doesn’t persist any data (only schema for EXTERNAL TABLES and VIEWS) so it relies on ADLS recovery. Schema can be stored and managed using the source control integration feature of Synapse with Azure devops repository as per this link https://learn.microsoft.com/en-us/azure/synapse-analytics/cicd/source-control .
    So, in case of DR, the Synapse Serverless SQL schema can be retrieved from ADO.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest