Stopping SQL Azure Temporarily
Being able to stop SQL Azure temporarily. Currently there is no way to stop SQL Azure temporarily. So, you are being charged even if it's not being used.
Thanks for reaching out here. Today’s behavior is by design. Your options to reduce or stop billing, are changing down to the cheapest performance-level, or deleting the DB.
Niels Swimberghe commented
I'm doing some experiments and demo's on my Azure MSDN subscription, but running out of credit because stopping/pausing is not an option for SQL Azure.
I can't downsize as Azure DevOps Server, which is what I'm demo'ing doesn't support SKU's lower than S3.
All my Azure DevOps solution VM's are stopped, but I'll be running out of credit very soon and won't be able to sell this to customer until my credit is replenished.
This is quite disappointing.
the option to pause this would be a good addition
Raphael Nash commented
This functionality is available in SQL DW. So why not Azure SQL. Here is the documentation. https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-manage-compute-portal#pause-compute-bk
Marc Michault commented
A solution needs to be brought forth, as the workarounds are impractical and do not work well for testing
Jeff Dodds commented
Wow... between this and the other denied request Microsoft really doesn't seem to care about their users here. Not too mention the denied request regarding shutting down and App Service Plan.
Venelin Ustabashiev commented
Please implement this!
Pause option is provided for SQL Data warehouse, why not for SQL DB? We are ready to pay for the storage.
we need this!
Mike Honey commented
I give up. Time for a serious look at Amazon RDS I think - it already has a free tier and I hear recently added the ability to read & write regular SQL backups.
Sushanta Paul commented
Need this feature as I do not want the hassle of manual export import everytime, while start and stop works fine. Please add this feature.
Mike Honey commented
As a previous similar request was closed without a resolution, I'm reposting my comments and voting +3 here - I encourage others to do the same.
I also want to pause and unpause test/dev apps frequently. The lack of this feature puts me off using and recommending Azure SQL, as bill shock is common.
The alternative options suggested elsewhere are a hassle to understand and use. This is a standard feature in almost every Azure and competitor cloud service - it seems odd that it isn't offered in Azure SQL. The underlying SQL Server technology would seem to already include several easy ways to support this.
Mathijs Groen commented
I agree with this. Can this feature request be implemented? Thanks a LOT!