RDS SQL server Instance stuck in Modifying state

Question

I am trying to convert multi-az to single-az. Instance modification is done, but the instance is stuck in the modifying state. Kindly help me bring the RDS instance into an available state

Bhuvan Prasad G · Answer

Hi,

RDS SQL server will take sometime to convert multi-az to single-az based on the instance class size. This conversion doesn't interrupt the traffic, so i suggest you to wait for a bit before doing something.

If you have `stop` or `reboot` option available try using them.(But anyways when an RDS instance is in `modifying` state, those options are not enabled. try on your luck)

If your traffic is interrupted, raise a ticket to AWS asap to get your RDS in correct state.

Please let me know if you have any questions.

RDS SQL server Instance stuck in Modifying state

Relevant content