Might be time to contact CSS at this point. Those look nasty.

What does the error log say about msdb?

cos_ta393 (5/18/2010)

---

Gail, thanks for your time and input. I have a meeting with my boss on Friday and I will present both recommendations - I will keep you posted. Mainwhile...

Please read through this - Managing Transaction Logs[/url]

Please post new questions in a new thread. Thank you.

Reported that one already.

I just report and trust that Steve (or whoever else picks up the report) will check it out

There's no documented way to read the transaction log.

If you're feeling like a challenge, you can use fn_dblog

SELECT * FROM fn_dblog(null, null)

however it's not the easiest to understand, the...

Just a word of warning. There's no guarantee that this will be repairable, that the database will be attachable at all. Depends on where that corruption is within the file....

Definitely game over. Error indicates that there's damage to the structures that identify the files within the database, it thinks it has a file that it cannot have. That's not...

If it's a SQL 2000 database and it's damaged, I would strongly suggest that you install SQL 2000 and get it attached there (may need hacking in).

By attaching to 2008,...

Sounds like someone may have messed with the system tables back on SQL 2000 and no one caught it. Odd, syskeys isn't even in any of my SQL 2005 database,...

Thanks for the feedback.

I don't think it's the log that's corrupt (or at least not just the log). If it was only the...

jcrawf02 (5/17/2010)

---

GilaMonster (5/17/2010)

---

If that is plagiarised, MS needs to be informed (I know a couple people I can speak to there), seeing as that is an MSDN blog.

Note that...

If that is plagiarised, MS needs to be informed (I know a couple people I can speak to there), seeing as that is an MSDN blog.

Note that there's some...