SQL Failover

Question

Hello, I had to do a manual failover in Azure. My question is do I have to do it again or my secondary is now my primary and I dont have to do anything.

Naimish Makwana · Answer

When you perform a manual failover in Azure, the secondary becomes the primary1. This means that your secondary server has now taken over the role of the primary server. Once the failover is complete, clients can begin writing to the new primary region1. So, to answer your question, you don’t need to do anything further. Your secondary is now your primary and it will function as such until another failover event occurs. However, it’s important to monitor your systems regularly to ensure everything is functioning as expected2. Remember, the purpose of failover is to maintain high availability for your applications1. It’s always a good idea to test your system’s failover resiliency before deploying to production2. This helps mitigate the risk of application faults in production and contributes to application availability for your customers2. Thanks

Arun Ramaswamy · Answer

When you perform a manual failover in Azure, the secondary becomes the new primary. After a successful failover, you don’t need to take any further action unless you want to revert to the original configuration. Here’s what you need to know: Manual Failover : Think of it like switching roles. You intentionally make the secondary resource (which was patiently waiting in the wings) the new star of the show. The original primary (now the new secondary) steps back and lets the new primary take the spotlight. Post-Failover State : Once the failover is complete, your secondary resource (now the new primary) continues to operate as the primary. The original primary (now the new secondary) remains backstage, ready to step in if needed. Monitoring and Maintenance : Keep an eye on the new primary. Make sure it’s performing optimally and meeting expectations. If you encounter any issues, investigate promptly. Remember, the show must go on smoothly! Planned Revert : If you ever want to return to the original configuration (where the original primary becomes the primary again), you can perform another manual failover. Just be cautious—reverting can cause data loss or downtime. So, rest assured, your secondary is now the star, and you’re all set!

Jefferson S. Motta · Answer

For safety, I recommend you ask for MS support.

SQL Failover

Answers (3)