Database FCB Error

[BFreshour]

A database on one of my servers went suspect and upon restarting the service vanished from the database list. When trying to reattach the database I receive the error

Error 5180: Could not open FCB for invalid file ID 119 in database 'mydb';

Is there a way to fix this in the MDF? Can I somehow tell the reattachment process to proceed with the problem so I can attempt a dbcc or at least recover the majority of the database.

Any help would be appreciated, Thanks.

 

[Bernadette]

HI There

It sounds as if one of your tables is corrupt. You may need to restore the database from a backup.

Hope This Helps



Bernadette