How to stop a SQL server while not using it ?

Al Amin Neaz Ahmed 1 Reputation point

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

    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:

    0 comments No comments

  2. Tom Phillips 17,716 Reputation points

    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

    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