In this article we are going to see how to drop a server using the SQL Azure Management Portal.
Dropping a server is not a regular task for a developer to do in a day to day activity since its taken over by the SQL Server Database Administrators. But using SQL Azure Management portal its quite easy and use it by few clicks. Let us see the step by step process on how to do it using the Azure Management Portal.
Log in to the Azure portal using the below link. You can see the screen look similar to below
Login to the portal using your Microsoft Windows Live credentials with Azure credentials to the management portal and you will see the screen as shown in the screen below
Now we can see the Database Menu at the bottom left, Click on that will go to the Database Subscription window as shown in the screen below
Clicking on the subscription name will provide the complete details of the server created and the new databases created as shown in the screen below
Now select a particular Server by Clicking on the server name at the Left Menu as shown in the screen below and we can see the information specific to the server with all the database. Now we can decide to drop which server based on the selection. Since in the latest version of the SQL Azure we have provided option to create more than 1 server for a single subscription(Check my article on how to create multiple servers with single subscription)
Now select the server which should be dropped and click on the Drop button at the top menu as shown in the screen below
Once we click the DROP button we will get a popup message as shown in the screen below
Clicking on Drop button will execute the process to drop the server and we can see the execution process as highlighted in the screen below
Once the process is completed we can see the Server has been removed from the list as shown in the screen below
So in this article we have seen how to drop a server from the SQL Azure subscription list using the Azure Management portal