did you check usp_AttachDBWithMissingLogFile ?
I also found this in my archive :
-- DBCC rebuild_log (dbname [, filename])-- -- -- -- Create new database with same name, stop SQL Server, replace the MDF file from original database file -- -- -- -- and restart SQL Server to see whether your database is back in suspect mode. -- -- -- -- If it does, reset the database to emergency mode and run DBCC Rebuild_Log to recreate the log file. -- -- -- -- Once database is back to normal, run DBCC checkdb to ensure there is no integrity error,-- -- -- -- otherwise, you have to BCP the data out.-- -- -- Allen Cui www.sqlservercentral.com did an article on this "Undocumented DBCC Command REBUILD_LOG"
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 1Line 1: Incorrect syntax near 'Event'.
DBCC rebuild_log ('Dorian Event Archiver', 'yourdrivepath\Dorian Event Archiver_Log.ldf')