• When u attach the db with no log file, the device activation error occurs and sql server creates a new log file..

    After executing the attach statement, exec sp_helpdb 'dbname' should give you the locations of the files..

     

    -Krishnan