case: my db was in mode "suspect" and i try to detach db and now i can't attach it at all. I got this error message when im try to attach the db:
"---------------------------
Microsoft SQL-DMO (ODBC SQLState: 42000)
---------------------------
Error 1813: Could not open new database 'db_ControlManager'. CREATE DATABASE is aborted.
Device activation error. The physical file name 'E:\MSSQL\Data\db_ControlManager_log.LDF' may be incorrect.
---------------------------"

The logfile is lost but when i try to attach it says that it might cretate a new log file but it dosen't. There is no problem for me to loose whats in that log file as long as i can access the data in db.

And of course the backup software dosen't work so i have no backup of the db

How can i try to repair the db?

thx in advance for any help

im using sql 2000 with sp4