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).