|
dwalker79
Yak Posting Veteran
54 Posts |
 Posted - 2008-08-11 : 10:13:41
|
| Hello,We just physically moved some of our SQL Server 2000 database servers to a new data center over the weekend. Everything appears to work fine except that we've got some consistancy errors in our MSDB database. Here is the DBCC CHECKDB results. Can anyone tell me if the best option here is to restore the MSDB database? Or is there and easier or more efficient way to fix these errors? This instance is on a two node cluster. Any advice would be greatly appreciated!DBCC results for 'msdb'.DBCC results for 'sysobjects'.There are 455 rows in 9 pages for object 'sysobjects'.DBCC results for 'sysindexes'.There are 266 rows in 12 pages for object 'sysindexes'.DBCC results for 'syscolumns'.There are 3682 rows in 124 pages for object 'syscolumns'.DBCC results for 'systypes'.There are 26 rows in 1 pages for object 'systypes'.DBCC results for 'syscomments'.There are 459 rows in 165 pages for object 'syscomments'.DBCC results for 'sysfiles1'.There are 2 rows in 1 pages for object 'sysfiles1'.DBCC results for 'syspermissions'.There are 218 rows in 1 pages for object 'syspermissions'.DBCC results for 'sysusers'.There are 16 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 2745 rows in 17 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 'sysjobschedules'.There are 38 rows in 1 pages for object 'sysjobschedules'.DBCC results for 'RTblIfaceMem'.There are 1189 rows in 9 pages for object 'RTblIfaceMem'.DBCC results for 'backupfile'.There are 461426 rows in 7552 pages for object 'backupfile'.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 'RTblWorkspaceItems'.There are 0 rows in 0 pages for object 'RTblWorkspaceItems'.DBCC results for 'restorehistory'.There are 4 rows in 1 pages for object 'restorehistory'.DBCC results for 'systargetservergroups'.There are 0 rows in 0 pages for object 'systargetservergroups'.DBCC results for 'RTblDatabaseVersion'.There are 1 rows in 1 pages for object 'RTblDatabaseVersion'.DBCC results for 'systargetservergroupmembers'.There are 0 rows in 0 pages for object 'systargetservergroupmembers'.DBCC results for 'sysalerts'.There are 9 rows in 1 pages for object 'sysalerts'.DBCC results for 'RTblDTSProps'.There are 0 rows in 0 pages for object 'RTblDTSProps'.DBCC results for 'RTblVersionAdminInfo'.There are 2333 rows in 30 pages for object 'RTblVersionAdminInfo'.DBCC results for 'restorefile'.There are 8 rows in 1 pages for object 'restorefile'.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 'RTblParameterDef'.There are 136 rows in 1 pages for object 'RTblParameterDef'.DBCC results for 'restorefilegroup'.There are 4 rows in 1 pages for object 'restorefilegroup'.DBCC results for 'systaskids'.Server: Msg 2534, Level 16, State 1, Line 1Table error: Page (1:42635) with object ID 258099960, index ID 255 in its header is allocated by another object.Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 258099960. The text, ntext, or image node at page (1:42635), slot 0, text ID 13443334144 is not referenced.Server: Msg 8935, Level 16, State 1, Line 1Table error: Object ID 2073058421, index ID 1. The previous link (1:37730) on page (1:28169) does not match the previous page (1:37709) that the parent (1:485), slot 182 expects for this page.Server: Msg 8936, Level 16, State 1, Line 1Table error: Object ID 2073058421, index ID 1. B-tree chain linkage mismatch. (1:37709)->next = (1:28169), but (1:28169)->Prev = (1:37730).Server: Msg 8935, Level 16, State 1, Line 1Table error: Object ID 2073058421, index ID 1. The previous link (1:38625) on page (1:35652) does not match the previous page (1:35649) that the parent (1:485), slot 179 expects for this page.Server: Msg 8934, Level 16, State 1, Line 1Table error: Object ID 2073058421, index ID 1. The high key value on page (1:38625) (level 0) is not less than the low key value in the parent (0:1), slot 0 of the next page (1:35652).There are 0 rows in 0 pages for object 'systaskids'.DBCC results for 'syscachedcredentials'.There are 0 rows in 1 pages for object 'syscachedcredentials'.DBCC results for 'RTblIfaceHier'.There are 3349 rows in 18 pages for object 'RTblIfaceHier'.DBCC results for 'logmarkhistory'.There are 0 rows in 0 pages for object 'logmarkhistory'.DBCC results for 'RTblNamedObj'.There are 2196 rows in 22 pages for object 'RTblNamedObj'.DBCC results for 'sysdtscategories'.There are 3 rows in 1 pages for object 'sysdtscategories'.DBCC results for 'RTblClassExtension'.There are 69 rows in 1 pages for object 'RTblClassExtension'.DBCC results for 'sysdtspackages'.There are 181 rows in 12 pages for object 'sysdtspackages'.CHECKDB found 0 allocation errors and 2 consistency errors in table 'sysdtspackages' (object ID 258099960).DBCC results for 'dtproperties'.There are 0 rows in 0 pages for object 'dtproperties'.DBCC results for 'RTblTypeInfo'.There are 0 rows in 0 pages for object 'RTblTypeInfo'.DBCC results for 'sysdtspackagelog'.There are 0 rows in 0 pages for object 'sysdtspackagelog'.DBCC results for 'RTblScriptDefs'.There are 0 rows in 0 pages for object 'RTblScriptDefs'.DBCC results for 'RTblOLPProps'.There are 0 rows in 0 pages for object 'RTblOLPProps'.DBCC results for 'sysdtssteplog'.There are 0 rows in 0 pages for object 'sysdtssteplog'.DBCC results for 'RTblEnumerationDef'.There are 0 rows in 0 pages for object 'RTblEnumerationDef'.DBCC results for 'sysdtstasklog'.There are 0 rows in 0 pages for object 'sysdtstasklog'.DBCC results for 'RTblSumInfo'.There are 0 rows in 0 pages for object 'RTblSumInfo'.DBCC results for 'RTblMDSProps'.There are 0 rows in 0 pages for object 'RTblMDSProps'.DBCC results for 'RTblEnumerationValueDef'.There are 0 rows in 0 pages for object 'RTblEnumerationValueDef'.DBCC results for 'RTblUMLProps'.There are 0 rows in 0 pages for object 'RTblUMLProps'.DBCC results for 'sysdbmaintplans'.There are 1 rows in 1 pages for object 'sysdbmaintplans'.DBCC results for 'sysdbmaintplan_jobs'.There are 0 rows in 0 pages for object 'sysdbmaintplan_jobs'.DBCC results for 'RTblUMXProps'.There are 0 rows in 0 pages for object 'RTblUMXProps'.DBCC results for 'sysdbmaintplan_databases'.There are 0 rows in 0 pages for object 'sysdbmaintplan_databases'.DBCC results for 'RTblSIMProps'.There are 0 rows in 0 pages for object 'RTblSIMProps'.DBCC results for 'sysdbmaintplan_history'.There are 0 rows in 0 pages for object 'sysdbmaintplan_history'.DBCC results for 'RTblGENProps'.There are 0 rows in 0 pages for object 'RTblGENProps'.DBCC results for 'RTblDTMProps'.There are 0 rows in 0 pages for object 'RTblDTMProps'.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 'RTblDBMProps'.There are 0 rows in 0 pages for object 'RTblDBMProps'.DBCC results for 'RTblEQMProps'.There are 0 rows in 0 pages for object 'RTblEQMProps'.DBCC results for 'log_shipping_monitor'.There are 0 rows in 0 pages for object 'log_shipping_monitor'.DBCC results for 'mswebtasks'.There are 0 rows in 0 pages for object 'mswebtasks'.DBCC results for 'log_shipping_databases'.There are 0 rows in 0 pages for object 'log_shipping_databases'.DBCC results for 'log_shipping_plans'.There are 0 rows in 0 pages for object 'log_shipping_plans'.DBCC results for 'RTblVersions'.There are 2333 rows in 27 pages for object 'RTblVersions'.DBCC results for 'log_shipping_plan_databases'.There are 0 rows in 0 pages for object 'log_shipping_plan_databases'.DBCC results for 'log_shipping_plan_history'.There are 0 rows in 0 pages for object 'log_shipping_plan_history'.DBCC results for 'RTblDBXProps'.There are 0 rows in 0 pages for object 'RTblDBXProps'.DBCC results for 'RTblRelships'.There are 6922 rows in 146 pages for object 'RTblRelships'.DBCC results for 'RTblSites'.There are 44 rows in 1 pages for object 'RTblSites'.DBCC results for 'RTblProps'.There are 393 rows in 3 pages for object 'RTblProps'.DBCC results for 'RTblRelshipProps'.There are 28 rows in 1 pages for object 'RTblRelshipProps'.DBCC results for 'RTblPropDefs'.There are 797 rows in 10 pages for object 'RTblPropDefs'.DBCC results for 'RTblRelColDefs'.There are 320 rows in 4 pages for object 'RTblRelColDefs'.DBCC results for 'RTblIfaceDefs'.There are 453 rows in 5 pages for object 'RTblIfaceDefs'.DBCC results for 'backupmediaset'.There are 7953 rows in 83 pages for object 'backupmediaset'.DBCC results for 'sqlagent_info'.There are 0 rows in 0 pages for object 'sqlagent_info'.DBCC results for 'RTblClassDefs'.There are 537 rows in 5 pages for object 'RTblClassDefs'.DBCC results for 'sysdownloadlist'.There are 0 rows in 0 pages for object 'sysdownloadlist'.DBCC results for 'backupmediafamily'.There are 7953 rows in 78 pages for object 'backupmediafamily'.DBCC results for 'sysjobhistory'.There are 1775 rows in 251 pages for object 'sysjobhistory'.CHECKDB found 0 allocation errors and 4 consistency errors in table 'sysjobhistory' (object ID 2073058421).DBCC results for 'sysjobs'.There are 38 rows in 2 pages for object 'sysjobs'.DBCC results for 'RTblTFMProps'.There are 0 rows in 0 pages for object 'RTblTFMProps'.Server: Msg 2533, Level 16, State 1, Line 1Table error: Page (1:42635) allocated to object ID 2117582582, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.Server: Msg 8934, Level 16, State 1, Line 1Table error: Object ID 2117582582, index ID 1. The high key value on page (1:21861) (level 0) is not less than the low key value in the parent (0:1), slot 0 of the next page (1:42633).Server: Msg 8977, Level 16, State 1, Line 1Table error: Object ID 2117582582, index ID 1. Parent node for page (1:42633) was not encountered.Server: Msg 8977, Level 16, State 1, Line 1Table error: Object ID 2117582582, index ID 1. Parent node for page (1:42634) was not encountered.Server: Msg 8981, Level 16, State 1, Line 1Table error: Object ID 2117582582, index ID 1. The next pointer of (1:42634) refers to page (1:42635). Neither (1:42635) nor its parent were encountered. Possible bad chain linkage.DBCC results for 'RTblRelshipDefs'.There are 144 rows in 1 pages for object 'RTblRelshipDefs'.DBCC results for 'backupset'.There are 444824 rows in 19114 pages for object 'backupset'.CHECKDB found 0 allocation errors and 5 consistency errors in table 'backupset' (object ID 2117582582).DBCC results for 'sysjobservers'.There are 38 rows in 2 pages for object 'sysjobservers'.DBCC results for 'RTblTypeLibs'.There are 17 rows in 1 pages for object 'RTblTypeLibs'.DBCC results for 'sysjobsteps'.There are 52 rows in 7 pages for object 'sysjobsteps'.CHECKDB found 0 allocation errors and 11 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.Thanks!Dustin |
|
MSDB Errors