• I have a similar situation. I have a database data file named Dorian Event Archiver_Data.mdf and no corresponding log file. (it was deleted, no backup) I am trying to reattach the database with and have SQL create a new trans log. I tried the suggestion above:

    DBCC rebuild_log (Dorian Event Archiver, Dorian Event Archiver_Log.ldf)

    but get the following error:

    Server: Msg 170, Level 15, State 1, Line 1

    Line 1: Incorrect syntax near 'Event'.

    Ideas?

    -Al