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.
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