2

I want to run the powershell to schedule automated shutdown. That is to keep DB active for 8 hours from say 10 am to 6 pm.

Tony Ju
  • 14,891
  • 3
  • 17
  • 31
yogesh
  • 29
  • 5
  • 1
    Based on https://stackoverflow.com/questions/26986213/stopping-sql-azure-db-when-not-in-use, it is not possible to shut down a Azure SQL Database. – Gaurav Mantri Apr 25 '19 at 06:32
  • You can only scale down the DB. – rAJ Apr 25 '19 at 06:34
  • Do you have any other concern regarding this question? – Tony Ju Apr 30 '19 at 12:08
  • Actually I'm implementing data warehouse, if we can't shutdown azure db then how can we automate scenario for DWH using powershell base on some condition or REST API – yogesh Apr 30 '19 at 15:52

1 Answers1

1

Currently we can not stop Azure SQL Database. If you want to reduce the cost, you can reduce the size of it.

You can refer to this article for scheduled autoscaling.

Tony Ju
  • 14,891
  • 3
  • 17
  • 31