How To Stop Azure SQL Database

How To Stop Azure SQL Database

You can stop an Azure SQL database instance to decrease costs. This Azure tutorial will discuss How To Stop Azure SQL Database.

How To Stop Azure SQL Database

We will discuss the steps to stop the Azure Database for MySQL using the Azure portal.

Stop Azure SQL database using Azure Portal

Well, the time to discuss the steps to stop Azure SQL Database. Follow the steps to stop the Azure SQL database for MySQL using Azure Portal.

1. Log in to the Azure Portal (https://portal.azure.com/).

2. Once you have logged in to the Azure Portal, search for Azure Database for MySQL, and click on the search result “Azure Database for MySQL servers,” as shown below.

    stop azure sql database

    3. On the Azure Database for MySQL servers page, you will see the Azure Database lists for MySQL servers you have created. Click on the specific server that you want to stop. Choose the correct one, as you will stop the server.

    how to stop azure sql server

    4. Now, On the Azure Database for MySQL server page, on the Overview tab, click on the Stop button to stop the Azure Database for My SQL server.

    azure stop sql server

    5. Click the Yes button to confirm stopping the server, as highlighted below.

    azure sql database stop

    6. It might take a few seconds and will show you Successfully stopped the MySQL server as shown below.

    how to stop sql server in azure portal

    Stop Azure SQL database using Azure Portal Using Azure CLI

    We can also stop the Azure SQL Database for MySQL using Azure CLI by following the below instructions.

    1. Log in to the Azure Portal (https://portal.azure.com/).

    2. Once logged in to the Azure Portal, click the Cloud Shell button from the top right, as highlighted below.

    azure sql server stop and start

    3. You can use the script below to stop the Azure SQL Database for MySQL using Azure CLI.

    az mysql server stop --name <Your server-name> -g <Your resource-group-name>

    Example:

    az mysql server stop --name demotestdb12 -g Demo123

    Here, demotestdb12 is the name of my Azure SQL Database for MySQL server name, and Demo123 is the name of the resource group. Make sure to change the server and resource group name based on yours.

    Check out Azure SQL Database Serverless

    FAQs

    Azure SQL Database Is An Example Of What Type Of Service?

    Azure SQL Database is an excellent platform as a service (PaaS) database service from Microsoft. This is a fully managed service from Microsoft. The interesting part is that Microsoft takes care of everything, including patching, upgrading, backups, monitoring the performance, etc. No need for the user to take any headaches to manage this stuff.

    Which type of encryption at rest is available for Azure SQL database for MySQL?

    Answer: FIPS 140-2 validated cryptographic module.

    You may also like following the articles below

    Wrapping Up

    In this article, we have discussed how to stop the Azure SQL server database using Azure Portal and Azure CLI. So, stop an Azure SQL database instance to decrease costs using the above information mentioned in this article. I hope you have enjoyed this article !!!