SQL Managed Instance Planned Maintenance Issue

JoelP 296 Reputation points


Just a question, we received email from Azure that there will be a planned maintenance over the weekend. As per my understanding, this should not cause any issues with any SQL jobs, etc. but we encountered an issue on the weekend and the error say the SQL MI is in emergency mode, and our jobs failed due to this.

User's image

Azure SQL Database
{count} votes

Accepted answer
  1. Rahul Randive 9,176 Reputation points Microsoft Employee

    Hi @JoelP

    I think this error is anticipated when attempting to access the database while the instance is undergoing maintenance.

    The Azure infrastructure periodically performs planned maintenance and  – the upgrade of hardware or software components in the datacenter. While the database undergoes maintenance, Azure SQL may terminate some existing connections and refuse new ones and get such error message.

    The failures experienced during planned maintenance are typically transient, and retry logic to your job should help to reduce the impact.

    Post maintenance, your database and instance should be online and healthy.

    Thank you!

0 additional answers

Sort by: Most helpful