Attach Database in SQL Server manually with SQL Management studio

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