SQL Azure - Drop a Server in SQL Azure Portal

Introduction:

In this article we are going to see how to drop a server using the SQL Azure Management Portal.

Overview:

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 it's quite easy and can be done in a few clicks. Let us see the step by step process of how to do it using the Azure Management Portal.

Steps:

Log in to the Azure portal using the following link. You can see the screen look similar to below.

http://www.microsoft.com/windowsazure/

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 to 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 server by clicking on the server name in the left menu as shown in the screen below and we will see the information specific to the server with all the databases. Now we can decide to drop which server based on the selection. Since in the latest version of SQL Azure we are provided with the 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 the Drop button will execute the process to drop the server and we can see the execution proceed 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:

Conclusion:

So in this article we have seen how to drop a server from the SQL Azure subscription list using the Azure Management Portal.