SSIS High Availability and Disaster Recovery

Dinesh Kumar Sharma 20 Reputation points
2024-11-28T08:27:21.9866667+00:00

Greetings,

Pls suggest the approach / method to Implement High Availability and Disaster Recovery for SSIS

Thanks and Regards

Dinesh Sharma

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,619 questions
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Shikha Ghildiyal 1,170 Reputation points Microsoft Employee
    2024-11-28T08:40:17.53+00:00

    Hi @dinesh kumar sharma ,

    Thanks for reaching out to Microsoft Q&A.

    As per your requirement, you can follow this documentation which speaks about high availability (HA) and disaster recovery (DR).-https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/business-continuity-high-availability-disaster-recovery-hadr-overview?view=azuresql and https://learn.microsoft.com/en-us/system-center/scom/plan-hadr-design?view=sc-om-2025

    Let me know if this helps.

    Please do not forget to "Accept the answer” and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.


  2. Shikha Ghildiyal 1,170 Reputation points Microsoft Employee
    2024-11-28T09:09:53.16+00:00

    Hi @dinesh kumar sharma ,

    Here is the document for SSIS- https://learn.microsoft.com/en-us/azure/data-factory/configure-bcdr-azure-ssis-integration-runtime

    Please do not forget to "Accept the answer” and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.

    0 comments No comments

  3. ZoeHui-MSFT 38,951 Reputation points
    2024-11-29T06:53:12.47+00:00

    Hi @Dinesh Kumar Sharma,

    You may check the documentation about HA for SSIS.

    Configure SSIS support for Always On

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments No comments

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.