Can we Stop Azure SQL Database ?

Question

Is there way to stop Azure SQL database to save cost as my load generally run during the business hours and no activity during the off business hours.

Answer 1

Azure SQL Database offers a feature called "Pause and Resume" for its serverless tier.The cost for a serverless database is the summation of the compute cost and storage cost.But this approach is quite expensive.

Or you could just set up a MySQL database on a virtual machine and use automation tools (logic apps) to start/stop the VM based on a schedule or triggers.

Another alternative you can try is that if you have multiple databases with varying and unpredictable usage patterns, an elastic pool might be more cost-effective than individual serverless databases. It allows you to share resources among multiple databases.

Answer 2

Yes, you can do this if you have Serverless business tier. Beware that Serverless is more expensive once it's running, but if you only want to run during business hours, Serverless would be a deal for you, unless you are one of the really cheap ones like S0 now.