Hello,
I recently had a '20613' DB unavailable error in Azure SQL. Upon running diagnostics, it suggested me to perform manual database failover. It worked after that.
1. How can I find out the root cause why I got 20613 in first place so that I can avoid it in future.
Jayraj ChhayaPosted Apr 4, 2024, 12:17 PM
To investigate the root cause of the '20613' DB unavailable error in Azure SQL, you can start by examining the Azure SQL logs and metrics to identify any underlying issues that led to the unavailability. Additionally, check for any recent changes in configurations, updates, or maintenance activities that might have triggered the error.
You can use Azure Monitor to analyze metrics related to database performance, resource utilization, and connectivity issues. Look for any anomalies or spikes that coincide with the occurrence of the error. Furthermore, reviewing the Azure SQL error logs can provide insights into specific errors or warnings leading up to the '20613' error.
KatiePosted Apr 4, 2024, 2:35 PM
Thank you. Seems like Azure had some issue/outage.
So now since I have done manual failover does my secondary become primary? Also do I have to revert anything?