• I dont think you can just restore a MDF file avoiding LDF from a full backup file.

    Attach, detach will do. You should be able to attach the database with just the MDF file.

    It will create one LDF file automatically for you with default size.

    Found somthing for you, hope it helps.

    --Step 1: Retrive the Logical file name of the database from backup.

    RESTORE FILELISTONLY

    FROM DISK = ‘G:\TransDB_Full.BKP’

    GO

    --Step 2: Use the values in the LogicalName Column in following Step.

    —-Make Database to single user Mode

    ALTER DATABASE TransDB

    SET SINGLE_USER WITH

    ROLLBACK IMMEDIATE

    —-Restore Database

    RESTORE DATABASE TransDB

    FROM DISK = ‘G:\TransDB_Full.BKP’

    WITH

    MOVE ‘O1_SITEDB’ TO ‘J:\TransDB_Data.mdf’,

    MOVE ‘O1_SITEDB_Log’ TO ‘C:\TransDB_Log.ldf’

    /*If there is no error in statement before database will be in multiuser mode.

    If error occurs please execute following command it will convert database in multi user.*/

    ALTER DATABASE TransDB SET MULTI_USER

    GO

    Cheers,
    - Win
    "Dont Judge a Book by its Cover"