how to attach database in SQL Server Management Studio 2008

To attach a database in SQL server management studio 2008 simply follow the follow 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 open sql server management studio next step connect sql server management studio instance          by providing Server type Database Engine , Server name and Authentication. there are two types of          authentication 1 Windows Authentication 2. sql server 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 and select Attach option from drop down as shown in below figure.

5.    click on add button to chose database from your hard drive location . 

6.    after selecting database .mdf file click OK to attach Database.  

            now you can see your Database in attached databases List.