Share via

Hi , I have created one Azure SQL database with Basic pricing tier. I am not able to take it offline or pause the database.

Ankit Kumar Gupta 25 Reputation points
2024-04-29T01:26:13.5466667+00:00

when i go to Settings -> Properties, I can see an option Status ->online for that database but I can not change it to Offline/Pause. Please help since this effect my billing. error

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,860 questions
0 comments
Accepted answer
  1. Rahul Randive 8,826 Reputation points Microsoft Employee
    2024-04-29T02:02:32.3133333+00:00

    Hi @Ankit Kumar Gupta

    This is expected as there is no provision in Azure SQL Database to keep the database in an offline state to save on billing.

    However, to save money, you can opt for the serverless pricing tier. The serverless compute tier automatically pauses databases during inactive periods, during which only storage is billed. It also automatically resumes databases when activity returns.

    Please note, Auto-pausing and auto-resuming is currently only supported in the General Purpose service tier.

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

    Let us know if you have any questions or need additional information.

    Thank You!

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ShaktiSingh-MSFT 13,836 Reputation points Microsoft Employee
    2024-04-29T03:38:54.9166667+00:00

    Hi Ankit Kumar Gupta •,

    Welcome to Microsoft Q&A forum.

    As I understand, you want to optimize Azure SQL DB billing.

    In addition to the below answer, you may consider the option of moving your provisioned DB to Serverless tier which has auto-pause option.

    When moving your database between compute tiers, provide the Compute model parameter as either Serverless or Provisioned when using PowerShell and the Azure CLI, and the compute size for the SERVICE_OBJECTIVE when using T-SQL. Review resource limits to identify your appropriate compute size.

    Refer for details: https://learn.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-overview?view=azuresql&tabs=general-purpose#move-a-database-between-compute-tiers

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

    Hope this helps. Let us know if you have more queries.

    Thanks.