June 17, 2003 at 8:51 pm
The other day our database integrity check showed an error. I re-ran the job and the errors persist. Here's the relevant section of the output log. The question is what can I do about it (Delete msdb?!)
>>>>>
DBCC results for 'msdb'.
DBCC results for 'sysobjects'.
...
...
DBCC results for 'UmlNote'.
There are 0 rows in 0 pages for object 'UmlNote'.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 194099732, index ID 0: Page (1:3803) could not be
processed. See other errors for details.Server: Msg 8944, Level 16, State 1,
Line 1
Table error: Object ID 194099732, index ID 0, page (1:3803),
row 16. Test (columnOffsets->offTbl [varColumnNumber] <=
(nextRec - pRec)) failed. Values are 340 and 338.
...
...
There are 0 rows in 0 pages for object 'log_shipping_plans'.
CHECKDB found 0 allocation errors and 2 consistency errors in database 'msdb'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC
CHECKDB (msdb ).
DBCC execution completed. If DBCC printed error messages, contact your system
administrator.
>>>>>
June 18, 2003 at 1:36 am
First of all if you have a recent backup of your msdb which does not contain the error it might be the best to restore that backup.
In the case that restoring a backup is not an option try running DBCC CHECKDB (msdb,REPAIR_REBUILD')or one of the other repair options (see BOL). I've had similiar errors a couple of times and usually DBCC CHECKDB is able to fix it, but you might have to run several times before all errors are repaired.
[font="Verdana"]Markus Bohse[/font]
June 18, 2003 at 6:10 am
UMLNOTE? Is that a user-created table in msdb? I've never heard of it. Do you know what it's for? Maybe it can be simply dropped to eliminate the errors.
Cheers,
- Mark
June 18, 2003 at 8:11 pm
usually a dbcc dbreindex command will resolve the issue. error probably is with the clustered index as indicated by indexID 0. look for the name of the index on sysindexes or using the sp_help table_name and run this command:
dbccc dbreindex(table_name, index_name).
hope this help
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply