Applications cannot cause this type of corruption - it's either a SQL Server bug, a corruption caused by the IO subsystem, or a corruption that existed in 2000 but wasn't...

This is definitely the MSDB database on your Express instance.

Please post the output of DBCC CHECKDB (msdb) WITH ALL_ERRORMSGS, NO_INFOMSGS so we can see what's wrong. Don't run repair as...

It's definitely a 2005 database, I changed that message for 2005 when I rewrote CHECKDB. Yes, REPAIR_ALLOW_DATA_LOSS will do nothing in this case except remove the orphaned LOB node.

I wouldn't run repair to fix it, as that means the database needs to be in single_user mode. You should just be able to drop and rebuild the XML index...

This table is the internal representation of an XML index. Repair will simply drop and recreate the XML index.

The most interesting question is why this happened in the first place,...

Yup - this database looks like it will suffer a lot of lost data if you run REPAIR_ALLOW_DATA_LOSS or try to repair the broken GAM pag with undocumented options. From...

Do you know if the database was shutdown cleanly? i.e. were there any active transactions when the database was shutdown? If not, you should be able to hack it back...

Although I'm guessing the answer is no, I'll still suggest it - do you have backups you can restore from?

Well, without knowing something about the app that's using the database it's hard to say which object has corrupt metadata - and how the corruption happened. The only way to...

Ah - forget everything I said above then. Do you have any SQL Server backups at all? And old is the .ndf copy you have?

As long as you're in the FULL recovery model, this should be simple.

1) set the file to be offline using ALTER DATABASE dbname MODIFY FILE

2) restore the initial image of...

What about the other object ID that was referenced? Can you tell me the two names, and which object IDs they are? Thanks

Hi Julie,

Replying here rather than to the email you sent - so next time someone has this there's something on Google for them 🙂

The error is saying that an object...

Only if the database was shutdown cleanly Steve - otherwise it won't attach the database and it will have to be hacked into the server (man, I really must do...

If you look at the messages in the error log, you'll see that they're telling you the last time the CHECKDB ran cleanly for each database. This is a new...