Microsoft SQL Server 2005 Management Studio Express Database Backup

In this post I will let you know how to delete Database from Microsoft SQL Server 2005. Although its very easy and simple if any one has done this before but for new programmers and students this step by step process helps a lot.


If you need to download SQL Server 2005 Express edition which is free the use the below link:
http://www.microsoft.com/en-us/download/details.aspx?id=21844

If you want to purchase SQL Server 2005 Developer Edition then use below link:



Step 1 (Microsoft SQL Server 2005 Overview):
 First of all you have open up Microsoft SQL Server 2005 Management Studio Express which can opened from Programs menu. Below is the overview window showing the databases contained in SQL. I am going to delete MyDatabase database in this tutorial.

Step 2 (SQL Server Database Delete Option):
Right click on MyDatabase database which we want to delete and click on Delete option from context menu that is shown.

Step 3 (SQL Server Database Deletion Form):
 After the second step a Delete Form gets shown containing Database name which we want to delete. I have highlighted two check box options in below screen. You must check both of them otherwise you may get error that database could not be deleted. Then click OK and deletion process gets start.

Step 4 (SQL Server Database Deleted Successfully): 
After completing Step 3 without error you will be shown SQL Overview window again and you can see that database is not showing in Databases list which we have delete.

Hope you will find it easy but if you want to improve it then give me suggestion and I will update this post.