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
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article