We have two SQL Server nodes running in an AlwaysOn Availability Group. I'm looking for some suggestions and/or best practices on how to temporarily suspend connection or prevent users from connecting the Availability Group? I was thinking to pause SQL Server running on the primary node and this will prevent new connections. If I did that, would it failover to the secondary?
Basically we have new AG running in Azure. We will pick a date and switch from on-prem to Azure. After the switch, we don't want new connections to on-prem. However, if there are issues after the switch, we need to be able to fall back to on-prem and resume the operations just like before.
What's the best way to handle this?
Follow up: Yes, you can simply place the primary on 'pause'. Just did a test and it worked.