Manually attach database (.mdf) into SQL Server with 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