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