All we need is an easy explanation of the problem, so here it is.
I created a serverless sql on azure and didn’t use it for few weeks. Now when I go back to it, I found it’s in Pause status.
But searching the azure dashboard, I can’t find any way to resume it. When I google this topic, all result are talking about how to resume Dedicated SQL pool which appears to be a different thing.
How to bring it back online?
How to solve :
I know you bored from this bug, So we are here to help you! Take a deep breath and look at the explanation of your problem. We have many solutions to this problem, But we recommend you to use the first method because it is tested & true method that will 100% work for you.
Once the Azure Database is in pause status, it resumes automatically in the following conditions:
- Database connection
- database export or copy
- Viewing auditing records
- Viewing or applying performance recommendation
- Vulnerability assessment
- Modifying or viewing data masking rules
- View state for transparent data encryption
- Modification for serverless configuration such as max vCores, min vCores, or auto-pause delay
Note: Use and implement method 1 because this method fully tested our system.
Thank you 🙂