Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vandals81
Starting Member
6 Posts |
 Posted - 2007-07-26 : 15:43:16
|
| When I try to delete a job from Enterprise Manager Console I get the following error:Erro 644: Could not find the index entry for RID '163bd10000010000' in index page (1:553), index ID 0 database 'msdb'Oh and this is on MSDE.Here is my complete output of DBCC CHECKDBDBCC results for 'msdb'.DBCC results for 'sysobjects'.There are 280 rows in 6 pages for object 'sysobjects'.DBCC results for 'sysindexes'.There are 143 rows in 6 pages for object 'sysindexes'.DBCC results for 'syscolumns'.There are 1567 rows in 26 pages for object 'syscolumns'.DBCC results for 'systypes'.There are 26 rows in 1 pages for object 'systypes'.DBCC results for 'syscomments'.There are 357 rows in 108 pages for object 'syscomments'.DBCC results for 'sysfiles1'.There are 2 rows in 1 pages for object 'sysfiles1'.DBCC results for 'syspermissions'.There are 116 rows in 1 pages for object 'syspermissions'.DBCC results for 'sysusers'.There are 13 rows in 1 pages for object 'sysusers'.DBCC results for 'sysproperties'.There are 0 rows in 0 pages for object 'sysproperties'.DBCC results for 'sysdepends'.There are 1635 rows in 8 pages for object 'sysdepends'.DBCC results for 'sysreferences'.There are 12 rows in 1 pages for object 'sysreferences'.DBCC results for 'sysfulltextcatalogs'.There are 0 rows in 0 pages for object 'sysfulltextcatalogs'.DBCC results for 'sysfulltextnotify'.There are 0 rows in 0 pages for object 'sysfulltextnotify'.DBCC results for 'sysfilegroups'.There are 1 rows in 1 pages for object 'sysfilegroups'.DBCC results for 'backupset'.There are 1045 rows in 44 pages for object 'backupset'.DBCC results for 'sysjobschedules'.There are 7 rows in 1 pages for object 'sysjobschedules'.DBCC results for 'syscategories'.There are 19 rows in 1 pages for object 'syscategories'.DBCC results for 'systargetservers'.There are 0 rows in 0 pages for object 'systargetservers'.DBCC results for 'backupfile'.There are 1451 rows in 24 pages for object 'backupfile'.DBCC results for 'systargetservergroups'.There are 0 rows in 0 pages for object 'systargetservergroups'.DBCC results for 'systargetservergroupmembers'.There are 0 rows in 0 pages for object 'systargetservergroupmembers'.DBCC results for 'restorehistory'.There are 1 rows in 1 pages for object 'restorehistory'.DBCC results for 'sysalerts'.There are 9 rows in 1 pages for object 'sysalerts'.DBCC results for 'sysoperators'.There are 0 rows in 0 pages for object 'sysoperators'.DBCC results for 'sysnotifications'.There are 0 rows in 0 pages for object 'sysnotifications'.DBCC results for 'restorefile'.There are 2 rows in 1 pages for object 'restorefile'.DBCC results for 'systaskids'.There are 0 rows in 0 pages for object 'systaskids'.DBCC results for 'syscachedcredentials'.There are 0 rows in 0 pages for object 'syscachedcredentials'.DBCC results for 'restorefilegroup'.There are 1 rows in 1 pages for object 'restorefilegroup'.DBCC results for 'logmarkhistory'.There are 0 rows in 0 pages for object 'logmarkhistory'.DBCC results for 'sysdtscategories'.There are 3 rows in 1 pages for object 'sysdtscategories'.DBCC results for 'sysdtspackages'.There are 0 rows in 0 pages for object 'sysdtspackages'.DBCC results for 'sysdtspackagelog'.There are 0 rows in 0 pages for object 'sysdtspackagelog'.DBCC results for 'sysdtssteplog'.Server: Msg 8935, Level 16, State 1, Line 1Table error: Object ID 2073058421, index ID 1. The previous link (1:343) on page (1:371) does not match the previous page (1:382) that the parent (1:300), slot 32 expects for this page.Server: Msg 8978, Level 16, State 1, Line 1Table error: Object ID 2073058421, index ID 1. Page (1:371) is missing a reference from previous page (1:343). Possible chain linkage problem.There are 0 rows in 0 pages for object 'sysdtssteplog'.DBCC results for 'sysdtstasklog'.There are 0 rows in 0 pages for object 'sysdtstasklog'.DBCC results for 'sysdbmaintplans'.There are 4 rows in 1 pages for object 'sysdbmaintplans'.DBCC results for 'sysdbmaintplan_jobs'.There are 4 rows in 1 pages for object 'sysdbmaintplan_jobs'.DBCC results for 'sysdbmaintplan_databases'.There are 12 rows in 1 pages for object 'sysdbmaintplan_databases'.DBCC results for 'sysdbmaintplan_history'.There are 724 rows in 23 pages for object 'sysdbmaintplan_history'.DBCC results for 'log_shipping_primaries'.There are 0 rows in 0 pages for object 'log_shipping_primaries'.DBCC results for 'log_shipping_secondaries'.There are 0 rows in 0 pages for object 'log_shipping_secondaries'.DBCC results for 'mswebtasks'.There are 0 rows in 0 pages for object 'mswebtasks'.DBCC results for 'sqlagent_info'.There are 0 rows in 0 pages for object 'sqlagent_info'.DBCC results for 'sysdownloadlist'.There are 0 rows in 0 pages for object 'sysdownloadlist'.DBCC results for 'backupmediaset'.There are 1045 rows in 11 pages for object 'backupmediaset'.DBCC results for 'sysjobhistory'.Server: Msg 8935, Level 16, State 1, Line 1Table error: Object ID 2073058421, index ID 1. The previous link (1:382) on page (1:564) does not match the previous page (1:371) that the parent (1:300), slot 33 expects for this page.There are 626 rows in 208 pages for object 'sysjobhistory'.CHECKDB found 0 allocation errors and 3 consistency errors in table 'sysjobhistory' (object ID 2073058421).DBCC results for 'sysjobs'.There are 7 rows in 1 pages for object 'sysjobs'.DBCC results for 'backupmediafamily'.There are 1045 rows in 20 pages for object 'backupmediafamily'.DBCC results for 'sysjobservers'.There are 7 rows in 1 pages for object 'sysjobservers'.DBCC results for 'sysjobsteps'.There are 9 rows in 1 pages for object 'sysjobsteps'.CHECKDB found 0 allocation errors and 3 consistency errors in database 'msdb'.repair_rebuild 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. |
|
|
Kristen
Test
22859 Posts |
|
|
|
|
|
|
|
DBCC CHECKDB is failing on the msdb database