This is the Trace Id: be9f99f39a953dda0f677445d47a0404

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