The Ultimate Freedom of Movement with SQL Server 2022 and Azure SQL Managed Instance
summary
Mi link creates a distributed availability‑group bridge between SQL Server (2016–2022) and Azure SQL Managed Instance to replicate user databases near‑real‑time and support bidirectional data movement with almost instantaneous online failover to Azure or back to SQL Server 2022. Setup uses certificate exchange, requires VPN connectivity, supports up to 100 links per managed instance, offers automated SSMS wizards and PowerShell scripts, and currently exposes online failback in preview while 2016/2019 support is rolling out.
AI-written summary · about
chapters (11)
- 0:00Start
- 7:13Link is based on distributed Availability Groups
- 8:06Supported SQL Servers and editions
- 12:52Feature characteristics
- 14:27Link networking requirements
- 16:40Link deeper technical overview
- 22:34Failover orchestration
- 25:37Failing back to SQL Server 2022 instance
- 39:13DR drill - sequence diagram
- 40:48Disaster recovery through forced failover
- 42:08Advanced scenarios with the link feature (recap)
related talks
44mThe Ultimate Freedom of Movement with SQL Server 2022 and Azure SQL Managed Instance- 44mThe Ultimate Freedom of Movement with SQL Server 2022 and Azure SQL Managed Instance
19mThere and back again: SQL Server 2022 - Managed Instance
50mManaged Instance Link - Seamless migration to Azure
48mSQL Server 2022 - the most Azure-enabled SQL Server yet
23mReturn ticket from SQL Managed Instance to SQL Server – One-Click Reverse Migration and DR- 23mReturn ticket from SQL Managed Instance to SQL Server – One-Click Reverse Migration and DR
50mAzure SQL Managed Instance Roadmap