Share via

Disaster Recovery for SQL Server and Pipeline

Relay 320 Reputation points
2025-07-20T14:28:45.2766667+00:00

Hello,

I am creating a Disaster Recovery plan for Azure SQL DB.

May someone please help me with detailed list what all I must consider while doing DR Plan for Azure SQL Data recovery and Partial Data recovery,

My Downstream application has both Analytical and Operational use case. for operational use case salesforce need data every 15 min. for Analytical has to be refresh every 2 hours. Kindly help.

ONLY DR, so if any thing goes down how to handle RTO and RPO.

Please help me.

Thanks a lot.

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.

Azure Data Factory
Azure Data Factory

An Azure service for ingesting, preparing, and transforming data at scale.

0 comments
Answer accepted by question author
  1. Nandan Hegde 36,801 Reputation points MVP Volunteer Moderator
    2025-07-21T06:04:56.4066667+00:00

    Can you be more clear on what you mean by Partial data recovery here?

    As your storage layer is Azure SQL database, then that is the major component on which we need to manage the DR aspect.

    As ADF is your code aspect, as long as the ADF is git integrated we do have a DR strategy available.

    to plan the DR for Azure SQL database, how critical is your downstream application? Because depending on that we can have a geo redundant strategy (though it is costly affair)

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Pratyush Vashistha 5,135 Reputation points Microsoft External Staff Moderator
    2025-07-21T12:14:51.91+00:00

    Thanks, @Nandan Hegde for listing the DR strategies.

     

    Hello Relay!

    In addition to Nandan’s DR strategies, I am sharing some more Data recovery strategies which are as follows that can be considered for Azure SQL Database.

    Point-in-Time Restore (PITR): Quickly recovers your database to a specific historical moment, ideal for accidental deletions or data corruption.

    Geo-Restore: Recovers your database to a different Azure region, providing recovery from regional disasters using recent geo-redundant backups.

    Active Geo-Replication: Maintains a continuously synchronized, readable copy in another region for rapid manual failover and read scale-out.

    Auto-Failover Groups: Automates the failover process to a secondary region, significantly reducing RTO for critical applications.

    Long-Term Retention (LTR) Backups: Offers compliance and extended retention of backups for up to 10 years for regulatory needs.

    Zone Redundancy: Enhances local availability by distributing replicas across different availability zones within a region, protecting against datacentre failures.

    Partial Data Recovery via PITR to a New DB: Allows surgical recovery of specific data by restoring to a temporary database and extracting only what's needed.

    Change Data Capture (CDC) / Temporal Tables: Provides granular historical data tracking for precise, surgical data recovery without full restores.

     

    Please visit following learn documents for more Azure SQL DB recovery approaches.

    Recovery using Backups: https://learn.microsoft.com/en-us/azure/azure-sql/database/recovery-using-backups?view=azuresql&tabs=azure-portal

    Failover groups: https://learn.microsoft.com/en-us/azure/azure-sql/database/failover-group-configure-sql-db?view=azuresql&tabs=azure-portal%2Cazure-powershell-manage&pivots=azure-sql-single-db

    Disaster Recovery: https://learn.microsoft.com/en-us/azure/azure-sql/database/active-geo-replication-overview?view=azuresql&tabs=tsql

     

    I hope this helps. Let me know if you have any further questions or need additional assistance.

     Also, if these answers your query, do click the "Upvote" and click "Accept the answer" of which might be beneficial to other community members reading this thread.

    1 person found this answer helpful.
    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.