Forget my last statement. I think you were alone the right lines about multiple log files.

I have tried to attach the db to a test sql2000 box and noticed the 'Device activation error' appears twice for the log files, where there was only one log file on the database.

Looking at the database sysfiles and sysfiles1 tables (from the last backup) only one log file exists. Are there any other places where the logfile locations are held eg master..sysdatabases holds the location of each databases mdf