Return ticket from SQL Managed Instance to SQL Server – One-Click Reverse Migration and DR
summary
Demo shows Mi link online replication that sets up distributed AGs from SQL Server 2016+ to Azure SQL Managed Instance via an SSMS wizard that also emits the exact script it runs. SQL Server 2022 adds one‑click reverse failover and backup/restore back to on‑prem, enabling live DR drills with planned failover and no data loss in the demo. The link can be created from MI to SQL Server 2022, handles TDE with key configuration, and uses DNS aliasing for seamless app repointing; licensing notes include hybrid failover rights for passive secondaries.
AI-written summary · about
chapters (7)
- 0:00Mi Link feature
- 1:54Mi Link capabilities
- 4:21SQL Server to MI replication demo
- 9:05Disaster Recovery failover
- 14:03Reverse replication to SQL Server
- 18:42Application failover with DNS
- 20:05Q&A on licensing & encryption
related talks
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
19mThere and back again: SQL Server 2022 - Managed Instance
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
50mManaged Instance Link - Seamless migration to Azure- 44mThe Ultimate Freedom of Movement with SQL Server 2022 and Azure SQL Managed Instance
- 50mManaged Instance Link - Seamless migration to Azure