This is the Trace Id: da9f85f2001e92bb12646b30e74538e0

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:

    15/07/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