how to detach database in SQL Server

To Detach a database in SQL server management studio  follow the following step 

1.   Click start Button                                                                                                                                  

2.        From programs list select sql server management studio 2008 open sql server management                   studio by right click and Run as administrator.... 

3.    after opening sql server management studio next step connect sql server management studio instance by providing Server type Database Engine , Server name and Authentication.
       click connect button to connect  SQL Server

4.       After connecting SQL server you have options on your left side pane , select Databases from list  

4.    Right click on Database  select task option from drop down than select Detachoption  as shown in below figure.

5.    click on ok button to detach database from SQL Server . 

         now you can see your Database is detached from databases List. 

See also:

how to attach database in sql server management studio 2008