How to stop a SQL server while not using it ?

Al Amin Neaz Ahmed 1 Reputation point
2022-10-17T10:42:42.19+00:00

There are links on the internet on how to stop MySQL server in Azure. But how do i stop a SQL server while I'm not using it?

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,911 questions
{count} votes

3 answers

Sort by: Most helpful
  1. Olaf Helper 41,411 Reputation points
    2022-10-17T10:47:25.32+00:00

    Do you mean a SQL Server in a Azure VM?
    MS SQL Server is a normal Windows service and you can shutdown the service, either via Windows Service Manager or directly in SSMS: Right-mouse click on the server node => Shutdown.
    Or per SQL command: https://learn.microsoft.com/en-us/sql/t-sql/language-elements/shutdown-transact-sql?view=sql-server-ver16

    0 comments No comments

  2. Tom Phillips 17,716 Reputation points
    2022-10-17T12:59:43.37+00:00

    SQL Server does not have any built in way to "shutdown on idle". The Windows server is always running.

    0 comments No comments

  3. Erland Sommarskog 102.3K Reputation points
    2022-10-17T21:50:18.843+00:00

    The question is grossly unclear. But if you are using Azure SQL Database, you can achieve what you what, if you go for Serverless. A Serverless database will be dismounted after a certain time of inactivity.

    0 comments No comments