You can stop an Azure SQL database instance to decrease costs. This Azure tutorial will discuss How To Stop Azure SQL Database.
Table of Contents
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.
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.
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.
5. Click the Yes button to confirm stopping the server, as highlighted below.
6. It might take a few seconds and will show you Successfully stopped the MySQL server as shown below.
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.
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 Demo123Here, 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
- Azure SQL Database IP Address
- The Server Was Not Found Or Was Not Accessible
- How to create an Azure SQL database
- How To Change User ID and Password For Azure SQL Server Database
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 !!!
I am Rajkishore, and I have over 14 years of experience in Microsoft Azure and AWS, with good experience in Azure Functions, Storage, Virtual Machine, Logic Apps, PowerShell Commands, CLI Commands, Machine Learning, AI, Azure Cognitive Services, DevOps, etc. Not only that, I do have good real-time experience in designing and developing cloud-native data integrations on Azure or AWS, etc. I hope you will learn from these practical Azure tutorials. Read more.