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 |
|
Syed Hussain
Starting Member
2 Posts |
 Posted - 2008-08-15 : 05:20:53
|
| Can someone please tell what is wrong with the following DBCC CHECKDB results?...THANKS!Server: Msg 8909, Level 16, State 1, Line 1Table error: Object ID -1908656216, index ID 28952, page ID (1:1863197). The PageId in the page header = (50305:-501465827).Server: Msg 8909, Level 16, State 1, Line 1Table error: Object ID -911127488, index ID 44025, page ID (1:1863233). The PageId in the page header = (54156:-803176203).CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID -1908656216)' (object ID -1908656216).CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID -911127488)' (object ID -911127488).DBCC results for 'mciw_hds'.DBCC results for 'sysobjects'.There are 1783 rows in 31 pages for object 'sysobjects'.DBCC results for 'sysindexes'.There are 758 rows in 38 pages for object 'sysindexes'.DBCC results for 'syscolumns'.There are 11846 rows in 244 pages for object 'syscolumns'.DBCC results for 'systypes'.There are 41 rows in 1 pages for object 'systypes'.DBCC results for 'syscomments'.There are 1230 rows in 132 pages for object 'syscomments'.DBCC results for 'sysfiles1'.There are 2 rows in 1 pages for object 'sysfiles1'.DBCC results for 'syspermissions'.There are 1196 rows in 7 pages for object 'syspermissions'.DBCC results for 'sysusers'.There are 22 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 7720 rows in 39 pages for object 'sysdepends'.DBCC results for 'sysreferences'.There are 0 rows in 1 pages for object 'sysreferences'.Server: Msg 8909, Level 16, State 1, Line 1Table error: Object ID 757, index ID 7330, page ID (1:120533). The PageId in the page header = (54443:16981101).Server: Msg 8909, Level 16, State 1, Line 1Table error: Object ID 14811362, index ID 8820, page ID (1:1863173). The PageId in the page header = (226:14811362).DBCC results for 'sysfulltextcatalogs'.There are 0 rows in 1 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'.CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID 757)' (object ID 757).DBCC results for 'Network_Trunk_Group_Half_HTmp1'.There are 0 rows in 1 pages for object 'Network_Trunk_Group_Half_HTmp1'.CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID 14811362)' (object ID 14811362).DBCC results for 'Persistent_VariableTmp1'.There are 0 rows in 1 pages for object 'Persistent_VariableTmp1'.DBCC results for 't_Script_Five_Minute'.There are 0 rows in 0 pages for object 't_Script_Five_Minute'.DBCC results for 'Physical_Controller_Half_HTmp1'.There are 0 rows in 1 pages for object 'Physical_Controller_Half_HTmp1'.DBCC results for 't_Enterprise_Route'.There are 0 rows in 0 pages for object 't_Enterprise_Route'.DBCC results for 'Network_Target'.There are 0 rows in 0 pages for object 'Network_Target'.DBCC results for 't_Dialed_Number_Label'.There are 0 rows in 0 pages for object 't_Dialed_Number_Label'.DBCC results for 't_Script_Print_Control'.There are 0 rows in 0 pages for object 't_Script_Print_Control'.DBCC results for 't_Network_Trunk_Group'.There are 0 rows in 0 pages for object 't_Network_Trunk_Group'.DBCC results for 'Route_Five_MinuteTmp1'.There are 0 rows in 1 pages for object 'Route_Five_MinuteTmp1'.DBCC results for 't_Enterprise_Route_Member'.There are 0 rows in 0 pages for object 't_Enterprise_Route_Member'.DBCC results for 't_Dialed_Number_Map'.There are 0 rows in 0 pages for object 't_Dialed_Number_Map'.DBCC results for 'Route_Half_HourTmp1'.There are 0 rows in 1 pages for object 'Route_Half_HourTmp1'.DBCC results for 'Routing_Client_Five_MinuteTmp1'.There are 0 rows in 1 pages for object 'Routing_Client_Five_MinuteTmp1'.DBCC results for 'Vru_Currency'.There are 1 rows in 1 pages for object 'Vru_Currency'.DBCC results for 't_Network_Trunk_Group_Half_Hou'.There are 12966 rows in 139 pages for object 't_Network_Trunk_Group_Half_Hou'.DBCC results for 'Script_Five_MinuteTmp1'.There are 0 rows in 1 pages for object 'Script_Five_MinuteTmp1'.DBCC results for 't_Script_Table'.There are 0 rows in 0 pages for object 't_Script_Table'.DBCC results for 'Service_Five_MinuteTmp1'.There are 0 rows in 1 pages for object 'Service_Five_MinuteTmp1'.DBCC results for 't_Network_Trunk_Group_Real_Tim'.There are 0 rows in 0 pages for object 't_Network_Trunk_Group_Real_Tim'.DBCC results for 'Service_Half_HourTmp1'.There are 0 rows in 1 pages for object 'Service_Half_HourTmp1'.DBCC results for 't_Dialer_Half_Hour'.There are 0 rows in 0 pages for object 't_Dialer_Half_Hour'.DBCC results for 'Skill_Group_Five_MinuteTmp1'.There are 0 rows in 1 pages for object 'Skill_Group_Five_MinuteTmp1'.DBCC results for 't_Script_Table_Column'.There are 0 rows in 0 pages for object 't_Script_Table_Column'.DBCC results for 't_Network_Vru'.There are 0 rows in 0 pages for object 't_Network_Vru'.DBCC results for 't_Campaign_Target_Sequence'.There are 0 rows in 0 pages for object 't_Campaign_Target_Sequence'.DBCC results for 'Skill_Group_Half_HourTmp1'.There are 0 rows in 1 pages for object 'Skill_Group_Half_HourTmp1'.DBCC results for 't_Dialer_Port_Map'.There are 0 rows in 0 pages for object 't_Dialer_Port_Map'.DBCC results for 'Sec_Group'.There are 1 rows in 1 pages for object 'Sec_Group'.DBCC results for 't_Network_Vru_Script'.There are 0 rows in 0 pages for object 't_Network_Vru_Script'.DBCC results for 'Trunk_Group_Five_MinuteTmp1'.There are 0 rows in 1 pages for object 'Trunk_Group_Five_MinuteTmp1'.DBCC results for 't_Dialer_Port_Real_Time'.There are 0 rows in 0 pages for object 't_Dialer_Port_Real_Time'.DBCC results for 't_Agent_Desk_Settings'.There are 0 rows in 0 pages for object 't_Agent_Desk_Settings'.DBCC results for 'Trunk_Group_Half_HourTmp1'.There are 0 rows in 1 pages for object 'Trunk_Group_Half_HourTmp1'.DBCC results for 't_Application_Event'.There are 0 rows in 0 pages for object 't_Application_Event'.DBCC results for 'Sec_User'.There are 1 rows in 1 pages for object 'Sec_User'.DBCC results for 't_Route_Call_Detail'.Server: Msg 2511, Level 16, State 2, Line 1Table error: Object ID 313104206, Index ID 0. Keys out of order on page (1:983964), slots 6 and 7.Server: Msg 8928, Level 16, State 1, Line 1Object ID 313104206, index ID 0: Page (1:1863232) could not be processed. See other errors for details.Server: Msg 8928, Level 16, State 1, Line 1Object ID 313104206, index ID 0: Page (1:1863233) could not be processed. See other errors for details.Server: Msg 8909, Level 16, State 1, Line 1Table error: Object ID 329292509, index ID 16896, page ID (1:1845612). The PageId in the page header = (0:0).There are 35036249 rows in 1445346 pages for object 't_Route_Call_Detail'.CHECKDB found 0 allocation errors and 3 consistency errors in table 't_Route_Call_Detail' (object ID 313104206).DBCC results for 't_Dialer_Real_Time'.There are 0 rows in 0 pages for object 't_Dialer_Real_Time'.CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID 329292509)' (object ID 329292509).DBCC results for 'Next_Available_Number'.There are 75 rows in 1 pages for object 'Next_Available_Number'.DBCC results for 't_Agent_Distribution'.There are 0 rows in 0 pages for object 't_Agent_Distribution'.DBCC results for 'Agent_Skill_Group_Half_HouTmp2'.There are 0 rows in 1 pages for object 'Agent_Skill_Group_Half_HouTmp2'.DBCC results for 'Agent_Skill_Group_LogoutTmp2'.There are 0 rows in 1 pages for object 'Agent_Skill_Group_LogoutTmp2'.DBCC results for 't_Call_Type_Half_Hour'.There are 6670 rows in 283 pages for object 't_Call_Type_Half_Hour'.DBCC results for 't_Object_Access_Xref'.There are 87 rows in 1 pages for object 't_Object_Access_Xref'.DBCC results for 't_Import_Rule'.There are 0 rows in 0 pages for object 't_Import_Rule'.DBCC results for 't_Service_Array'.Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 409104548. The text, ntext, or image node at page (1:8062), slot 6, text ID 190554767360 is not referenced.Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 409104548. The text, ntext, or image node at page (1:8075), slot 11, text ID 190554832896 is not referenced.Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 409104548. The text, ntext, or image node at page (1:118234), slot 0, text ID 190596317184 is not referenced.Server: Msg 8928, Level 16, State 1, Line 1Object ID 409104548, index ID 255: Page (1:120533) could not be processed. See other errors for details.Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 409104548. The text, ntext, or image node at page (1:120939), slot 3, text ID 190597365760 is not referenced.Server: Msg 8928, Level 16, State 1, Line 1Object ID 409104548, index ID 255: Page (1:231201) could not be processed. See other errors for details.Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 409104548. The text, ntext, or image node at page (1:231207), slot 4, text ID 190554701824 is not referenced.Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 409104548. The text, ntext, or image node at page (1:765558), slot 1, text ID 190554570752 is not referenced.There are 0 rows in 0 pages for object 't_Service_Array'.DBCC results for 'Application_Gateway_Half_HTmp2'.There are 0 rows in 1 pages for object 'Application_Gateway_Half_HTmp2'.DBCC results for 't_Event'.There are 131834 rows in 4255 pages for object 't_Event'.CHECKDB found 0 allocation errors and 8 consistency errors in table 't_Event' (object ID 409104548).DBCC results for 't_Object_List'.There are 43 rows in 1 pages for object 't_Object_List'.DBCC results for 't_Media_Routing_Domain'.There are 1 rows in 1 pages for object 't_Media_Routing_Domain'.DBCC results for 't_Routing_Client'.There are 0 rows in 0 pages for object 't_Routing_Client'.Server: Msg 8928, Level 16, State 1, Line 1Object ID 441104662, index ID 0: Page (1:1863173) could not be processed. See other errors for details.Server: Msg 8928, Level 16, State 1, Line 1Object ID 441104662, index ID 0: Page (1:1863174) could not be processed. See other errors for details.Server: Msg 8944, Level 16, State 1, Line 1Table error: Object ID 441104662, index ID 0, page (1:1863174), row 12. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 58406 and 2963.Server: Msg 8909, Level 16, State 1, Line 1Table error: Object ID 487333132, index ID 7436, page ID (1:231201). The PageId in the page header = (7436:487333132).DBCC results for 't_Enterprise_Service'.There are 0 rows in 0 pages for object 't_Enterprise_Service'.DBCC results for 'Campaign_Query_Rule_Half_HTmp2'.There are 0 rows in 1 pages for object 'Campaign_Query_Rule_Half_HTmp2'.DBCC results for 't_Termination_Call_Detail'.There are 17014223 rows in 758879 pages for object 't_Termination_Call_Detail'.CHECKDB found 0 allocation errors and 3 consistency errors in table 't_Termination_Call_Detail' (object ID 441104662).DBCC results for 't_Service_Array_Member'.There are 0 rows in 0 pages for object 't_Service_Array_Member'.DBCC results for 'Dialer_Half_HourTmp2'.There are 0 rows in 1 pages for object 'Dialer_Half_HourTmp2'.DBCC results for 't_Object_Security'.There are 0 rows in 0 pages for object 't_Object_Security'.DBCC results for 't_Service_Five_Minute'.There are 0 rows in 0 pages for object 't_Service_Five_Minute'.DBCC results for 't_Enterprise_Service_Member'.There are 0 rows in 0 pages for object 't_Enterprise_Service_Member'.CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID 487333132)' (object ID 487333132).DBCC results for 'Galaxy_Agent_Call_CountTmp2'.There are 0 rows in 1 pages for object 'Galaxy_Agent_Call_CountTmp2'.DBCC results for 't_Peripheral'.There are 0 rows in 0 pages for object 't_Peripheral'.DBCC results for 'Galaxy_Agent_IGroupTmp2'.There are 0 rows in 1 pages for object 'Galaxy_Agent_IGroupTmp2'.DBCC results for 't_Enterprise_Skill_Group'.There are 0 rows in 0 pages for object 't_Enterprise_Skill_Group'.DBCC results for 't_Agent_Skill_Group_Half_Hour'.There are 0 rows in 0 pages for object 't_Agent_Skill_Group_Half_Hour'.DBCC results for 'Galaxy_Agent_PerformanceTmp2'.There are 0 rows in 1 pages for object 'Galaxy_Agent_PerformanceTmp2'.DBCC results for 't_Service_Half_Hour'.There are 201909 rows in 11704 pages for object 't_Service_Half_Hour'.DBCC results for 'Galaxy_AlarmTmp2'.There are 0 rows in 1 pages for object 'Galaxy_AlarmTmp2'.DBCC results for 't_Person'.There are 0 rows in 0 pages for object 't_Person'.DBCC results for 'Agent_Event_DetailTmp1'.There are 0 rows in 0 pages for object 'Agent_Event_DetailTmp1'.DBCC results for 't_Agent_Half_Hour'.There are 0 rows in 0 pages for object 't_Agent_Half_Hour'.DBCC results for 'Galaxy_DNISTmp2'.There are 0 rows in 1 pages for object 'Galaxy_DNISTmp2'.DBCC results for 'Agent_Event_DetailTmp2'.There are 0 rows in 0 pages for object 'Agent_Event_DetailTmp2'.DBCC results for 't_Enterprise_Skill_Group_Membe'.There are 0 rows in 0 pages for object 't_Enterprise_Skill_Group_Membe'.DBCC results for 't_Agent_Skill_Group_Logout'.There are 0 rows in 0 pages for object 't_Agent_Skill_Group_Logout'.DBCC results for 'Galaxy_GateTmp2'.There are 0 rows in 1 pages for object 'Galaxy_GateTmp2'.DBCC results for 'Application_EventTmp1'.There are 0 rows in 0 pages for object 'Application_EventTmp1'.DBCC results for 't_Service_Member'.There are 0 rows in 0 pages for object 't_Service_Member'.DBCC results for 'Galaxy_Gate_Delayed_CallTmp2'.There are 0 rows in 1 pages for object 'Galaxy_Gate_Delayed_CallTmp2'.DBCC results for 'Application_EventTmp2'.There are 0 rows in 0 pages for object 'Application_EventTmp2'.DBCC results for 'Agent_Half_HourTmp1'.There are 0 rows in 1 pages for object 'Agent_Half_HourTmp1'.DBCC results for 'Galaxy_OverflowTmp2'.There are 0 rows in 1 pages for object 'Galaxy_OverflowTmp2'.DBCC results for 'Vru_Defaults'.There are 1 rows in 1 pages for object 'Vru_Defaults'.DBCC results for 'Call_Type_Half_HourTmp1'.There are 0 rows in 0 pages for object 'Call_Type_Half_HourTmp1'.DBCC results for 'Agent_Half_HourTmp2'.There are 0 rows in 1 pages for object 'Agent_Half_HourTmp2'.DBCC results for 't_Agent_Skill_Group_Real_Time'.There are 0 rows in 0 pages for object 't_Agent_Skill_Group_Real_Time'.DBCC results for 'Galaxy_PBXTmp2'.There are 0 rows in 1 pages for object 'Galaxy_PBXTmp2'.DBCC results for 'Call_Type_Half_HourTmp2'.There are 0 rows in 0 pages for object 'Call_Type_Half_HourTmp2'.DBCC results for 't_Agent_Logout'.There are 0 rows in 0 pages for object 't_Agent_Logout'.DBCC results for 'Galaxy_Single_TrunkTmp2'.There are 0 rows in 1 pages for object 'Galaxy_Single_TrunkTmp2'.DBCC results for 'EventTmp2'.There are 0 rows in 0 pages for object 'EventTmp2'.DBCC results for 'Shift'.There are 1 rows in 1 pages for object 'Shift'.DBCC results for 't_Peripheral_Monitor'.There are 0 rows in 0 pages for object 't_Peripheral_Monitor'.DBCC results for 'Galaxy_Transaction_CodeTmp2'.There are 0 rows in 1 pages for object 'Galaxy_Transaction_CodeTmp2'.DBCC results for 'Logger_Admin'.There are 3570 rows in 52 pages for object 'Logger_Admin'.DBCC results for 'Blended_Agent_Options'.There are 1 rows in 1 pages for object 'Blended_Agent_Options'.DBCC results for 'Galaxy_Trunk_Call_CountTmp2'.There are 0 rows in 1 pages for object 'Galaxy_Trunk_Call_CountTmp2'.DBCC results for 'EventTmp1'.There are 0 rows in 0 pages for object 'EventTmp1'.DBCC results for 'Agent_LogoutTmp1'.There are 0 rows in 1 pages for object 'Agent_LogoutTmp1'.DBCC results for 'Galaxy_Trunk_IGroupTmp2'.There are 0 rows in 1 pages for object 'Galaxy_Trunk_IGroupTmp2'.DBCC results for 'License_Definition'.There are 57 rows in 1 pages for object 'License_Definition'.DBCC results for 'Agent_LogoutTmp2'.There are 0 rows in 1 pages for object 'Agent_LogoutTmp2'.DBCC results for 't_Agent_Team'.There are 0 rows in 0 pages for object 't_Agent_Team'.DBCC results for 't_Peripheral_Target'.There are 0 rows in 0 pages for object 't_Peripheral_Target'.DBCC results for 'Logger_MetersTmp2'.There are 0 rows in 1 pages for object 'Logger_MetersTmp2'.DBCC results for 'ICR_Globals'.There are 1 rows in 1 pages for object 'ICR_Globals'.DBCC results for 't_Skill_Group_Five_Minute'.There are 0 rows in 0 pages for object 't_Skill_Group_Five_Minute'.DBCC results for 't_Agent_Team_Member'.There are 0 rows in 0 pages for object 't_Agent_Team_Member'.DBCC results for 'Network_Trunk_Group_Half_HTmp2'.There are 0 rows in 1 pages for object 'Network_Trunk_Group_Half_HTmp2'.DBCC results for 't_Script_Data'.There are 0 rows in 0 pages for object 't_Script_Data'.DBCC results for 'Route_Call_DetailTmp1'.There are 0 rows in 0 pages for object 'Route_Call_DetailTmp1'.DBCC results for 't_Persistent_Variable'.There are 0 rows in 0 pages for object 't_Persistent_Variable'.DBCC results for 'Region_Prefix'.There are 0 rows in 0 pages for object 'Region_Prefix'.DBCC results for 't_Galaxy_Agent_Call_Count'.There are 0 rows in 1 pages for object 't_Galaxy_Agent_Call_Count'.DBCC results for 'Persistent_VariableTmp2'.There are 0 rows in 1 pages for object 'Persistent_VariableTmp2'.DBCC results for 't_Script_Real_Time'.There are 0 rows in 0 pages for object 't_Script_Real_Time'.DBCC results for 't_Skill_Group_Half_Hour'.There are 0 rows in 0 pages for object 't_Skill_Group_Half_Hour'.DBCC results for 't_Agent_Team_Supervisor'.There are 0 rows in 0 pages for object 't_Agent_Team_Supervisor'.DBCC results for 'Physical_Controller_Half_HTmp2'.There are 0 rows in 1 pages for object 'Physical_Controller_Half_HTmp2'.DBCC results for 't_Physical_Controller_Half_Hou'.There are 12966 rows in 79 pages for object 't_Physical_Controller_Half_Hou'.DBCC results for 't_Admin_Script_Schedule_Map'.There are 0 rows in 0 pages for object 't_Admin_Script_Schedule_Map'.DBCC results for 'Route_Call_DetailTmp2'.There are 0 rows in 0 pages for object 'Route_Call_DetailTmp2'.DBCC results for 't_Application_Path_Real_Time'.There are 0 rows in 0 pages for object 't_Application_Path_Real_Time'.DBCC results for 't_Galaxy_Agent_IGroup'.There are 0 rows in 1 pages for object 't_Galaxy_Agent_IGroup'.DBCC results for 't_Announcement'.There are 0 rows in 0 pages for object 't_Announcement'.DBCC results for 'Schedule_ImportTmp1'.There are 0 rows in 0 pages for object 'Schedule_ImportTmp1'.DBCC results for 't_Skill_Group_Member'.There are 0 rows in 0 pages for object 't_Skill_Group_Member'.DBCC results for 'Route_Five_MinuteTmp2'.There are 0 rows in 1 pages for object 'Route_Five_MinuteTmp2'.DBCC results for 't_Agent_State_Trace'.There are 0 rows in 0 pages for object 't_Agent_State_Trace'.DBCC results for 'Schedule_ImportTmp2'.There are 0 rows in 0 pages for object 'Schedule_ImportTmp2'.DBCC results for 't_Call_Type_Real_Time'.There are 0 rows in 0 pages for object 't_Call_Type_Real_Time'.DBCC results for 't_Physical_Interface_Controlle'.There are 0 rows in 0 pages for object 't_Physical_Interface_Controlle'.DBCC results for 'Route_Half_HourTmp2'.There are 0 rows in 1 pages for object 'Route_Half_HourTmp2'.DBCC results for 'Termination_Call_DetailTmp1'.There are 0 rows in 0 pages for object 'Termination_Call_DetailTmp1'.DBCC results for 't_Skill_Group_Real_Time'.There are 0 rows in 0 pages for object 't_Skill_Group_Real_Time'.DBCC results for 't_Galaxy_Agent_Performance'.There are 0 rows in 1 pages for object 't_Galaxy_Agent_Performance'.DBCC results for 'Routing_Client_Five_MinuteTmp2'.There are 0 rows in 1 pages for object 'Routing_Client_Five_MinuteTmp2'.DBCC results for 'Termination_Call_DetailTmp2'.There are 0 rows in 0 pages for object 'Termination_Call_DetailTmp2'.DBCC results for 'Agent_State_TraceTmp1'.There are 0 rows in 1 pages for object 'Agent_State_TraceTmp1'.DBCC results for 't_Agent_Event_Detail'.There are 0 rows in 0 pages for object 't_Agent_Event_Detail'.DBCC results for 'Skill_Target'.There are 0 rows in 0 pages for object 'Skill_Target'.DBCC results for 't_Query_Rule'.There are 0 rows in 0 pages for object 't_Query_Rule'.DBCC results for 'Script_Five_MinuteTmp2'.There are 0 rows in 1 pages for object 'Script_Five_MinuteTmp2'.DBCC results for 'Agent_State_TraceTmp2'.There are 0 rows in 1 pages for object 'Agent_State_TraceTmp2'.DBCC results for 't_Galaxy_Alarm'.There are 0 rows in 1 pages for object 't_Galaxy_Alarm'.DBCC results for 'Service_Five_MinuteTmp2'.There are 0 rows in 1 pages for object 'Service_Five_MinuteTmp2'.DBCC results for 't_Network_Event_Detail'.There are 0 rows in 0 pages for object 't_Network_Event_Detail'.DBCC results for 't_Application_Gateway'.There are 0 rows in 0 pages for object 't_Application_Gateway'.DBCC results for 'Service_Half_HourTmp2'.There are 0 rows in 1 pages for object 'Service_Half_HourTmp2'.DBCC results for 't_Agent_Targeting_Rule'.There are 0 rows in 0 pages for object 't_Agent_Targeting_Rule'.DBCC results for 't_Query_Rule_Clause'.There are 0 rows in 0 pages for object 't_Query_Rule_Clause'.DBCC results for 'Skill_Group_Five_MinuteTmp2'.There are 0 rows in 1 pages for object 'Skill_Group_Five_MinuteTmp2'.DBCC results for 'Network_Event_DetailTmp1'.There are 0 rows in 1 pages for object 'Network_Event_DetailTmp1'.DBCC results for 't_Galaxy_DNIS'.There are 0 rows in 1 pages for object 't_Galaxy_DNIS'.DBCC results for 'Skill_Group_Half_HourTmp2'.There are 0 rows in 1 pages for object 'Skill_Group_Half_HourTmp2'.DBCC results for 'Network_Event_DetailTmp2'.There are 0 rows in 1 pages for object 'Network_Event_DetailTmp2'.DBCC results for 't_Agent'.There are 0 rows in 0 pages for object 't_Agent'.DBCC results for 't_Application_Gateway_Connecti'.There are 0 rows in 0 pages for object 't_Application_Gateway_Connecti'.DBCC results for 't_Peripheral_Real_Time'.There are 0 rows in 0 pages for object 't_Peripheral_Real_Time'.DBCC results for 't_Galaxy_Gate'.There are 0 rows in 1 pages for object 't_Galaxy_Gate'.DBCC results for 't_Application_Gateway_Globals'.There are 0 rows in 0 pages for object 't_Application_Gateway_Globals'.DBCC results for 'Trunk_Group_Five_MinuteTmp2'.There are 0 rows in 1 pages for object 'Trunk_Group_Five_MinuteTmp2'.DBCC results for 't_Translation_Route'.There are 0 rows in 0 pages for object 't_Translation_Route'.DBCC results for 'Trunk_Group_Half_HourTmp2'.There are 0 rows in 1 pages for object 'Trunk_Group_Half_HourTmp2'.DBCC results for 't_Agent_Targeting_Rule_Member'.There are 0 rows in 0 pages for object 't_Agent_Targeting_Rule_Member'.DBCC results for 't_Application_Gateway_Half_Hou'.There are 1441 rows in 16 pages for object 't_Application_Gateway_Half_Hou'.DBCC results for 'Region'.There are 0 rows in 0 pages for object 'Region'.DBCC results for 't_Galaxy_Gate_Delayed_Call'.There are 0 rows in 1 pages for object 't_Galaxy_Gate_Delayed_Call'.DBCC results for 't_Agent_Targeting_Rule_Range'.There are 0 rows in 0 pages for object 't_Agent_Targeting_Rule_Range'.DBCC results for 't_Trunk'.There are 0 rows in 0 pages for object 't_Trunk'.DBCC results for 't_Route_Real_Time'.There are 0 rows in 0 pages for object 't_Route_Real_Time'.DBCC results for 'AWControl'.There are 1 rows in 1 pages for object 'AWControl'.DBCC results for 't_Application_Gateway_License'.There are 0 rows in 0 pages for object 't_Application_Gateway_License'.DBCC results for 'Region_Info'.There are 0 rows in 1 pages for object 'Region_Info'.DBCC results for 't_Galaxy_Overflow'.There are 0 rows in 1 pages for object 't_Galaxy_Overflow'.DBCC results for 't_Trunk_Group'.There are 0 rows in 0 pages for object 't_Trunk_Group'.DBCC results for 't_Script_Queue_Real_Time'.There are 0 rows in 0 pages for object 't_Script_Queue_Real_Time'.DBCC results for 'Region_Member'.There are 0 rows in 0 pages for object 'Region_Member'.DBCC results for 't_Business_Entity'.There are 1 rows in 1 pages for object 't_Business_Entity'.DBCC results for 't_Bucket_Intervals'.There are 1 rows in 1 pages for object 't_Bucket_Intervals'.DBCC results for 't_Service_Level_Threshold'.There are 0 rows in 0 pages for object 't_Service_Level_Threshold'.DBCC results for 't_Galaxy_PBX'.There are 0 rows in 1 pages for object 't_Galaxy_PBX'.DBCC results for 't_ICR_Node'.There are 0 rows in 0 pages for object 't_ICR_Node'.DBCC results for 't_Call_Type'.There are 0 rows in 0 pages for object 't_Call_Type'.DBCC results for 't_Trunk_Group_Five_Minute'.There are 0 rows in 0 pages for object 't_Trunk_Group_Five_Minute'.DBCC results for 't_Service_Real_Time'.There are 0 rows in 0 pages for object 't_Service_Real_Time'.DBCC results for 'Import_Rule_HistoryTmp1'.There are 0 rows in 1 pages for object 'Import_Rule_HistoryTmp1'.DBCC results for 'Import_Rule_HistoryTmp2'.There are 0 rows in 1 pages for object 'Import_Rule_HistoryTmp2'.DBCC results for 'Region_View'.There are 0 rows in 0 pages for object 'Region_View'.DBCC results for 't_Galaxy_Single_Trunk'.There are 0 rows in 1 pages for object 't_Galaxy_Single_Trunk'.DBCC results for 't_Import_Log'.Server: Msg 8909, Level 16, State 1, Line 1Table error: Object ID 1294291535, index ID 13106, page ID (1:1863232). The PageId in the page header = (13877:842085433).There are 0 rows in 0 pages for object 't_Import_Log'.DBCC results for 't_Campaign'.There are 0 rows in 0 pages for object 't_Campaign'.DBCC results for 't_Trunk_Group_Half_Hour'.There are 134608 rows in 1415 pages for object 't_Trunk_Group_Half_Hour'.DBCC results for 'Region_View_Member'.There are 0 rows in 0 pages for object 'Region_View_Member'.DBCC results for 't_Galaxy_Transaction_Code'.There are 0 rows in 1 pages for object 't_Galaxy_Transaction_Code'.DBCC results for 'Import_LogTmp1'.There are 0 rows in 1 pages for object 'Import_LogTmp1'.DBCC results for 't_Call_Type_Map'.There are 0 rows in 0 pages for object 't_Call_Type_Map'.DBCC results for 'Import_LogTmp2'.There are 0 rows in 1 pages for object 'Import_LogTmp2'.DBCC results for 't_Campaign_Skill_Group'.There are 0 rows in 0 pages for object 't_Campaign_Skill_Group'.DBCC results for 't_Trunk_Group_Real_Time'.There are 0 rows in 1 pages for object 't_Trunk_Group_Real_Time'.DBCC results for 'Rename'.There are 48 rows in 1 pages for object 'Rename'.DBCC results for 't_Schedule_Source'.There are 0 rows in 0 pages for object 't_Schedule_Source'.DBCC results for 't_Campaign_Query_Rule_Real_Tim'.There are 0 rows in 0 pages for object 't_Campaign_Query_Rule_Real_Tim'.CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID 1294291535)' (object ID 1294291535).DBCC results for 't_Galaxy_Trunk_Call_Count'.There are 0 rows in 1 pages for object 't_Galaxy_Trunk_Call_Count'.DBCC results for 't_User_Formula'.There are 0 rows in 0 pages for object 't_User_Formula'.DBCC results for 't_Route_Call_Variable'.There are 0 rows in 0 pages for object 't_Route_Call_Variable'.DBCC results for 't_ECC_Payload'.There are 0 rows in 0 pages for object 't_ECC_Payload'.DBCC results for 't_Galaxy_Trunk_IGroup'.There are 0 rows in 1 pages for object 't_Galaxy_Trunk_IGroup'.DBCC results for 't_User_Formula_Equation'.There are 0 rows in 0 pages for object 't_User_Formula_Equation'.DBCC results for 't_Application_Instance'.There are 2 rows in 1 pages for object 't_Application_Instance'.DBCC results for 'Route_Call_VariableTmp1'.There are 0 rows in 1 pages for object 'Route_Call_VariableTmp1'.DBCC results for 't_Route'.There are 0 rows in 0 pages for object 't_Route'.DBCC results for 't_Campaign_Query_Rule'.There are 0 rows in 0 pages for object 't_Campaign_Query_Rule'.DBCC results for 'Route_Call_VariableTmp2'.There are 0 rows in 1 pages for object 'Route_Call_VariableTmp2'.DBCC results for 't_Dialer'.There are 0 rows in 0 pages for object 't_Dialer'.DBCC results for 'dtproperties'.There are 0 rows in 1 pages for object 'dtproperties'.DBCC results for 'Group_Security_Control'.There are 0 rows in 1 pages for object 'Group_Security_Control'.DBCC results for 't_Termination_Call_Variable'.There are 0 rows in 0 pages for object 't_Termination_Call_Variable'.DBCC results for 't_Application_Path'.There are 0 rows in 0 pages for object 't_Application_Path'.DBCC results for 't_Campaign_Query_Rule_Half_Hou'.There are 0 rows in 0 pages for object 't_Campaign_Query_Rule_Half_Hou'.DBCC results for 't_ICR_Instance'.There are 1 rows in 1 pages for object 't_ICR_Instance'.DBCC results for 'User_Group_Member'.There are 1 rows in 1 pages for object 'User_Group_Member'.DBCC results for 'Termination_Call_VariableTmp1'.There are 0 rows in 1 pages for object 'Termination_Call_VariableTmp1'.DBCC results for 't_ECC_Payload_Member'.There are 0 rows in 0 pages for object 't_ECC_Payload_Member'.DBCC results for 't_Application_Path_Member'.There are 0 rows in 0 pages for object 't_Application_Path_Member'.DBCC results for 'Termination_Call_VariableTmp2'.There are 0 rows in 1 pages for object 'Termination_Call_VariableTmp2'.DBCC results for 'ICR_Locks'.There are 0 rows in 0 pages for object 'ICR_Locks'.DBCC results for 't_Customer_Options'.There are 0 rows in 0 pages for object 't_Customer_Options'.DBCC results for 't_Dialed_Number'.There are 0 rows in 0 pages for object 't_Dialed_Number'.DBCC results for 'User_Security_Control'.There are 0 rows in 0 pages for object 'User_Security_Control'.DBCC results for 'Cfg_Mngr_App_Snapshot_State'.There are 0 rows in 0 pages for object 'Cfg_Mngr_App_Snapshot_State'.DBCC results for 't_Route_Five_Minute'.There are 0 rows in 0 pages for object 't_Route_Five_Minute'.DBCC results for 'Recovery'.Server: Msg 8928, Level 16, State 1, Line 1Object ID 1550628567, index ID 3: Page (1:1845612) could not be processed. See other errors for details.There are 4796 rows in 66 pages for object 'Recovery'.DBCC results for 'User_Supervisor_Map'.There are 0 rows in 0 pages for object 'User_Supervisor_Map'.DBCC results for 'Cfg_Mngr_Globals'.There are 1 rows in 1 pages for object 'Cfg_Mngr_Globals'.DBCC results for 't_License_File'.There are 0 rows in 0 pages for object 't_License_File'.DBCC results for 'Cfg_Mngr_User_Desktop_Snap'.There are 0 rows in 0 pages for object 'Cfg_Mngr_User_Desktop_Snap'.DBCC results for 't_Route_Half_Hour'.There are 201906 rows in 8188 pages for object 't_Route_Half_Hour'.CHECKDB found 0 allocation errors and 1 consistency errors in table 't_Route_Half_Hour' (object ID 1550628567).DBCC results for 'ICR_View'.There are 0 rows in 0 pages for object 'ICR_View'.DBCC results for 't_User_Variable'.There are 0 rows in 0 pages for object 't_User_Variable'.DBCC results for 't_Expanded_Call_Variable'.There are 10 rows in 1 pages for object 't_Expanded_Call_Variable'.DBCC results for 'Cfg_Mngr_User_Menu'.There are 0 rows in 0 pages for object 'Cfg_Mngr_User_Menu'.DBCC results for 'Ids'.There are 0 rows in 0 pages for object 'Ids'.DBCC results for 't_Agent_Real_Time'.There are 0 rows in 0 pages for object 't_Agent_Real_Time'.DBCC results for 'Version'.There are 1 rows in 1 pages for object 'Version'.DBCC results for 'Cfg_Mngr_User_Settings'.There are 0 rows in 0 pages for object 'Cfg_Mngr_User_Settings'.Server: Msg 8928, Level 16, State 1, Line 1Object ID 1678629023, index ID 0: Page (1:1863196) could not be processed. See other errors for details.Server: Msg 8944, Level 16, State 1, Line 1Table error: Object ID 1678629023, index ID 0, page (1:1863196), row 1. Test (offsetNull >= BASEOFFSET) failed. Values are 0 and 4.Server: Msg 8928, Level 16, State 1, Line 1Object ID 1678629023, index ID 0: Page (1:1863197) could not be processed. See other errors for details.Server: Msg 8928, Level 16, State 1, Line 1Object ID 1678629023, index ID 0: Page (1:1863198) could not be processed. See other errors for details.Server: Msg 8941, Level 16, State 1, Line 1Table error: Object ID 1678629023, index ID 0, page (1:1863198). Test (sorted [i].offset <= m_freeData) failed. Slot 9, offset 0x3487 is invalid.Server: Msg 8928, Level 16, State 1, Line 1Object ID 1678629023, index ID 0: Page (1:1863199) could not be processed. See other errors for details.Server: Msg 8928, Level 16, State 1, Line 1Object ID 1678629023, index ID 0: Page (1:1863243) could not be processed. See other errors for details.DBCC results for 'Cfg_Mngr_View'.There are 0 rows in 0 pages for object 'Cfg_Mngr_View'.DBCC results for 't_License_Real_Time'.There are 0 rows in 0 pages for object 't_License_Real_Time'.DBCC results for 'View_Column'.There are 0 rows in 0 pages for object 'View_Column'.DBCC results for 't_Peripheral_Half_Hour'.There are 41063 rows in 513 pages for object 't_Peripheral_Half_Hour'.DBCC results for 't_Class_Access_Xref'.There are 11 rows in 1 pages for object 't_Class_Access_Xref'.DBCC results for 't_Machine_Info'.There are 0 rows in 0 pages for object 't_Machine_Info'.DBCC results for 'Feature_Control_Set'.There are 0 rows in 0 pages for object 'Feature_Control_Set'.DBCC results for 't_Routing_Client_Five_Minute'.Server: Msg 8944, Level 16, State 4, Line 1Table error: Object ID 1678629023, index ID 0, page (1:1863243), row 8. Test (offsetNull >= BASEOFFSET) failed. Values are 0 and 4.Server: Msg 8928, Level 16, State 1, Line 1Object ID 1678629023, index ID 0: Page (1:1863256) could not be processed. See other errors for details.Server: Msg 8944, Level 16, State 1, Line 1Table error: Object ID 1678629023, index ID 0, page (1:1863256), row 4. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 1917 and 353.Server: Msg 8939, Level 16, State 1, Line 1Table error: Object ID 1695406085, index ID 29440, page (1:1863199). Test (m_slotCnt < MaxSlot) failed. Values are 56341 and 4048.Server: Msg 8939, Level 16, State 1, Line 1Table error: Object ID 1695406085, index ID 29440, page (1:1863199). Test (*(((int*) &m_reservedB) + i) == 0) failed. Values are 1 and -268435456.Server: Msg 8939, Level 16, State 1, Line 1Table error: Object ID 1695406085, index ID 29440, page (1:1863199). Test (!(m_flagBits & PG_ALIGNED4)) failed. Values are 27 and 1695406085.Server: Msg 8939, Level 16, State 1, Line 1Table error: Object ID 1695406085, index ID 29440, page (1:1863199). Test (m_headerVersion == HEADER_7_0) failed. Values are 179 and 1.Server: Msg 8939, Level 16, State 1, Line 1Table error: Object ID 1695406085, index ID 29440, page (1:1863199). Test (m_freeCnt <= PAGESIZE - PAGEHEADSIZE) failed. Values are 35201 and 8096.Server: Msg 8940, Level 16, State 1, Line 1Table error: Object ID 1695406085, index ID 29440, page (1:1863199). Test (IsAligned (m_freeData)) failed. Address 0x1d46 is not aligned.There are 702262 rows in 44373 pages for object 't_Routing_Client_Five_Minute'.CHECKDB found 0 allocation errors and 10 consistency errors in table 't_Routing_Client_Five_Minute' (object ID 1678629023).DBCC results for 'Peripheral_Half_HourTmp1'.There are 0 rows in 1 pages for object 'Peripheral_Half_HourTmp1'.DBCC results for 't_Vru_Port_Map'.There are 0 rows in 0 pages for object 't_Vru_Port_Map'.CHECKDB found 0 allocation errors and 6 consistency errors in table '(Object ID 1695406085)' (object ID 1695406085).DBCC results for 't_Class_List'.There are 5 rows in 1 pages for object 't_Class_List'.DBCC results for 'Peripheral_Half_HourTmp2'.There are 0 rows in 1 pages for object 'Peripheral_Half_HourTmp2'.DBCC results for 't_Network_Vru_Bank'.There are 0 rows in 0 pages for object 't_Network_Vru_Bank'.DBCC results for 'User_Group'.There are 1 rows in 1 pages for object 'User_Group'.DBCC results for 't_Schedule'.There are 0 rows in 0 pages for object 't_Schedule'.DBCC results for 't_Import_Rule_Clause'.There are 0 rows in 0 pages for object 't_Import_Rule_Clause'.DBCC results for 't_NIC_Parameter'.There are 0 rows in 0 pages for object 't_NIC_Parameter'.DBCC results for 't_Class_Security'.There are 1 rows in 1 pages for object 't_Class_Security'.DBCC results for 'Agent_Skill_Group_Half_HouTmp1'.There are 0 rows in 1 pages for object 'Agent_Skill_Group_Half_HouTmp1'.DBCC results for 't_Peripheral_Default_Route'.There are 0 rows in 0 pages for object 't_Peripheral_Default_Route'.DBCC results for 't_Import_Rule_History'.There are 0 rows in 0 pages for object 't_Import_Rule_History'.DBCC results for 't_Customer_Definition'.There are 1 rows in 1 pages for object 't_Customer_Definition'.DBCC results for 'Agent_Skill_Group_LogoutTmp1'.There are 0 rows in 1 pages for object 'Agent_Skill_Group_LogoutTmp1'.DBCC results for 't_ClassID_To_ObjectType'.There are 89 rows in 1 pages for object 't_ClassID_To_ObjectType'.DBCC results for 't_Logical_Interface_Controller'.There are 0 rows in 0 pages for object 't_Logical_Interface_Controller'.DBCC results for 't_Import_Rule_Real_Time'.There are 0 rows in 0 pages for object 't_Import_Rule_Real_Time'.DBCC results for 'Config_Message_Log'.There are 0 rows in 0 pages for object 'Config_Message_Log'.DBCC results for 'Application_Gateway_Half_HTmp1'.There are 0 rows in 1 pages for object 'Application_Gateway_Half_HTmp1'.DBCC results for 't_Schedule_Import_Real_Time'.There are 0 rows in 0 pages for object 't_Schedule_Import_Real_Time'.DBCC results for 't_Import_Schedule'.There are 0 rows in 0 pages for object 't_Import_Schedule'.DBCC results for 'Controller_Time'.There are 1 rows in 1 pages for object 'Controller_Time'.DBCC results for 't_Reason_Code'.There are 4 rows in 1 pages for object 't_Reason_Code'.DBCC results for 'Campaign_Query_Rule_Half_HTmp1'.There are 0 rows in 1 pages for object 'Campaign_Query_Rule_Half_HTmp1'.DBCC results for 't_Schedule_Map'.There are 0 rows in 0 pages for object 't_Schedule_Map'.DBCC results for 'Dialer_Half_HourTmp1'.There are 0 rows in 1 pages for object 'Dialer_Half_HourTmp1'.DBCC results for 't_Label'.There are 0 rows in 0 pages for object 't_Label'.DBCC results for 't_Schedule_Report'.There are 0 rows in 0 pages for object 't_Schedule_Report'.DBCC results for 't_Recurring_Schedule_Map'.There are 0 rows in 0 pages for object 't_Recurring_Schedule_Map'.DBCC results for 'Galaxy_Agent_Call_CountTmp1'.There are 0 rows in 1 pages for object 'Galaxy_Agent_Call_CountTmp1'.DBCC results for 'Galaxy_Agent_IGroupTmp1'.There are 0 rows in 1 pages for object 'Galaxy_Agent_IGroupTmp1'.DBCC results for 't_Logger_Meters'.There are 0 rows in 0 pages for object 't_Logger_Meters'.DBCC results for 't_Schedule_Import'.There are 0 rows in 0 pages for object 't_Schedule_Import'.DBCC results for 'Galaxy_Agent_PerformanceTmp1'.There are 0 rows in 1 pages for object 'Galaxy_Agent_PerformanceTmp1'.DBCC results for 'Vru_Locale'.There are 2 rows in 1 pages for object 'Vru_Locale'.DBCC results for 't_Schedule_Report_Input'.There are 0 rows in 0 pages for object 't_Schedule_Report_Input'.DBCC results for 'Galaxy_AlarmTmp1'.There are 0 rows in 1 pages for object 'Galaxy_AlarmTmp1'.DBCC results for 'Galaxy_DNISTmp1'.There are 0 rows in 1 pages for object 'Galaxy_DNISTmp1'.DBCC results for 'Logger_Type'.There are 0 rows in 1 pages for object 'Logger_Type'.DBCC results for 't_Service'.There are 0 rows in 0 pages for object 't_Service'.DBCC results for 'Galaxy_GateTmp1'.There are 0 rows in 1 pages for object 'Galaxy_GateTmp1'.DBCC results for 'Galaxy_Gate_Delayed_CallTmp1'.There are 0 rows in 1 pages for object 'Galaxy_Gate_Delayed_CallTmp1'.DBCC results for 't_Scheduled_Target'.There are 0 rows in 0 pages for object 't_Scheduled_Target'.DBCC results for 'Galaxy_OverflowTmp1'.There are 0 rows in 1 pages for object 'Galaxy_OverflowTmp1'.DBCC results for 't_Default_Call_Type'.There are 0 rows in 0 pages for object 't_Default_Call_Type'.DBCC results for 'Galaxy_PBXTmp1'.There are 0 rows in 1 pages for object 'Galaxy_PBXTmp1'.DBCC results for 't_Master_Script'.There are 0 rows in 0 pages for object 't_Master_Script'.DBCC results for 't_Skill_Group'.There are 0 rows in 0 pages for object 't_Skill_Group'.DBCC results for 'Galaxy_Single_TrunkTmp1'.There are 0 rows in 1 pages for object 'Galaxy_Single_TrunkTmp1'.DBCC results for 't_Media_Class'.There are 5 rows in 1 pages for object 't_Media_Class'.DBCC results for 't_Scheduled_Target_Real_Time'.There are 0 rows in 0 pages for object 't_Scheduled_Target_Real_Time'.DBCC results for 't_Device_Target'.There are 0 rows in 0 pages for object 't_Device_Target'.DBCC results for 'Galaxy_Transaction_CodeTmp1'.There are 0 rows in 1 pages for object 'Galaxy_Transaction_CodeTmp1'.DBCC results for 'Galaxy_Trunk_Call_CountTmp1'.There are 0 rows in 1 pages for object 'Galaxy_Trunk_Call_CountTmp1'.DBCC results for 't_Script'.There are 0 rows in 0 pages for object 't_Script'.DBCC results for 'Galaxy_Trunk_IGroupTmp1'.There are 0 rows in 1 pages for object 'Galaxy_Trunk_IGroupTmp1'.DBCC results for 'ViewType'.There are 1 rows in 1 pages for object 'ViewType'.DBCC results for 't_Dial_Number_Plan'.There are 0 rows in 0 pages for object 't_Dial_Number_Plan'.DBCC results for 't_Script_Cross_Reference'.There are 0 rows in 0 pages for object 't_Script_Cross_Reference'.DBCC results for 'Logger_MetersTmp1'.There are 0 rows in 1 pages for object 'Logger_MetersTmp1'.CHECKDB found 0 allocation errors and 38 consistency errors in database 'mciw_hds'.repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (mciw_hds ).DBCC execution completed. If DBCC printed error messages, contact your system administrator. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-15 : 08:24:15
|
| You need to post this in Data Corruption Forum. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2008-08-15 : 17:00:30
|
| Do you have a good, recent backup? The recommendation is to repair_allow_data_loss and you never know what you'll wind up losing...Restoring is the ideal solution, if possible. Explore all avenues before allowing data loss. Most errors appear at the index level so rebuilding indexes should clear up a lot of them but I also see some at the table level. Those bother me the most. Perhaps Paul will be online and can give better directions to a clean(er) resolution.Terry |
|
|
|
Syed Hussain
Starting Member
2 Posts |
Posted - 2008-08-16 : 10:01:51
|
| Thanks Terry, above DBCC CHECKDB results are after I had already ran repair_allow_data_loss. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2008-08-17 : 09:08:41
|
| There are corruptions that CheckDB can't repair. If there's any corruption in the system tables (which it looks like you may have), then it is not repairable.Do you have a clean database backup (one from before the corruption started)?--Gail ShawSQL Server MVP |
|
|
|
|
|
|
|
|
Server: Msg 8909, Level 16, State 1, Line 1
Tara KizerMicrosoft MVP for Windows Server System - SQL Server