• Using SSMS is the simplest way to attach MDF file without LDF file. I mentioned some steps in which you can execute this task.

    Firstly open the SSMS and then choose databases an object explorer item

    Then right click on it and choose attach option

    A window appears on the screen click on add then suddenly browse the MDF file

    As on selecting MDF file a confirmation window opens confirm it. In this window the in downward side two files are list i.e. MDF and LDF file. Select the LDF file and remove it. Then click on OK

    MDF file successfully attached you can verify in the databases list.

    SSMS Expert