User initiated manual failover on SQL Managed Instance


High availability is a fundamental part of SQL Managed Instance (MI) platform that works transparently for your database applications.  As such, failovers from primary to secondary nodes in case of node degradation or fault detection, or during our regular monthly software updates are an expected occurrence for all applications using SQL Managed Instance in Azure.

 

In August 2020 have released a new feature user-initiated manual failover that can help you manually trigger a failover on a managed instance using PowerShell or CLI commands, or through invoking an API call.

 

Manually initiated failover on a managed instance will be the exact