Share via

How to stop Azure SQL Database

Linda Belebesi 45 Reputation points
2023-08-23T10:21:20.8433333+00:00

I have created Azure SQL Server and database and the DB instances will only be used in two weeks time. For a day it has already consumed $1.15. How to I stop it if not in use?

Azure SQL Database
Accepted answer
  1. RahulRandive 10,486 Reputation points Volunteer Moderator
    2023-08-24T00:49:22.52+00:00

    Hi @Linda Belebesi

    Yes its not supported yet for Azure SQL Server however (Just FYI) Recently introduced Stop and start an instance (preview) for Azure SQL Managed Instance

    If the intention is to save the cost, you can automate the Pause and Resume of an Azure SQL database

    Here is a blog- https://www.sqlshack.com/automatic-pause-and-resume-an-azure-sql-database/

    Thank you!

    2 people found this answer helpful.

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. TP 125.8K Reputation points Volunteer Moderator
    2023-08-23T10:34:51.43+00:00

    Hi Linda,

    There is no way to stop the server/database, however, what you could do instead is switch to a lower-cost tier or switch to serverless tier with auto-pause enabled. With auto-pause enabled the server will pause if there is no activity during the time period you set (minimum of 1 hour).

    You can change the tier in the portal via Settings -- Compute + storage.

    Serverless compute tier for Azure SQL Database

    https://learn.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-overview?view=azuresql&tabs=general-purpose

    Please click Accept Answer if the above was helpful.

    Thanks.

    -TP

  2. Alberto Morillo 34,671 Reputation points MVP Volunteer Moderator
    2023-08-23T12:46:07.5366667+00:00

    Stopping an Azure SQL Database is not currently supported, but there are several options that could be helpful. Please read about them here.

    0 comments
  3. SSingh-MSFT 16,371 Reputation points Moderator
    2023-08-24T09:50:54.9566667+00:00

    Hi
    Linda Belebesi     •,

    Welcome to Microsoft Q&A forum.

    As we understand, you want to know how to stop Azure SQL Database.

    As mentioned in the below answers, currently is not possible. However, we have an article which illustrates different methods of saving cost here: https://techcommunity.microsoft.com/t5/azure-database-support-blog/stop-azure-sql-database/ba-p/3890369?wt.mc_id=DP-MVP-4015656

    Please refer above blogpost and also we recommend you to add your valuable feedback over Azure SQL Database Feedback Channel to add this feature so that concerned team could look into it on the basis of importance and up-votes.

    Thanks for your support.

    0 comments

Your answer

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