What are the best practices or recommendations for setting up Disaster Recovery (DR) for services hosted on Azure?

Vivek Komarla Bhaskar 936 Reputation points
2025-04-23T12:43:03.0066667+00:00

I'm looking for recommendations on how to set up disaster recovery (DR) for the following Azure services, which are deployed in both test and production resource groups. I’ve been asked to plan a comprehensive DR strategy (Particularly Synapse dedicated pool), and I’d appreciate any best practices or suggestions from the community.

Here are the services in scope:

Azure Key Vault

Azure Storage Account (Gen2)

Azure Synapse Workspace

Azure Synapse Dedicated SQL Pool

Azure Data Factory

Any guidance around replication, failover, automation, or DR testing would be incredibly helpful. Thanks in advance!

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,305 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Nandan Hegde 34,941 Reputation points MVP
    2025-04-23T13:33:16.87+00:00

    You can follow the below approach for the below offerings:

    1. Synapse dedicated pool : Create a Server in a geo redundant location as to the original server and create a restore point in the original pool and then restore it as a new database pool in the Geo redundant server and then pause the pool (to preserve the cost)

    This logic can be scheduled daily/weekly based on your DR frequency and on every run post successful creation of the new database, delete all prev version of database from the DR server

    This would ensure DR for the data and the code aspect.

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

    2 . ADF : https://learn.microsoft.com/en-us/answers/questions/2133864/how-to-perform-azure-data-factory-disaster-recover

    AS ADF is code only, you can export the ARM template and/or git integrate it as the best form of DR

    1. Azure Key vault : https://learn.microsoft.com/en-us/azure/key-vault/general/disaster-recovery-guidance

    4.ADLS Gen 2 : while creating , you can create a Geo redundant storage :

    https://learn.microsoft.com/en-us/azure/storage/common/storage-disaster-recovery-guidance


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.