.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
abhays
Clintonzz
mattyclown
arronlee
cathyhill345

Home >> Articles >> Azure >> Post New Resource Bookmark and Share   

 Subscribe to Articles

SQL Azure - Drop a Database in SQL Azure Portal

Posted By:Karthikeyan Anbarasan       Posted Date: June 28, 2011    Points: 200    Category: Azure    URL: http://www.f5debug.net/  

SQL Azure - Drop a Database in SQL Azure Portal
 

Introduction:

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

Overview:

Traditionally dropping a database is quite simple using the SQL Server Management Studio by writing a simple query in the Query Analyzer. But in this article we are going drop a database of the SQL Azure using the online Azure Management Portal. Let us see the step by step process on how to do it using the Azure Management Portal.

Steps:

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

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

image

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

screenshot_02

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

image

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

image

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 the administrator details as well

image

Now we can see the different database's available on a particular server, we now choose the server which is not required and should be dropped. In our sample select LearnAzure database as shown in the screen below

image

Now to drop the LearnAzure Database select the Drop button on the top menu as shown in the screen below

image

We will get a prompt as shown in the screen below, Click on DROP if we want to proceed further.

image

After clicking on Drop button we will see the process executing as shown in the screen below

image

Once completed we can see the LearnAzure database been removed from the Server list as shown in the screen below

image

Conclusion:

In this article we have seen how to drop a database from the Server using the SQL Azure Management Portal. In our upcoming article we will see how to drop a server step by step


 Subscribe to Articles

     

Further Readings:

Responses

No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply
Find More Articles on C#, ASP.Net, Vb.Net, SQL Server and more Here

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend