February 24, 2004 at 7:01 am
when I do a dbcc checkdb on MSDB, I get error messages 8909 and 8928 ("Table error" and "could not be processed"). Apparently table SYSCOMMENTS is broken, whenever I select * from syscomments, I get Error 823 after a few rows.
Can MSDB be easily rebuilt? What's in there, anyway ?
February 24, 2004 at 7:20 am
Do you have any recent backup?
February 24, 2004 at 7:40 am
Yes, we do have a daily backup. But I don't know when the inconsistency was introduced and I would have to go back month by month until I find a clean copy of the database. I suspect the corrupt table has been in there for quite a while.
So my recent backup does not help. It might be easier to reconstruct the database, since we do not have any high-fly DTS packages. Just a few agent jobs.
But I am not sure what else is kept in MSDB. And I don't know how to start a new MSDB from scratch.
Any ideas ?
February 24, 2004 at 11:27 pm
A quick test would be to restore to a new database using a backup of msdb, this then does not impact on current msdb. Perform your dbcc check on the new database and try this until its clean, at least you will have a known good backup, then decide if it is too old or not. MSDB stores any dts packages you have, any maintenance plans, job history and job details to mention a few things. You could obtain original msdb from install cd and perform recovery using this but then you would lose any of the objects I listed earlier that are stored here.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply