Chances are you didn't rename a database file, so use the following in Query Analyzer to see what exactly the error is:

DBCC CHECKDB (‘YourDBnameHere’) WITH NO_INFOMSGS, ALL_ERRORMSGS

You can also attempt to repair it using the following in Query Analyzer:

EXEC sp_resetstatus ‘yourDBnameHere’;

    ALTER DATABASE yourDBnameHereHere SET EMERGENCY

    DBCC checkdb(‘yourDBnameHere’)

    ALTER DATABASE yourDBnameHere SET SINGLE_USER WITH ROLLBACK IMMEDIATE

    DBCC CheckDB (‘yourDBnameHere’, REPAIR_ALLOW_DATA_LOSS)

    ALTER DATABASE yourDBnameHere SET MULTI_USER

Hope this helps...

---