Share via

How do I 'pause' an Azure SQL database (serverless)?

Collins, Donald 26 Reputation points
2022-01-24T15:19:55.257+00:00

Hi Support,

How do I 'pause' an Azure SQL database (serverless)?

In the "Overview" section , the "Status" is set to "Online".

How do I set it to "Paused" ?

I do not see a button or option to do so, see screenshot attached.

Thanks!

Best Regards,
Donald

Azure SQL Database
0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Bryan Williams 71 Reputation points
    2024-03-10T13:26:31.4233333+00:00

    The above answers are all wrong because they don't answer the question, which is how to PAUSE the database, not "auto-pause it during times of inactivity". As of 2024 there is still no option to stop/pause an Azure SQL database and keep it paused. You have to either remove access to the database or delete it.

    8 people found this answer helpful.
  2. Alberto Morillo 35,501 Reputation points MVP Volunteer Moderator
    2022-01-25T14:59:15.343+00:00

    Hello @Nandan Hegde

    Sorry I noticed too late you mentioned me.

    Please on the serverless database make a click on the link shown below in red:

    168318-1.png

    Now, scroll down on the next page:

    168363-image.png

    Now specify the time period when the database should go inactive/auto-paused.

    168320-image.png

    If you don't see above options, then let me know.

    If you already set the time period for the database to go inactive, and you don't see it going to "paused" state please read [this]4 forum thread about posible reasons why the database is not going inactive.

    1 person found this answer helpful.
  3. Nandan Hegde 36,801 Reputation points MVP Volunteer Moderator
    2022-01-24T15:24:04.203+00:00

    Hey,
    Based on my understanding:

    167889-image.png

    https://learn.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-overview

    There is no explicit way to pause but it pauses automatically based on some inactivity.

    @Alberto Morillo : please provide your thoughts on the same

    1 person found this answer helpful.
    0 comments
  4. GeethaThatipatri-MSFT 29,597 Reputation points Microsoft Employee Moderator
    2022-01-24T16:22:29.03+00:00

    Hi, @Collins, Donald Thanks for posting your question in the Microsoft Q&A forum,
    Thanks, @Nandan Hegde for your contribution and for providing the documentation.
    adding to NandanHegde-7720 If the database is configured to Serverless if there are no active connections to DB it will go to sleep mode automatically,
    when we try to login into the database it will take 2-5min to come active state.

    below is the screenshot where you can set the auto-pause delay time under Compute + storage.

    167877-image.png

    Regards
    Geetha

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.