See in action DR between SQL Server 2022 and SQL MI

sasapopo

Microsoft

Nov 06, 2024

and other Azure SQL Managed Instance link capabilities!

Introduction

Last month in October 2024, we’ve announced the general availability of additional SQL Managed Instance (MI) link features with SQL Server 2022, bringing robust two-way disaster recovery (DR) capabilities. With bi-directional failover, organizations can now seamlessly switch between SQL Server 2022 and Azure SQL Managed Instance, providing modern and flexible BCDR solution for hybrid environments.

SQL MI link demo videos

To help you get up to speed with MI link capabilities, we’ve published four demo videos.

Read Scale-out with SQL Managed Instance Link – Learn to set up read-only database replicas on Azure SQL Managed Instance, ideal for scaling read operations while keeping data in sync with SQL Server.

Planned Failover (DR Drill) with MI Link – Watch a guided demo of planned failovers, showing how SQL MI link enables DR drills through SSMS, enhancing capabilities of hybrid setups. Hybrid DR capability can help you meet DORA (see also EIOPA-DORA) requirements for operational resilience.

Database Migration to SQL MI – This video illustrates how to migrate databases from SQL Server to SQL Managed Instance, highlighting a simplified, step-by-step process for SQL Server versions from 2016 onwards.

Creating MI Link from SQL MI to SQL Server – Explore the process of establishing a link from Azure SQL Managed Instance (with Update Policy SQL Server 2022) back to SQL Server 2022. This capability enables data mobility and can help with meeting regulatory requirements and similar scenarios.

These videos provide essential walkthroughs, helping you leverage Azure SQL Managed Instance link features to elevate disaster recovery, scaling, and migration in your SQL Server environments. Explore the capabilities today and prepare for seamless DR and hybrid cloud management!

If you'd like to see more videos covering MI link capabilities, please let us know in the comment section what you'd like us to cover!