Create database from orphaned MDF file in SSMS

Posted by Professionaluser under Sql Server category on | Points: 40 | Views : 122
Follow the below instructions to atach the .mdf file through the management console(SSMS), without a .ldf file,

1. right click "Databases " and select attach.
2. Click on "add " and select the .mdf file, click OK .
3. In the details panel select the .ldf file, click remove button.
4. Click the main OK button.

Comments or Responses

Login to post response