Azure SQL Database
An Azure relational database service.
5,667 questions
yes, there was an intermittent issue
it seems to be resolved now
Database is not currently available error 40613
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(224.00000000000003, 92%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
CalizaTriturados
0
Reputation points
Hello all,
Today we are facing a problem with the access to database, only we can not access by aplications or direclty into the azure portal only we are getting the message that database is not currently available, do you know what we can do? I can not see any option to restart or do something in the portal
4 answers
Sort by: Most helpful
-
Nandan Hegde 32,336 Reputation points MVP2024-04-04T06:09:10.0833333+00:00 -
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(179.20000000000002, 25%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
SABA 0 Reputation points2024-04-04T12:23:44.89+00:00 @Nandan Hegde I did a manual failover and it started working. I am new to Azure. Do I have to do failover again or I can continue with secondary DB as my primary now?
Sign in to comment -
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 79%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
RahulRandive 9,666 Reputation points2024-04-04T01:32:29.38+00:00 Just to check, is your server in East US region? If yes, seems be some issue in that region. You can open a support case to check the health of your server and platform side issue.
Also, please check the Resource Health on Azure Portal. It is located on the left vertical panel related to your Azure SQL database.
Thank You!
-
SABA 0 Reputation points
2024-04-04T20:23:06.3233333+00:00 I did a manual failover and it started working. I am new to Azure. Do I have to do failover again or I can continue with secondary DB as my primary now?
-
RahulRandive 9,666 Reputation points
2024-04-04T20:44:13.77+00:00 Hi SABA
Yes, the issue is mitigated. If you have a geo replica and had failed over to the geo secondary during impact, you can now fail back to East US.
Thank You!
-
SABA 0 Reputation points
2024-04-04T21:02:13.42+00:00 @RahulRandive -No. I do not have geo replica. I have a very basic SQL server with 2 Database. I only executed Invoke-AzSQlDatabaseFailover and it started working.
So now, I just continue or have to perform any additional steps?
-
RahulRandive 9,666 Reputation points
2024-04-04T23:31:08.0533333+00:00 Hi SABA,
You should be good. You can verify the location of your SQL server from the portal- SQL Server- Overview
Thank You!
Sign in to comment -