Lesson Learned #207: Hands-On-Labs: 40613-Database ‘xxx’ on server ‘xxxx’ is not currently available

This post has been republished via RSS; it originally appeared at: New blog articles in Microsoft Tech Community.

We used to have cases where our customer faced the following error message: "40613-Database ‘xxxx' on server ‘xxxx' is not currently available.  Please retry the connection later.  If the problem persists, contact customer support, and provide them the session tracing ID of 'AFDB133B-E6A0-4AFD-9021-xxxxx'.State: 1" in this video we are going to give some insights about it.

 

This issue happens when the Azure database is being moved (or reconfigured) and your application loses its connection to the SQL database. SQL database reconfiguration events occurs because of a planned event (for example, a software upgrade) or an unplanned event (for example, a process crash, or load balancing). Most reconfiguration events are generally short-lived and should be completed in less than 60 seconds at most. 

 

In this video we are going to give some insights about it:

 

Why issue happens?

  • Connectivity Transient Issue.
  • Reconfiguration.
  • Maintenance Plan.

How to find when the issue happened?

  • Resource Health/Activity Log from the Portal

How to fix or mitigate this issue?

  • Implement Connectivity Retry Logic.

 

Enjoy!

Leave a Reply

Your email address will not be published. Required fields are marked *

*

This site uses Akismet to reduce spam. Learn how your comment data is processed.