How to Resume Azure SQL Serverless Database Manually?

Problem

It was a horrible experience with a busy day. Suddenly the Developer Database, presumably Azure SQL Serverless Database went off. In another word, it was in Auto-pause mode.  When I search through the internet, I couldn't find any reliable method of turn it back to accessible or resume mode. According to the documentation, If I login to the database then it should be turned it back, but it is not the case. I tried with both Management Studio and Azure Data Studio those options were not in my favor.



Solution

Unfortunately, the solution is pending. Unless you have to trigger manually by doing one of the tasks was in the list I've referenced above. I found that this feature is started to develop, according to the Microsoft Azure forum. But, that is not helpful to get sorted my issue today.

Workaround 

Maybe if you are an Application developer you might not get this issue. Perhaps if you invoke some function which hit to the database, this problem will get sort much faster. But, I'm a BI consultant who are working on application development less frequently. So, I tried to connect to the database via Microsoft Power BI desktop, which you can download for free. Which is the best use case scenario when it comes to Business Intelligence. Surprisingly it worked perfectly. The Azure SQL Serverless database turned back to Online. This is not a solution, at least a workaround till they bring this feature to Live..


Comments

  1. Great post! Thanks for sharing this amazing post on Web Design & Development, keep blogging. Business Intelligence Consulting Services

    ReplyDelete

Post a Comment