This is the Trace Id: 3149bc893ed8ad4ac3246dde85e7d8cd

Azure SQL Managed Instance – Sync Agent Jobs & Logins in Failover Group

Azure SQL Managed Instance – Sync Agent Jobs & Logins in Failover Group

Important! Selecting a language below will dynamically change the complete page content to that language.

Download

  • Version:

    2.0

    Date Published:

    7/15/2024

    File Name:

    MIFailoverGroups_Scripts.zip

    File Size:

    45.8 KB

    In an Azure SQL Managed Instance setup with Failover Group, the schema, data and database level users will always be synced between primary and secondary instance. This document provides guidance and scripts to implement a workaround solution to have the Agent Jobs and Server Logins/Roles synced between primary and secondary instances.

  • Supported Operating Systems

    Windows 11, Windows 10

    none

  • none
Back To Top