HiveBrain v1.2.0
Get Started
← Back to all entries
snippetMinor

How to resume Azure serverless SQL Server from pause

Submitted by: @import:stackexchange-dba··
0
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?

Solution

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



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.