snippetMinor
How to resume Azure serverless SQL Server from pause
Viewed 0 times
sqlpauseserverlessazureresumehowserverfrom
Problem
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?
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?
Solution
Once the Azure Database is in pause status, it resumes automatically in the following conditions:
https://www.sqlshack.com/automatic-pause-and-resume-an-azure-sql-database/
- 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
https://www.sqlshack.com/automatic-pause-and-resume-an-azure-sql-database/
Context
StackExchange Database Administrators Q#294978, answer score: 6
Revisions (0)
No revisions yet.