Floating FB popout byF5debug

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.

[more]

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/

clip_image002

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

clip_image004

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

clip_image006

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

clip_image007

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

clip_image008

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

clip_image009

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

clip_image010

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

clip_image011

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

clip_image012

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

clip_image013

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

About Author: Karthikeyan Anbarasan, Microsoft MVP (Most Valuable Professional) in ASP.NET/IIS Architecture. He is the Founder and Chief Editor of the www.f5debug.net website and has authored books on Windows Phone and Business Intelligence(SSIS). He is also a Passionate Speaker and a Blogger on Microsoft Technologies.

You can Join Me On: Facebook, Twitter, Google Plus, LinkedIn

Add comment

  Country flag

biuquote
  • Comment
  • Preview
Loading

Recent Posts

Advertisement

Random Posts

Most Viewed

BlogStatistic

Total posts: 617This year: 4This month: 2This week: 0Comments: 302

Month List

URL Shortner

Create your own short urls!!!

Site Counter

free counters

Disclaimer

This is a personal weblog. The opinions expressed here represent my own and not those of my employer. For accuracy and official reference refer to MSDN/ TechNet. I have documented my personal experience on this blog.

Protected by Copyscape Web Plagiarism Finder

Site Meter