Attach Database in SQL Server manually with SQL Management studio

 

1.    Download and install SQL Server Management Studio from below link

 

Please refer How to install Microsoft SQL Management Studio


2. Launch SQL Server Management Studio

 

3. On the login screen, choose ‘SQL Server Authentication’

 

4. Username = sa and password = QnE123!@# (Case sensitive)

 

 

5. After login, on the Object Explorer (left hand side)

 

6. Right click on ‘Databases’ and select ‘Attach’



7. Click on the ‘Add’ button

 

8. By default ssms will direct to path C:\Program Files\Microsoft SQL Server\MSSQL10_50.QNEBSS\MSSQL\DATA

 

9. Example I wish to attach back database ‘SampleDB2017011.mdf’

 

10. Select ‘SampleDB2017011.mdf’ and click OK button


 

 

11. Then click OK button again


Attach Database in SQL Server manually with SQL Management studio, Successfully.


Discover : How to Add Multiple SQL instances in SQL Management studio

Know more about Microsoft SQL Server Product


Created by Cheng Kah Poh