Suspect database Could not open FCB for invalid file ID 0 in database

[kdubb77]

I have a MOM database that had some issues over the weekend and is now coming up suspect. I have the db in emergency mode and when I run dbcc checkdb with or without repair options I get the following error message Could not open FCB for invalid file ID 0 in database 'OnePoint'

The log files are intact and the data file is intact in the path where it should be. I can select from a few tables just as I was poking around so the database is not totally corrupt. We DO NOT have a backup is there any suggestions???

 

[ptheriault]

Have you tried to reset the database status?

Look up sp_resetstatus in BOL.


- Paul

- If at first you don't succeed, find out if the loser gets anything.