locked
Is it possible to stop a Azure SQL Database during non working hours to reduce billing charges?, how? RRS feed

  • Question

  • Is it possible to stop a Azure SQL Database during non working hours to reduce billing charges?,

    If answer is yes, I will appreciate if you let know how I can do that?

    Thanks a lot,

    Eduardo O

    Tuesday, August 4, 2020 12:27 AM

All replies

  • This can be done with Azure Automation Account and schedule a runbook with PowerShell script to start and Stop SQL Server.

    Thanks Shiven:) If Answer is Helpful, Please Vote

    Tuesday, August 4, 2020 12:32 AM
  • Hi EduOca,

    The answer is no currently.

    However there are solutions for this issue.

    Please reference: stopping-sql-azure-db-when-not-in-use

    If the response helped, do "Accept Answer" and upvote it.

    BR,

    Mia


    ""SQL Server related"" forum will be migrated to a new home on Microsoft Q&A SQL Server!
    We invite you to post new questions in the "SQL Server related" forum’s new home on Microsoft Q&A SQL Server !
    For more information, please refer to the sticky post.

    Tuesday, August 4, 2020 2:59 AM
  • Is it possible to stop a Azure SQL Database during non working hours to reduce billing charges?,

    You should look at the Serverless option. With Serverless, you can have the server to be stopped when no one is using it. This can be a big cost saver.
    This is something you can change from the Portal. I believe that there is some configuration you can set up when it should shut down etc.

    Beware, that if the service is stopped, it takes a little while when you connect to it, as it has to start.


    Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

    Tuesday, August 4, 2020 8:50 AM
  • Hi EduOca,

    Is the reply helpful?

    If the response helped, do "Accept Answer" and upvote it.

    BR,

    Mia


    ""SQL Server related"" forum will be migrated to a new home on Microsoft Q&A SQL Server!
    We invite you to post new questions in the "SQL Server related" forum’s new home on Microsoft Q&A SQL Server !
    For more information, please refer to the sticky post.

    Wednesday, August 5, 2020 1:22 AM
  • Hi EduOca,

    Is the reply helpful?

    If the response helped, do "Accept Answer" and upvote it.

    BR,

    Mia


    ""SQL Server related"" forum will be migrated to a new home on Microsoft Q&A SQL Server!
    We invite you to post new questions in the "SQL Server related" forum’s new home on Microsoft Q&A SQL Server !
    For more information, please refer to the sticky post.

    Thursday, August 6, 2020 1:21 AM