SQL Managed Instance Planned Maintenance Issue

Question

SQL Managed Instance Planned Maintenance Issue

JoelP 366

Hi,

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

SSingh-MSFT 16,371 Reputation points Moderator

2023-12-06T05:00:13.04+00:00

Hi @JoelP,

Just checking in to see if the provided suggestion helped. If this answers your query, do click Accept Answer and Mark Helpful for the same. And, if you have any further query do let us know. Thanks

Accepted answer

0 additional answers

Your answer

SSingh-MSFT 16,371 Reputation points Moderator

2023-12-06T05:00:13.04+00:00

Hi @JoelP,

Just checking in to see if the provided suggestion helped. If this answers your query, do click Accept Answer and Mark Helpful for the same. And, if you have any further query do let us know. Thanks

Answer 1

RahulRandive 10,486 Volunteer Moderator

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!

JoelP 366 Reputation points

2023-12-13T21:58:28.29+00:00

thank you. will add retry logic or move sql jobs at a later part of the maintenance window.

Share via

SQL Managed Instance Planned Maintenance Issue

0 additional answers

Your answer