How to do a forced restart on a sql managed instance

Question

How to do a forced restart on a sql managed instance

Alan Niedelman 0

Managed instance has been iin a "Starting" State for three days

RahulRandive 10,486 Reputation points Volunteer Moderator

2023-07-31T12:56:44.53+00:00

Hi Alan Niedelman •

If you have a support plan, as Andreas recommended, please create a support ticket and share the case number with us.

If you don't have a support plan, just let us know, and we'll assist you accordingly.

Thank you!
SSingh-MSFT 16,371 Reputation points Moderator

2023-08-02T04:15:02.2366667+00:00

Hi
Alan Niedelman,

We haven't heard back from you. In case you need help in support case or have already found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.

Thanks

2 answers

Your answer

RahulRandive 10,486 Reputation points Volunteer Moderator

2023-07-31T12:56:44.53+00:00

Hi Alan Niedelman •

If you have a support plan, as Andreas recommended, please create a support ticket and share the case number with us.

If you don't have a support plan, just let us know, and we'll assist you accordingly.

Thank you!
SSingh-MSFT 16,371 Reputation points Moderator

2023-08-02T04:15:02.2366667+00:00

Hi
Alan Niedelman,

We haven't heard back from you. In case you need help in support case or have already found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.

Thanks

Answer 1

Andreas Baumgarten 123.6K MVP Volunteer Moderator

Hi @Alan Niedelman ,

stop and start an Azure SQL Managed Instance is still in preview: Stop and start an instance (preview) - Azure SQL Managed Instance

As far as I know there is no option to force a restart of an Azure SQL Managed Instance. But you could create a support ticket with Azure support to get your issue solved.

(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

Regards

Andreas Baumgarten

Answer 2

Oury Ba-MSFT 20,931 Microsoft Employee Moderator

@Alan Niedelman Thank you for reaching out.

It is not possible to do a forced restart in SQL MI at this time. There is only a User-Initiated Failover, which does not guarantee a SQL MI Instance restart.

User initiated manual failover on SQL Managed Instance - Microsoft Community Hub

Hope that helps

Regards,

Oury

Oury Ba-MSFT 20,931 Reputation points Microsoft Employee Moderator

2023-08-03T20:52:37.0333333+00:00

@Alan Niedelman

Please don't forget to mark as accept answer if the reply was helpful.

Regards,

Oury

Share via

How to do a forced restart on a sql managed instance

2 answers

Your answer