This is the Trace Id: fb42fb0f0ada47dd9305dd7653954ff8

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