Logic Consistency-based I/o Error. Dbcc Checkdb

Nov 27, 2007

every few days i'm getting an error in the application log , eventID 824, saying 'SQL Server detected a logical consistency-based i/o error; incorrect checksum. it then recommends completing a full database consistency check (dbcc checkdb).

i have run the dbcc checkdb ('databasename') and it is returning an error msg of:

Msg 8697, Level 16, State 215, Line 1
An internal error occurred in DBCC which prevented further processing
Msg 8921, Level 16, State 1, Line 1
Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors

i have oodles of disk space left. any ideas on where to go from here.

thank you for any help,
-Mark

View 3 Replies


ADVERTISEMENT

DBCC CHECKDB Consistency Errors

Mar 14, 2007

Hi all,
Here is my DBCC CHECKDB output. I keep REPAIRing the problem and it keeps coming back. I would love to get rid of the objectID in question, but do not know how, or if that would fix the problem. This is running on a MSDE 2000 SP3a. It is also only the "Events" Table that seems to be affected.

Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 562101043, Index ID 2. Keys out of order on page (1:67702), slots 174 and 175.
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 562101043, Index ID 2. Keys out of order on page (1:67875), slots 246 and 247.
DBCC results for 'AccessControl'.
DBCC results for 'sysobjects'.
There are 1130 rows in 20 pages for object 'sysobjects'.
DBCC results for 'sysindexes'.
There are 1397 rows in 55 pages for object 'sysindexes'.
DBCC results for 'syscolumns'.
There are 3047 rows in 47 pages for object 'syscolumns'.
DBCC results for 'systypes'.
There are 26 rows in 1 pages for object 'systypes'.
DBCC results for 'syscomments'.
There are 572 rows in 52 pages for object 'syscomments'.
DBCC results for 'sysfiles1'.
There are 2 rows in 1 pages for object 'sysfiles1'.
DBCC results for 'syspermissions'.
There are 51 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 1017 rows in 6 pages for object 'sysdepends'.
DBCC results for 'sysreferences'.
There are 13 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 'GLOBAL_IO_LINKAGE'.
There are 0 rows in 0 pages for object 'GLOBAL_IO_LINKAGE'.
DBCC results for 'PANEL_USER_GROUP'.
There are 0 rows in 0 pages for object 'PANEL_USER_GROUP'.
DBCC results for 'PRECACGRP'.
There are 0 rows in 0 pages for object 'PRECACGRP'.
DBCC results for 'GLOBAL_IO_OUTPUT_ACTION'.
There are 0 rows in 0 pages for object 'GLOBAL_IO_OUTPUT_ACTION'.
DBCC results for 'PANEL_USER'.
There are 0 rows in 0 pages for object 'PANEL_USER'.
DBCC results for 'USERS_ACCESSLEVEL_LINK'.
There are 0 rows in 0 pages for object 'USERS_ACCESSLEVEL_LINK'.
DBCC results for 'PRECGRPLINK'.
There are 0 rows in 0 pages for object 'PRECGRPLINK'.
DBCC results for 'EMP_SEGMENT_LINK'.
There are 0 rows in 0 pages for object 'EMP_SEGMENT_LINK'.
DBCC results for 'KNOWHO_SERVER'.
There are 0 rows in 0 pages for object 'KNOWHO_SERVER'.
DBCC results for 'ASSET_MMOBJS'.
There are 0 rows in 0 pages for object 'ASSET_MMOBJS'.
DBCC results for 'GOS_MESSAGE'.
There are 1 rows in 1 pages for object 'GOS_MESSAGE'.
DBCC results for 'QUEUED_EVENTS'.
There are 0 rows in 1 pages for object 'QUEUED_EVENTS'.
DBCC results for 'DDTBL'.
There are 23 rows in 1 pages for object 'DDTBL'.
DBCC results for 'ACCESSLVL_ASSIGNABLE_SEGMENT'.
There are 0 rows in 0 pages for object 'ACCESSLVL_ASSIGNABLE_SEGMENT'.
DBCC results for 'PERSON_DATA_SOURCE'.
There are 6 rows in 1 pages for object 'PERSON_DATA_SOURCE'.
DBCC results for 'IE_BADGE_ACC'.
There are 0 rows in 0 pages for object 'IE_BADGE_ACC'.
DBCC results for 'DEPT'.
There are 1 rows in 1 pages for object 'DEPT'.
DBCC results for 'USER_PERM_REPORT_GROUP_MEMBER'.
There are 0 rows in 0 pages for object 'USER_PERM_REPORT_GROUP_MEMBER'.
DBCC results for 'DEVICE_GROUP'.
There are 3 rows in 1 pages for object 'DEVICE_GROUP'.
DBCC results for 'BADGE_AREA_LOCATION_REPL'.
There are 0 rows in 0 pages for object 'BADGE_AREA_LOCATION_REPL'.
DBCC results for 'ACCTRANS_RESTORED'.
There are 2478 rows in 47 pages for object 'ACCTRANS_RESTORED'.
DBCC results for 'LNL_CERTIFICATE'.
There are 0 rows in 0 pages for object 'LNL_CERTIFICATE'.
DBCC results for 'TRANSMITTER'.
There are 0 rows in 0 pages for object 'TRANSMITTER'.
DBCC results for 'DEVICE_GROUP_LINK'.
There are 186 rows in 1 pages for object 'DEVICE_GROUP_LINK'.
DBCC results for 'ALARM_ACK_ACTION'.
There are 0 rows in 0 pages for object 'ALARM_ACK_ACTION'.
DBCC results for 'ACCTRANS_REPL'.
There are 0 rows in 0 pages for object 'ACCTRANS_REPL'.
DBCC results for 'CERTIFICATE_AUTHORITY'.
There are 0 rows in 0 pages for object 'CERTIFICATE_AUTHORITY'.
DBCC results for 'ACCTRANS'.
There are 22500 rows in 435 pages for object 'ACCTRANS'.
DBCC results for 'DIALUP'.
There are 0 rows in 0 pages for object 'DIALUP'.
DBCC results for 'ICONTYPE_COMMAND'.
There are 3 rows in 1 pages for object 'ICONTYPE_COMMAND'.
DBCC results for 'CARDHOLDER_ACCOUNT'.
There are 0 rows in 0 pages for object 'CARDHOLDER_ACCOUNT'.
DBCC results for 'ACCESSLVL_EXTENDED'.
There are 0 rows in 0 pages for object 'ACCESSLVL_EXTENDED'.
DBCC results for 'RDR_CARDFORMATS'.
There are 0 rows in 0 pages for object 'RDR_CARDFORMATS'.
DBCC results for 'DIVISION'.
There are 1 rows in 1 pages for object 'DIVISION'.
DBCC results for 'MOBILE_VERIFY_GATE'.
There are 0 rows in 0 pages for object 'MOBILE_VERIFY_GATE'.
DBCC results for 'DOWNLOADDB'.
There are 0 rows in 0 pages for object 'DOWNLOADDB'.
DBCC results for 'ACCGPLINK'.
There are 0 rows in 0 pages for object 'ACCGPLINK'.
DBCC results for 'ARCHIVE_SERVER'.
There are 1 rows in 1 pages for object 'ARCHIVE_SERVER'.
DBCC results for 'RDTZCTLIST'.
There are 0 rows in 0 pages for object 'RDTZCTLIST'.
DBCC results for 'ELEVATORHW'.
There are 0 rows in 0 pages for object 'ELEVATORHW'.
DBCC results for 'ACCLVLINK'.
There are 0 rows in 0 pages for object 'ACCLVLINK'.
DBCC results for 'ARCHIVE_SERVER_LOCATION'.
There are 1 rows in 1 pages for object 'ARCHIVE_SERVER_LOCATION'.
DBCC results for 'BDG2TRN'.
There are 0 rows in 0 pages for object 'BDG2TRN'.
DBCC results for 'READER'.
There are 0 rows in 0 pages for object 'READER'.
DBCC results for 'MOBILE_VERIFY_GATE_RDR_LINK'.
There are 0 rows in 0 pages for object 'MOBILE_VERIFY_GATE_RDR_LINK'.
DBCC results for 'TRANSMITTER_INPUT'.
There are 0 rows in 0 pages for object 'TRANSMITTER_INPUT'.
DBCC results for 'EVENT'.
There are 1249 rows in 11 pages for object 'EVENT'.
DBCC results for 'USER_OPTIONS'.
There are 5 rows in 1 pages for object 'USER_OPTIONS'.
DBCC results for 'NV_FIRMWARE_DOWNLOAD_ACTION'.
There are 0 rows in 0 pages for object 'NV_FIRMWARE_DOWNLOAD_ACTION'.
DBCC results for 'READER_ENTRANCE'.
There are 0 rows in 0 pages for object 'READER_ENTRANCE'.
DBCC results for 'TRANSMITTER_LINK'.
There are 0 rows in 0 pages for object 'TRANSMITTER_LINK'.
DBCC results for 'EA_DIAGNOSTIC_CFG'.
There are 0 rows in 0 pages for object 'EA_DIAGNOSTIC_CFG'.
DBCC results for 'NV_FIRMWARE_DOWNLOAD_DEVICE'.
There are 0 rows in 0 pages for object 'NV_FIRMWARE_DOWNLOAD_DEVICE'.
DBCC results for 'READER_ENTRANCE_LOITERING'.
There are 0 rows in 0 pages for object 'READER_ENTRANCE_LOITERING'.
DBCC results for 'RELAYOUTPT'.
There are 0 rows in 0 pages for object 'RELAYOUTPT'.
DBCC results for 'EVENT_GIOFUNCLISTLINK'.
There are 0 rows in 0 pages for object 'EVENT_GIOFUNCLISTLINK'.
DBCC results for 'ACISLOG'.
There are 8 rows in 1 pages for object 'ACISLOG'.
DBCC results for 'VISIT_TYPE'.
There are 1 rows in 1 pages for object 'VISIT_TYPE'.
DBCC results for 'BADGE_EXPECTED_PASSAGE'.
There are 0 rows in 0 pages for object 'BADGE_EXPECTED_PASSAGE'.
DBCC results for 'ALARM'.
There are 1249 rows in 18 pages for object 'ALARM'.
DBCC results for 'EA_RESULTCOL_CFG'.
There are 1 rows in 1 pages for object 'EA_RESULTCOL_CFG'.
DBCC results for 'REPORTCFG'.
There are 126 rows in 5 pages for object 'REPORTCFG'.
DBCC results for 'EVENTGRP'.
There are 1 rows in 1 pages for object 'EVENTGRP'.
DBCC results for 'VISIT_RESTORED'.
There are 0 rows in 0 pages for object 'VISIT_RESTORED'.
DBCC results for 'SNMP_MIB_DATA'.
There are 0 rows in 0 pages for object 'SNMP_MIB_DATA'.
DBCC results for 'ALARMINPUT'.
There are 48 rows in 2 pages for object 'ALARMINPUT'.
DBCC results for 'EA_RESULTCOL_DDFLD_LINK'.
There are 5 rows in 1 pages for object 'EA_RESULTCOL_DDFLD_LINK'.
DBCC results for 'RESISTOR'.
There are 0 rows in 0 pages for object 'RESISTOR'.
DBCC results for 'EVENTGRPLNK'.
There are 316 rows in 2 pages for object 'EVENTGRPLNK'.
DBCC results for 'GOS_EA_ALERT'.
There are 0 rows in 0 pages for object 'GOS_EA_ALERT'.
DBCC results for 'EVENTS_VIDEO_RESTORED'.
There are 0 rows in 0 pages for object 'EVENTS_VIDEO_RESTORED'.
DBCC results for 'SNMP_AGENT'.
There are 0 rows in 0 pages for object 'SNMP_AGENT'.
DBCC results for 'ALARMMASKGROUP'.
There are 0 rows in 0 pages for object 'ALARMMASKGROUP'.
DBCC results for 'USER_LNL_DB_LINK'.
There are 0 rows in 0 pages for object 'USER_LNL_DB_LINK'.
DBCC results for 'SAVEDEVENTS'.
There are 2611 rows in 41 pages for object 'SAVEDEVENTS'.
DBCC results for 'EVENT_PARAM'.
There are 340 rows in 4 pages for object 'EVENT_PARAM'.
DBCC results for 'ACTION_REPLICATOR'.
There are 0 rows in 0 pages for object 'ACTION_REPLICATOR'.
DBCC results for 'OPC_SOURCE'.
There are 0 rows in 0 pages for object 'OPC_SOURCE'.
DBCC results for 'ALARMMASKGROUPLINK'.
There are 0 rows in 0 pages for object 'ALARMMASKGROUPLINK'.
DBCC results for 'AUTO_TOUR_ACTION'.
There are 0 rows in 0 pages for object 'AUTO_TOUR_ACTION'.
DBCC results for 'VERSIT'.
There are 29 rows in 1 pages for object 'VERSIT'.
DBCC results for 'EVENT_TO_EVENT_PARAM_LINK'.
There are 936 rows in 3 pages for object 'EVENT_TO_EVENT_PARAM_LINK'.
DBCC results for 'USER_PTZ_PRIORITY'.
There are 4 rows in 1 pages for object 'USER_PTZ_PRIORITY'.
DBCC results for 'GSC'.
There are 46 rows in 1 pages for object 'GSC'.
DBCC results for 'ALARMPANEL'.
There are 4 rows in 1 pages for object 'ALARMPANEL'.
DBCC results for 'AUTO_TOUR_MONSTATION_LINK'.
There are 0 rows in 0 pages for object 'AUTO_TOUR_MONSTATION_LINK'.
DBCC results for 'ASSET_CLASS'.
There are 0 rows in 0 pages for object 'ASSET_CLASS'.
DBCC results for 'EVENTS'.
There are 3692794 rows in 53947 pages for object 'EVENTS'.
CHECKDB found 0 allocation errors and 2 consistency errors in table 'EVENTS' (object ID 562101043).
DBCC results for 'LNL_DIRECTORY'.
There are 1 rows in 1 pages for object 'LNL_DIRECTORY'.
DBCC results for 'SWEVENT_GUARANTEE'.
There are 0 rows in 0 pages for object 'SWEVENT_GUARANTEE'.
DBCC results for 'DMV'.
There are 29 rows in 1 pages for object 'DMV'.
DBCC results for 'ASSET_GROUP_ASSET_CLASS_LINK'.
There are 0 rows in 0 pages for object 'ASSET_GROUP_ASSET_CLASS_LINK'.
DBCC results for 'PTZ_PRIORITY_LOCK'.
There are 0 rows in 0 pages for object 'PTZ_PRIORITY_LOCK'.
DBCC results for 'ALARMPANELLINKS'.
There are 0 rows in 0 pages for object 'ALARMPANELLINKS'.
DBCC results for 'IVCHANNELCONFIG'.
There are 0 rows in 0 pages for object 'IVCHANNELCONFIG'.
DBCC results for 'EVENTS_GUARANTEE'.
There are 0 rows in 0 pages for object 'EVENTS_GUARANTEE'.
DBCC results for 'CAC'.
There are 41 rows in 1 pages for object 'CAC'.
DBCC results for 'ASSET_ASSET_CLASS_LINK'.
There are 0 rows in 0 pages for object 'ASSET_ASSET_CLASS_LINK'.
DBCC results for 'SEGMENT_GROUP_MEMBER'.
There are 0 rows in 0 pages for object 'SEGMENT_GROUP_MEMBER'.
DBCC results for 'ALARMSACK'.
There are 30309 rows in 239 pages for object 'ALARMSACK'.
DBCC results for 'EVENTS_GUARANTEE_DONE'.
There are 0 rows in 0 pages for object 'EVENTS_GUARANTEE_DONE'.
DBCC results for 'CISCO_AIC_DEVICE'.
There are 0 rows in 0 pages for object 'CISCO_AIC_DEVICE'.
DBCC results for 'CAMERA_PRESET_TOUR'.
There are 0 rows in 0 pages for object 'CAMERA_PRESET_TOUR'.
DBCC results for 'CHASSIS'.
There are 3 rows in 1 pages for object 'CHASSIS'.
DBCC results for 'STAZONLINK'.
There are 4 rows in 1 pages for object 'STAZONLINK'.
DBCC results for 'EVENTS_LASTSERIALNUM'.
There are 44 rows in 1 pages for object 'EVENTS_LASTSERIALNUM'.
DBCC results for 'ALARMSACK_RESTORED'.
There are 0 rows in 0 pages for object 'ALARMSACK_RESTORED'.
DBCC results for 'USER_ACCOUNT'.
There are 23 rows in 4 pages for object 'USER_ACCOUNT'.
DBCC results for 'TWO_MAN_TYPE'.
There are 3 rows in 1 pages for object 'TWO_MAN_TYPE'.
DBCC results for 'PURGE_HISTORYLOGS_ACTION'.
There are 0 rows in 0 pages for object 'PURGE_HISTORYLOGS_ACTION'.
DBCC results for 'CAMERA_PRESET_COMMAND'.
There are 0 rows in 0 pages for object 'CAMERA_PRESET_COMMAND'.
DBCC results for 'LOCKSET_MEMORY'.
There are 1 rows in 1 pages for object 'LOCKSET_MEMORY'.
DBCC results for 'SYSTEMCARDS'.
There are 1 rows in 1 pages for object 'SYSTEMCARDS'.
DBCC results for 'EVENTS_RESTORED'.
There are 0 rows in 0 pages for object 'EVENTS_RESTORED'.
DBCC results for 'ARCHIVE_CONFIG'.
There are 6 rows in 1 pages for object 'ARCHIVE_CONFIG'.
DBCC results for 'SINGLE_DEVICE_ACTION'.
There are 0 rows in 0 pages for object 'SINGLE_DEVICE_ACTION'.
DBCC results for 'SWEVENT_GUARANTEE_DONE'.
There are 0 rows in 0 pages for object 'SWEVENT_GUARANTEE_DONE'.
DBCC results for 'PROCESSORTYPE'.
There are 3 rows in 1 pages for object 'PROCESSORTYPE'.
DBCC results for 'HWTRANS_REPL'.
There are 0 rows in 0 pages for object 'HWTRANS_REPL'.
DBCC results for 'IVPROCESSORS_IN_USE'.
There are 1 rows in 1 pages for object 'IVPROCESSORS_IN_USE'.
DBCC results for 'ARCHIVE_DETAIL'.
There are 29 rows in 1 pages for object 'ARCHIVE_DETAIL'.
DBCC results for 'DEVICE_GROUP_ACTION'.
There are 0 rows in 0 pages for object 'DEVICE_GROUP_ACTION'.
DBCC results for 'EVENTCRITERIA'.
There are 0 rows in 0 pages for object 'EVENTCRITERIA'.
DBCC results for 'WORLDTZ_BAK'.
There are 62 rows in 2 pages for object 'WORLDTZ_BAK'.
DBCC results for 'AREAAPB'.
There are 1 rows in 1 pages for object 'AREAAPB'.
DBCC results for 'MUSTER_INITIATION_ACTION'.
There are 0 rows in 0 pages for object 'MUSTER_INITIATION_ACTION'.
DBCC results for 'TEXT_BASED_EVENTS'.
There are 0 rows in 0 pages for object 'TEXT_BASED_EVENTS'.
DBCC results for 'EVENTS_REPL'.
There are 0 rows in 0 pages for object 'EVENTS_REPL'.
DBCC results for 'SUPPORTED_BIOMETRIC_TYPES'.
There are 0 rows in 0 pages for object 'SUPPORTED_BIOMETRIC_TYPES'.
DBCC results for 'TEXTOBJ'.
There are 1249 rows in 13 pages for object 'TEXTOBJ'.
DBCC results for 'EVENTYPE'.
There are 27 rows in 1 pages for object 'EVENTYPE'.
DBCC results for 'ASSET_TYPE'.
There are 1 rows in 1 pages for object 'ASSET_TYPE'.
DBCC results for 'AREATZCTLIST'.
There are 0 rows in 0 pages for object 'AREATZCTLIST'.
DBCC results for 'SWEVENT'.
There are 0 rows in 0 pages for object 'SWEVENT'.
DBCC results for 'TIMEZONE'.
There are 5 rows in 1 pages for object 'TIMEZONE'.
DBCC results for 'EVTALMLINK'.
There are 1249 rows in 6 pages for object 'EVTALMLINK'.
DBCC results for 'ASSET_SUBTYPE'.
There are 1 rows in 1 pages for object 'ASSET_SUBTYPE'.
DBCC results for 'POS_REGISTER'.
There are 0 rows in 0 pages for object 'POS_REGISTER'.
DBCC results for 'MU_ALARM_MASK_GROUP_ACTION'.
There are 0 rows in 0 pages for object 'MU_ALARM_MASK_GROUP_ACTION'.
DBCC results for 'TITLE'.
There are 1 rows in 1 pages for object 'TITLE'.
DBCC results for 'ASSET_LASTLOCATION'.
There are 0 rows in 0 pages for object 'ASSET_LASTLOCATION'.
DBCC results for 'REPL_SCHEDULE'.
There are 0 rows in 0 pages for object 'REPL_SCHEDULE'.
DBCC results for 'TRANSLOG'.
There are 0 rows in 0 pages for object 'TRANSLOG'.
DBCC results for 'VISITOR_SIGNOUT_ACTION'.
There are 0 rows in 0 pages for object 'VISITOR_SIGNOUT_ACTION'.
DBCC results for 'ARCHIVE_PURGE_DATABASE_ACTION'.
There are 1 rows in 1 pages for object 'ARCHIVE_PURGE_DATABASE_ACTION'.
DBCC results for 'TZINTERVAL'.
There are 6 rows in 1 pages for object 'TZINTERVAL'.
DBCC results for 'FAILEDRPC'.
There are 0 rows in 1 pages for object 'FAILEDRPC'.
DBCC results for 'ASSET_GROUP'.
There are 1 rows in 1 pages for object 'ASSET_GROUP'.
DBCC results for 'CONTINUOUS_VIDEO'.
There are 0 rows in 0 pages for object 'CONTINUOUS_VIDEO'.
DBCC results for 'DEACTIVATE_BADGE_ACTION'.
There are 0 rows in 0 pages for object 'DEACTIVATE_BADGE_ACTION'.
DBCC results for 'INTERCOM_CALL_ACTION'.
There are 0 rows in 0 pages for object 'INTERCOM_CALL_ACTION'.
DBCC results for 'UDFEMP'.
There are 1 rows in 1 pages for object 'UDFEMP'.
DBCC results for 'EMP'.
There are 1 rows in 1 pages for object 'EMP'.
DBCC results for 'FLOORLINK'.
There are 128 rows in 1 pages for object 'FLOORLINK'.
DBCC results for 'CHANGE_PASSWORD_ACTION'.
There are 0 rows in 0 pages for object 'CHANGE_PASSWORD_ACTION'.
DBCC results for 'ISC_DATABASE_DOWNLOAD_ACTION'.
There are 0 rows in 0 pages for object 'ISC_DATABASE_DOWNLOAD_ACTION'.
DBCC results for 'LNL_RELATION'.
There are 11 rows in 1 pages for object 'LNL_RELATION'.
DBCC results for 'UDFOBJS'.
There are 202 rows in 7 pages for object 'UDFOBJS'.
DBCC results for 'NET_DOMAIN'.
There are 0 rows in 0 pages for object 'NET_DOMAIN'.
DBCC results for 'FLOORLIST'.
There are 3 rows in 1 pages for object 'FLOORLIST'.
DBCC results for 'CHANGE_PASSWORD_DEVICE'.
There are 0 rows in 0 pages for object 'CHANGE_PASSWORD_DEVICE'.
DBCC results for 'CARD_PRINTER_TYPE'.
There are 8 rows in 1 pages for object 'CARD_PRINTER_TYPE'.
DBCC results for 'ISC_DATABASE_DOWNLOAD_PANEL'.
There are 0 rows in 0 pages for object 'ISC_DATABASE_DOWNLOAD_PANEL'.
DBCC results for 'IVAPPLICATION'.
There are 0 rows in 0 pages for object 'IVAPPLICATION'.
DBCC results for 'NET_EMP_SID'.
There are 0 rows in 0 pages for object 'NET_EMP_SID'.
DBCC results for 'GIOFUNCLIST'.
There are 0 rows in 0 pages for object 'GIOFUNCLIST'.
DBCC results for 'TEXT_LIBRARY'.
There are 0 rows in 0 pages for object 'TEXT_LIBRARY'.
DBCC results for 'SEGMENT'.
There are 1 rows in 1 pages for object 'SEGMENT'.
DBCC results for 'ISC_FIRMWARE_DOWNLOAD_ACTION'.
There are 0 rows in 0 pages for object 'ISC_FIRMWARE_DOWNLOAD_ACTION'.
DBCC results for 'ENCODER'.
There are 0 rows in 0 pages for object 'ENCODER'.
DBCC results for 'GIOFUNCLISTLINK'.
There are 0 rows in 0 pages for object 'GIOFUNCLISTLINK'.
DBCC results for 'IVAPPLICATIONTYPE'.
There are 0 rows in 0 pages for object 'IVAPPLICATIONTYPE'.
DBCC results for 'CCTVDEVICE_FAILOVER'.
There are 0 rows in 0 pages for object 'CCTVDEVICE_FAILOVER'.
DBCC results for 'HOLIDAYS'.
There are 1 rows in 1 pages for object 'HOLIDAYS'.
DBCC results for 'ISC_FIRMWARE_DOWNLOAD_PANEL'.
There are 0 rows in 0 pages for object 'ISC_FIRMWARE_DOWNLOAD_PANEL'.
DBCC results for 'IVAPP_CRITERIA_LOCK'.
There are 0 rows in 0 pages for object 'IVAPP_CRITERIA_LOCK'.
DBCC results for 'UDFPAGES'.
There are 2 rows in 1 pages for object 'UDFPAGES'.
DBCC results for 'USER_PERM_DEVICE_GROUP_LINK'.
There are 0 rows in 0 pages for object 'USER_PERM_DEVICE_GROUP_LINK'.
DBCC results for 'PTZ_SERVER_TYPE'.
There are 5 rows in 1 pages for object 'PTZ_SERVER_TYPE'.
DBCC results for 'HOLIDAY_TYPE'.
There are 8 rows in 1 pages for object 'HOLIDAY_TYPE'.
DBCC results for 'RESET_GLOBAL_APB_ACTION'.
There are 0 rows in 0 pages for object 'RESET_GLOBAL_APB_ACTION'.
DBCC results for 'PANEL_SELECTIVE_DOWNLOAD'.
There are 0 rows in 0 pages for object 'PANEL_SELECTIVE_DOWNLOAD'.
DBCC results for 'USER_PERM'.
There are 12 rows in 1 pages for object 'USER_PERM'.
DBCC results for 'ACCTRANS_OPERATION'.
There are 60 rows in 1 pages for object 'ACCTRANS_OPERATION'.
DBCC results for 'BADGETYPE_CARDFORMAT_LINK'.
There are 0 rows in 0 pages for object 'BADGETYPE_CARDFORMAT_LINK'.
DBCC results for 'AIMS'.
There are 0 rows in 0 pages for object 'AIMS'.
DBCC results for 'HOLIDAY_LNK'.
There are 1 rows in 1 pages for object 'HOLIDAY_LNK'.
DBCC results for 'RESET_GLOBAL_APB_SEGMENT'.
There are 0 rows in 0 pages for object 'RESET_GLOBAL_APB_SEGMENT'.
DBCC results for 'ACCTRANS_OBJECT'.
There are 128 rows in 1 pages for object 'ACCTRANS_OBJECT'.
DBCC results for 'USER_PERM_UDF'.
There are 2 rows in 1 pages for object 'USER_PERM_UDF'.
DBCC results for 'IDS_ALLOCATED'.
There are 0 rows in 0 pages for object 'IDS_ALLOCATED'.
DBCC results for 'REPORT_PRINT_ACTION'.
There are 0 rows in 0 pages for object 'REPORT_PRINT_ACTION'.
DBCC results for 'BADGE_ENCODING'.
There are 0 rows in 0 pages for object 'BADGE_ENCODING'.
DBCC results for 'LASTLOCATION_REPL'.
There are 0 rows in 0 pages for object 'LASTLOCATION_REPL'.
DBCC results for 'USER_PERM_UDF_FIELDS'.
There are 161 rows in 2 pages for object 'USER_PERM_UDF_FIELDS'.
DBCC results for 'IE_ACISFLDS'.
There are 0 rows in 0 pages for object 'IE_ACISFLDS'.
DBCC results for 'CONTINUOUS_VIDEO_RESTORED'.
There are 0 rows in 0 pages for object 'CONTINUOUS_VIDEO_RESTORED'.
DBCC results for 'DESERVERHOST'.
There are 0 rows in 0 pages for object 'DESERVERHOST'.
DBCC results for 'USER_PERM_UDF_PAGES'.
There are 2 rows in 1 pages for object 'USER_PERM_UDF_PAGES'.
DBCC results for 'IE_ACISINI'.
There are 0 rows in 0 pages for object 'IE_ACISINI'.
DBCC results for 'LASTLOCATION_REPL_STAGE'.
There are 0 rows in 0 pages for object 'LASTLOCATION_REPL_STAGE'.
DBCC results for 'CCTVDEVICE_IO'.
There are 0 rows in 0 pages for object 'CCTVDEVICE_IO'.
DBCC results for 'IE_RELATION'.
There are 0 rows in 0 pages for object 'IE_RELATION'.
DBCC results for 'ASSET'.
There are 0 rows in 0 pages for object 'ASSET'.
DBCC results for 'DE_ACTION'.
There are 0 rows in 0 pages for object 'DE_ACTION'.
DBCC results for 'ACCOUNT'.
There are 0 rows in 0 pages for object 'ACCOUNT'.
DBCC results for 'USER_PERM_REPORT_GROUP'.
There are 0 rows in 0 pages for object 'USER_PERM_REPORT_GROUP'.
DBCC results for 'INTERCOM_STATION'.
There are 0 rows in 0 pages for object 'INTERCOM_STATION'.
DBCC results for 'LNL_DEFAULT'.
There are 0 rows in 0 pages for object 'LNL_DEFAULT'.
DBCC results for 'DE_CONDITION'.
There are 0 rows in 0 pages for object 'DE_CONDITION'.
DBCC results for 'USERS'.
There are 24 rows in 1 pages for object 'USERS'.
DBCC results for 'DE_CONFIGURATION'.
There are 0 rows in 0 pages for object 'DE_CONFIGURATION'.
DBCC results for 'ACCOUNT_ZONE'.
There are 0 rows in 0 pages for object 'ACCOUNT_ZONE'.
DBCC results for 'LASTLOCATION'.
There are 0 rows in 0 pages for object 'LASTLOCATION'.
DBCC results for 'ASSET_ASSIGNMENT'.
There are 0 rows in 0 pages for object 'ASSET_ASSIGNMENT'.
DBCC results for 'ACCOUNT_AREA'.
There are 0 rows in 0 pages for object 'ACCOUNT_AREA'.
DBCC results for 'LOGON_AUTH'.
There are 1 rows in 1 pages for object 'LOGON_AUTH'.
DBCC results for 'USER_SEGMENT_LINK'.
There are 0 rows in 0 pages for object 'USER_SEGMENT_LINK'.
DBCC results for 'MONITOR_CCTV_DEVICE_LINK'.
There are 0 rows in 0 pages for object 'MONITOR_CCTV_DEVICE_LINK'.
DBCC results for 'LAYGRAPH'.
There are 6 rows in 1 pages for object 'LAYGRAPH'.
DBCC results for 'AUDIO'.
There are 0 rows in 0 pages for object 'AUDIO'.
DBCC results for 'DE_EXCHANGE_MAP'.
There are 0 rows in 0 pages for object 'DE_EXCHANGE_MAP'.
DBCC results for 'EVENT_CODE_TEMPLATE'.
There are 18 rows in 1 pages for object 'EVENT_CODE_TEMPLATE'.
DBCC results for 'VISITOR_UDF'.
There are 0 rows in 0 pages for object 'VISITOR_UDF'.
DBCC results for 'DE_EXPRESSION'.
There are 0 rows in 0 pages for object 'DE_EXPRESSION'.
DBCC results for 'LAYOUTS'.
There are 1 rows in 1 pages for object 'LAYOUTS'.
DBCC results for 'BADGE'.
There are 1 rows in 1 pages for object 'BADGE'.
DBCC results for 'DE_IO_DEFINITION'.
There are 0 rows in 0 pages for object 'DE_IO_DEFINITION'.
DBCC results for 'BADGE_USES_LEFT_PER_PANEL'.
There are 0 rows in 0 pages for object 'BADGE_USES_LEFT_PER_PANEL'.
DBCC results for 'EVENT_CODE_MAP'.
There are 1284 rows in 6 pages for object 'EVENT_CODE_MAP'.
DBCC results for 'VISIT'.
There are 0 rows in 0 pages for object 'VISIT'.
DBCC results for 'DE_IO_SET_DEFINITION'.
There are 0 rows in 0 pages for object 'DE_IO_SET_DEFINITION'.
DBCC results for 'LINEPRINTER_COLUMN'.
There are 0 rows in 0 pages for object 'LINEPRINTER_COLUMN'.
DBCC results for 'DE_IO_SET_LINK'.
There are 0 rows in 0 pages for object 'DE_IO_SET_LINK'.
DBCC results for 'TOUR'.
There are 0 rows in 0 pages for object 'TOUR'.
DBCC results for 'WORLDTZ'.
There are 85 rows in 2 pages for object 'WORLDTZ'.
DBCC results for 'DE_IO_SET_UNIT'.
There are 0 rows in 0 pages for object 'DE_IO_SET_UNIT'.
DBCC results for 'LINEPRINTER_LAYOUT'.
There are 0 rows in 0 pages for object 'LINEPRINTER_LAYOUT'.
DBCC results for 'TOUR_CHECKPOINT'.
There are 0 rows in 0 pages for object 'TOUR_CHECKPOINT'.
DBCC results for 'WRKLAYLNK'.
There are 0 rows in 0 pages for object 'WRKLAYLNK'.
DBCC results for 'DE_LOOKUP_PARAM'.
There are 0 rows in 0 pages for object 'DE_LOOKUP_PARAM'.
DBCC results for 'LINKAGESERVERHOST'.
There are 1 rows in 1 pages for object 'LINKAGESERVERHOST'.
DBCC results for 'LINXPROCCMDS'.
There are 0 rows in 0 pages for object 'LINXPROCCMDS'.
DBCC results for 'TOUR_CHECKPOINT_ACTION'.
There are 0 rows in 0 pages for object 'TOUR_CHECKPOINT_ACTION'.
DBCC results for 'DE_OPERATION'.
There are 0 rows in 0 pages for object 'DE_OPERATION'.
DBCC results for 'LNR_SOURCE_CAPS'.
There are 0 rows in 0 pages for object 'LNR_SOURCE_CAPS'.
DBCC results for 'GOS_DEVICE'.
There are 1 rows in 1 pages for object 'GOS_DEVICE'.
DBCC results for 'LNLCONFIG'.
There are 18 rows in 2 pages for object 'LNLCONFIG'.
DBCC results for 'BADGELINK'.
There are 0 rows in 0 pages for object 'BADGELINK'.
DBCC results for 'TOUR_CHECKPOINT_MESSAGE'.
There are 0 rows in 0 pages for object 'TOUR_CHECKPOINT_MESSAGE'.
DBCC results for 'FIRE_DEVICES'.
There are 0 rows in 0 pages for object 'FIRE_DEVICES'.
DBCC results for 'LNL_DB'.
There are 0 rows in 0 pages for object 'LNL_DB'.
DBCC results for 'BADGETYP'.
There are 4 rows in 1 pages for object 'BADGETYP'.
DBCC results for 'TOUR_MONSTATION'.
There are 0 rows in 0 pages for object 'TOUR_MONSTATION'.
DBCC results for 'FIRE_DEVICE_INPUTS_OUTPUTS'.
There are 0 rows in 0 pages for object 'FIRE_DEVICE_INPUTS_OUTPUTS'.
DBCC results for 'GOS_ALARMMESSAGELINK'.
There are 1 rows in 1 pages for object 'GOS_ALARMMESSAGELINK'.
DBCC results for 'BADGEID_RANGE'.
There are 0 rows in 0 pages for object 'BADGEID_RANGE'.
DBCC results for 'TOUR_LIST'.
There are 0 rows in 0 pages for object 'TOUR_LIST'.
DBCC results for 'RESET_USE_LIMIT_ACTION'.
There are 0 rows in 0 pages for object 'RESET_USE_LIMIT_ACTION'.
DBCC results for 'GOS_RECIPIENT'.
There are 0 rows in 1 pages for object 'GOS_RECIPIENT'.
DBCC results for 'TOUR_LIST_LINK'.
There are 0 rows in 0 pages for object 'TOUR_LIST_LINK'.
DBCC results for 'dtproperties'.
There are 0 rows in 0 pages for object 'dtproperties'.
DBCC results for 'LOCATION'.
There are 1 rows in 1 pages for object 'LOCATION'.
DBCC results for 'RESET_USE_LIMIT_PANEL'.
There are 0 rows in 0 pages for object 'RESET_USE_LIMIT_PANEL'.
DBCC results for 'GOS_RECIPIENTADDRESS'.
There are 0 rows in 1 pages for object 'GOS_RECIPIENTADDRESS'.
DBCC results for 'LPRIORITY'.
There are 4 rows in 1 pages for object 'LPRIORITY'.
DBCC results for 'TOUR_EMP_TOUR_LIST_LINK'.
There are 0 rows in 0 pages for object 'TOUR_EMP_TOUR_LIST_LINK'.
DBCC results for 'EOL_TABLE'.
There are 4 rows in 1 pages for object 'EOL_TABLE'.
DBCC results for 'GOS_MESSAGERECIPIENT'.
There are 0 rows in 1 pages for object 'GOS_MESSAGERECIPIENT'.
DBCC results for 'MAP'.
There are 1 rows in 1 pages for object 'MAP'.
DBCC results for 'TOUR_LOG'.
There are 0 rows in 0 pages for object 'TOUR_LOG'.
DBCC results for 'EOL_TABLE_LINK'.
There are 0 rows in 0 pages for object 'EOL_TABLE_LINK'.
DBCC results for 'ALARMVIDEOCONFIG'.
There are 4 rows in 1 pages for object 'ALARMVIDEOCONFIG'.
DBCC results for 'MAPICON'.
There are 134 rows in 2 pages for object 'MAPICON'.
DBCC results for 'BADGETYPE_SEGMENT_LINK'.
There are 0 rows in 0 pages for object 'BADGETYPE_SEGMENT_LINK'.
DBCC results for 'INTRUSION_DEVICE'.
There are 0 rows in 0 pages for object 'INTRUSION_DEVICE'.
DBCC results for 'MAPICONGRP'.
There are 43 rows in 1 pages for object 'MAPICONGRP'.
DBCC results for 'ACTION_TYPE'.
There are 38 rows in 1 pages for object 'ACTION_TYPE'.
DBCC results for 'CCTV_DEVICE_LINK'.
There are 94 rows in 3 pages for object 'CCTV_DEVICE_LINK'.
DBCC results for 'BADGSTAT'.
There are 4 rows in 1 pages for object 'BADGSTAT'.
DBCC results for 'CAMERATYPE'.
There are 37 rows in 1 pages for object 'CAMERATYPE'.
DBCC results for 'MAPICONGRP_MEMBER'.
There are 143 rows in 1 pages for object 'MAPICONGRP_MEMBER'.
DBCC results for 'ACTION'.
There are 1 rows in 1 pages for object 'ACTION'.
DBCC results for 'CCTVDEVICE'.
There are 202 rows in 10 pages for object 'CCTVDEVICE'.
DBCC results for 'SERVERCAMERATYPE'.
There are 37 rows in 1 pages for object 'SERVERCAMERATYPE'.
DBCC results for 'MAPITEM'.
There are 48 rows in 1 pages for object 'MAPITEM'.
DBCC results for 'ACTION_LOG'.
There are 29 rows in 1 pages for object 'ACTION_LOG'.
DBCC results for 'BDGPRECLINK'.
There are 0 rows in 0 pages for object 'BDGPRECLINK'.
DBCC results for 'VISIT_EMAIL_LINK'.
There are 0 rows in 0 pages for object 'VISIT_EMAIL_LINK'.
DBCC results for 'DEFAULTMAPICON'.
There are 56 rows in 1 pages for object 'DEFAULTMAPICON'.
DBCC results for 'BDGREQFLDLINK'.
There are 0 rows in 0 pages for object 'BDGREQFLDLINK'.
DBCC results for 'ACTION_GROUP'.
There are 0 rows in 1 pages for object 'ACTION_GROUP'.
DBCC results for 'MARKEDVIDEO'.
There are 0 rows in 1 pages for object 'MARKEDVIDEO'.
DBCC results for 'BUILDING'.
There are 1 rows in 1 pages for object 'BUILDING'.
DBCC results for 'MMOBJS'.
There are 3 rows in 1 pages for object 'MMOBJS'.
DBCC results for 'CARDFORMAT'.
There are 13 rows in 1 pages for object 'CARDFORMAT'.
DBCC results for 'SEGMENT_EMAIL_LINK'.
There are 0 rows in 0 pages for object 'SEGMENT_EMAIL_LINK'.
DBCC results for 'EXECFUNCLISTACTION'.
There are 0 rows in 0 pages for object 'EXECFUNCLISTACTION'.
DBCC results for 'ACTION_SCHEDULE'.
There are 1 rows in 1 pages for object 'ACTION_SCHEDULE'.
DBCC results for 'MMOBJTYPS'.
There are 2 rows in 1 pages for object 'MMOBJTYPS'.
DBCC results for 'WRKSTATION'.
There are 2 rows in 1 pages for object 'WRKSTATION'.
DBCC results for 'VISIT_SEARCH'.
There are 2 rows in 1 pages for object 'VISIT_SEARCH'.
DBCC results for 'EXPECTED_TRANSACTION_TIME'.
There are 0 rows in 0 pages for object 'EXPECTED_TRANSACTION_TIME'.
DBCC results for 'MOBILE_ID_CONTROL'.
There are 10 rows in 1 pages for object 'MOBILE_ID_CONTROL'.
DBCC results for 'VISIT_SEARCH_ELEMENT'.
There are 58 rows in 1 pages for object 'VISIT_SEARCH_ELEMENT'.
DBCC results for 'ARCHIVELOCATION'.
There are 2 rows in 1 pages for object 'ARCHIVELOCATION'.
DBCC results for 'ACCOUNT_GROUP'.
There are 0 rows in 0 pages for object 'ACCOUNT_GROUP'.
DBCC results for 'MONDEVLINK'.
There are 22 rows in 2 pages for object 'MONDEVLINK'.
DBCC results for 'CARDFORMAT_SEGMENT_LINK'.
There are 0 rows in 0 pages for object 'CARDFORMAT_SEGMENT_LINK'.
DBCC results for 'EVENTS_VIDEO'.
There are 39 rows in 1 pages for object 'EVENTS_VIDEO'.
DBCC results for 'IPCAMERA_FW_DOWNLOAD_ACTION'.
There are 0 rows in 0 pages for object 'IPCAMERA_FW_DOWNLOAD_ACTION'.
DBCC results for 'ACCESSGRP'.
There are 0 rows in 0 pages for object 'ACCESSGRP'.
DBCC results for 'BADGE_AREA_LOCATION'.
There are 0 rows in 0 pages for object 'BADGE_AREA_LOCATION'.
DBCC results for 'MONSTATION'.
There are 14 rows in 1 pages for object 'MONSTATION'.
DBCC results for 'CCTVCONTROL'.
There are 0 rows in 0 pages for object 'CCTVCONTROL'.
DBCC results for 'IPCAMERA_FW_DOWNLOAD_CAMERA'.
There are 0 rows in 0 pages for object 'IPCAMERA_FW_DOWNLOAD_CAMERA'.
DBCC results for 'ACCESSLVL'.
There are 0 rows in 0 pages for object 'ACCESSLVL'.
DBCC results for 'MUSTER_ZONE_SAFE_LOCATIONS'.
There are 0 rows in 0 pages for object 'MUSTER_ZONE_SAFE_LOCATIONS'.
DBCC results for 'MONZONE'.
There are 1 rows in 1 pages for object 'MONZONE'.
DBCC results for 'DDCONNECT'.
There are 1 rows in 1 pages for object 'DDCONNECT'.
DBCC results for 'LNL_QUEUE'.
There are 0 rows in 0 pages for object 'LNL_QUEUE'.
DBCC results for 'ACCESSPANE'.
There are 23 rows in 2 pages for object 'ACCESSPANE'.
DBCC results for 'INPUT_EVENT'.
There are 0 rows in 0 pages for object 'INPUT_EVENT'.
DBCC results for 'PANELTYPE'.
There are 60 rows in 1 pages for object 'PANELTYPE'.
DBCC results for 'DDFLD'.
There are 128 rows in 3 pages for object 'DDFLD'.
CHECKDB found 0 allocation errors and 2 consistency errors in database 'AccessControl'.
repair_rebuild is the minimum repair level for the errors found by DBCC CHECKDB (AccessControl ).
DBCC execution completed. If DBCC printed error messages, contact your system administrator.


Thanks,
Steven Stuart

View 8 Replies View Related

DBCC CHECKDB - Consistency Errors

Apr 27, 2008


Hello All,

After restoring the SQL Server 2000 user database backup into one of the SQL Server 2000 instances I get database consistency errors. I restored this database on this particular server a several times already and every time the consistency errors were detected by dbcc checkdb; however the errors are not consistent - different types of errors, different tables and indexes are affected. I restored the same database backup into a different server and ran dbcc checkdb over it - no errors occurred. Something causes corruption in the database on one particular server. Here are the initial errors:

DBCC results for 'tTREE_COMPONENTS'.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1467308437, index ID 0: Page (1:251481) could not be processed. See other errors for details.
Server: Msg 8944, Level 16, State 1, Line 1
Table error: Object ID 1467308437, index ID 0, page (1:251481), row 44. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 87 and 57.
There are 663 rows in 16 pages for object 'tTREE_COMPONENTS'.

DBCC results for 'tACCUMULATORS'.
There are 10234724 rows in 97149 pages for object 'tACCUMULATORS'.
CHECKDB found 0 allocation errors and 2 consistency errors in table 'tACCUMULATORS' (object ID 1467308437).

DBCC results for 'WATSTARTDATETP'.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1905493917, index ID 4: Page (3:224866) could not be processed. See other errors for details.

Server: Msg 8941, Level 16, State 1, Line 1
Table error: Object ID 1905493917, index ID 4, page (3:224866). Test (sorted .offset >= PAGEHEADSIZE) failed. Slot 159, offset 0x1 is invalid.

Server: Msg 8942, Level 16, State 1, Line 1
Table error: Object ID 1905493917, index ID 4, page (3:224866). Test (sorted.offset >= max) failed. Slot 0, offset 0x9f overlaps with the prior row.
There are 4 rows in 1 pages for object 'WATSTARTDATETP'.

DBCC results for 'ACCRUALTRAN'.
There are 5919148 rows in 150538 pages for object 'ACCRUALTRAN'.
CHECKDB found 0 allocation errors and 3 consistency errors in table 'ACCRUALTRAN' (object ID 1905493917).

If you could please take a look at the errors and give me your thoughts on what could be the cause for the errors I would greatly appreciate it.

Thank you in advance,

Yulia

View 5 Replies View Related

DBCC CheckDB Error

Dec 4, 2006

Simon writes "There are error messages in our DBCC CheckDB job. It happens in two of tables. (See below for the sample error messages.)

I have found two postings in the forum; but it seems that they are not applicable to my situation:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=65913
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55021

The errors happen to two of the user tables.

So my questions are:

1. How to fix these errors?
2. Are the records in the DB still good?
3. How to prevent this happening again?

The database server is running Windows 2000 sp4 and SQL 2000 sp3. It's running on the RAID5 in MS Cluster environment.

I really appreciate your assistance. Thank you.


The error message samples are:

Msg 8974, Sev 16: Text node referenced by more than one node. Object ID 837578022, text, ntext, or image node page (1:130912), slot 27, text ID 25207869603840 is pointed to by page (1:1392667), slot 2 and by page (1:1210230), slot 10. [SQLSTATE 42000]
Msg 8961, Sev 16: Table error: Object ID 837578022. The text, ntext, or image node at page (1:130912), slot 30, text ID 25199404974080 does not match its reference from page (1:131226), slot 17. [SQLSTATE 42000]
Msg 8974, Sev 16: Text node referenced by more than one node. Object ID 837578022, text, ntext, or image node page (1:130912), slot 30, text ID 25254380437504 is pointed to by page (1:1392667), slot 4 and by page (1:131226), slot 17. [SQLSTATE 42000]
Msg 8964, Sev 16: Table error: Object ID 837578022. The text, ntext, or image node at page (1:134162), slot 23, text ID 25204615217152 is not referenced. [SQLSTATE 42000]

Msg 8990, Sev 16: CHECKDB found 0 allocation errors and 211 consistency errors in table 'TABLE_ONE' (object ID 837578022). [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'TABLE_TWO'. [SQLSTATE 01000]


Msg 8974, Sev 16: Text node referenced by more than one node. Object ID 853578079, text, ntext, or image node page (1:129320), slot 38, text ID 25496001314816 is pointed to by page (1:239021), slot 101 and by page (1:487008), slot 100. [SQLSTATE 42000]
Msg 8961, Sev 16: Table error: Object ID 853578079. The text, ntext, or image node at page (1:129320), slot 39, text ID 25199327903744 does not match its reference from page (1:487008), slot 101. [SQLSTATE 42000]
Msg 8974, Sev 16: Text node referenced by more than one node. Object ID 853578079, text, ntext, or image node page (1:129320), slot 39, text ID 25496001642496 is pointed to by page (1:239021), slot 102 and by page (1:487008), slot 101. [SQLSTATE 42000]
Msg 8964, Sev 16: Table error: Object ID 853578079. The text, ntext, or image node at page (1:136454), slot 1, text ID 25031875559424 is not referenced. [SQLSTATE 42000]
Msg 8964, Sev 16: Table error: Object ID 853578079. The text, ntext, or image node at page (1:136454), slot 2, text ID 25031875887104 is not referenced. [SQLSTATE 42000]

Msg 8964, Sev 16: Table error: Object ID 853578079. The text, ntext, or image node at page (1:136603), slot 2, text ID 25031875231744 is not referenced. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 853578079, index ID 255: Page (1:137476) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8939, Sev 16: Table error: Object ID 853578079, index ID 255, page (1:137476). Test (m_freeCnt == freeCnt) failed. Values are 357 and 525. [SQLSTATE 42000]

Msg 2593, Sev 16: There are 1972569 rows in 14051 pages for object 'TABLE_TWO'. [SQLSTATE 01000]
Msg 8990, Sev 16: CHECKDB found 0 allocation errors and 166 consistency errors in table 'TABLE_TWO' (object ID 853578079). [SQLSTATE 01000]"

View 2 Replies View Related

What Error #s To Look For In Dbcc Checkdb Output

Jan 29, 2001

I want to automate the dbcc checkdb process. I create a temp table called #CheckDbTbl and run the following command:

INSERT INTO #CheckDBTbl
dbcc checkdb(MyDbName) with tableresults

I plan to send myself an email if any problems are found.

Does anyone know what Error numbers or Levels or anything else I should look for in the #CheckDBTbl that will tell me a problem exists? Right now I'm only checking for: Level >= 16.

Many thanks for your responses!

-bh

View 1 Replies View Related

Dbcc CheckDB Error 8999

Jan 28, 2005

[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 8999: [Microsoft][ODBC SQL Server Driver][SQL Server]Database tempdb allocation errors prevent further CHECKDB processing.

I get this error above when running a Checkdb on tempDB I haven't found out any fixes yet. I bounced the server service and the job runs, but after 2 days it fails again. Any ideas?

Thanks for your time.

View 1 Replies View Related

DBCC CHECKDB Concistency Error

Dec 12, 2005

When running DBCC CHECKDB with Repair_Rebuild option in sigle use mode I get 16 consistency error. the error message is always on object ID 2. Can someone tell what is Object ID 2 and what can be done to re-reference what is not referenced? The log follow!

Thanks!

Msg 8964, Sev 16: Table error: Object ID 2. The text, ntext, or image node at page (1:2027787), slot 8, text ID 37039898624 is not referenced. [SQLSTATE 42000]
Msg 8964, Sev 16: Table error: Object ID 2. The text, ntext, or image node at page (1:2027787), slot 10, text ID 37039964160 is not referenced. [SQLSTATE 42000]
Msg 8964, Sev 16: Table error: Object ID 2. The text, ntext, or image node at page (1:2027787), slot 12, text ID 37040029696 is not referenced. [SQLSTATE 42000]
Msg 8964, Sev 16: Table error: Object ID 2. The text, ntext, or image node at page (1:2027787), slot 13, text ID 37040095232 is not referenced. [SQLSTATE 42000]
Msg 8964, Sev 16: Table error: Object ID 2. The text, ntext, or image node at page (1:4142208), slot 6, text ID 35910909952 is not referenced. [SQLSTATE 42000]
Msg 2536, Sev 16: DBCC results for 'Datawarehouse'. [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'sysobjects'. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 1377 rows in 30 pages for object 'sysobjects'. [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'sysindexes'. [SQLSTATE 01000]
Msg 8923, Sev 16: The repair level on the DBCC statement caused this repair to be bypassed. [SQLSTATE 01000]
Msg 8923, Sev 16: The repair level on the DBCC statement caused this repair to be bypassed. [SQLSTATE 01000]
Msg 8923, Sev 16: The repair level on the DBCC statement caused this repair to be bypassed. [SQLSTATE 01000]
Msg 8923, Sev 16: The repair level on the DBCC statement caused this repair to be bypassed. [SQLSTATE 01000]
Msg 8964, Sev 16: Table error: Object ID 2. The text, ntext, or image node at page (1:4142208), slot 8, text ID 35910975488 is not referenced. [SQLSTATE 42000]
Msg 8964, Sev 16: Table error: Object ID 2. The text, ntext, or image node at page (1:4142208), slot 10, text ID 35911041024 is not referenced. [SQLSTATE 42000]
Msg 8964, Sev 16: Table error: Object ID 2. The text, ntext, or image node at page (1:4142208), slot 11, text ID 35911106560 is not referenced. [SQLSTATE 42000]
Msg 8964, Sev 16: Table error: Object ID 2. The text, ntext, or image node at page (1:4142208), slot 12, text ID 35911172096 is not referenced. [SQLSTATE 42000]
Msg 8964, Sev 16: Table error: Object ID 2. The text, ntext, or image node at page (1:4142208), slot 14, text ID 35911237632 is not referenced. [SQLSTATE 42000]
Msg 8964, Sev 16: Table error: Object ID 2. The text, ntext, or image node at page (1:7691690), slot 1, text ID 37040160768 is not referenced. [SQLSTATE 42000]
Msg 8964, Sev 16: Table error: Object ID 2. The text, ntext, or image node at page (1:7691690), slot 3, text ID 37040226304 is not referenced. [SQLSTATE 42000]
Msg 8964, Sev 16: Table error: Object ID 2. The text, ntext, or image node at page (1:7691691), slot 1, text ID 37040291840 is not referenced. [SQLSTATE 42000]
Msg 8923, Sev 16: The repair level on the DBCC statement caused this repair to be bypassed. [SQLSTATE 01000]
Msg 8923, Sev 16: The repair level on the DBCC statement caused this repair to be bypassed. [SQLSTATE 01000]
Msg 8923, Sev 16: The repair level on the DBCC statement caused this repair to be bypassed. [SQLSTATE 01000]
Msg 8923, Sev 16: The repair level on the DBCC statement caused this repair to be bypassed. [SQLSTATE 01000]
Msg 8923, Sev 16: The repair level on the DBCC statement caused this repair to be bypassed. [SQLSTATE 01000]
Msg 8923, Sev 16: The repair level on the DBCC statement caused this repair to be bypassed. [SQLSTATE 01000]
Msg 8923, Sev 16: The repair level on the DBCC statement caused this repair to be bypassed. [SQLSTATE 01000]
Msg 8923, Sev 16: The repair level on the DBCC statement caused this repair to be bypassed. [SQLSTATE 01000]
Msg 8923, Sev 16: The repair level on the DBCC statement caused this repair to be bypassed. [SQLSTATE 01000]
Msg 8964, Sev 16: Table error: Object ID 2. The text, ntext, or image node at page (1:7691691), slot 2, text ID 37040357376 is not referenced. [SQLSTATE 42000]
Msg 8964, Sev 16: Table error: Object ID 2. The text, ntext, or image node at page (1:7699783), slot 1, text ID 35911303168 is not referenced. [SQLSTATE 42000]
Msg 8964, Sev 16: Table error: Object ID 2. The text, ntext, or image node at page (1:7792736), slot 2, text ID 35911368704 is not referenced. [SQLSTATE 42000]
Msg 8923, Sev 16: The repair level on the DBCC statement caused this repair to be bypassed. [SQLSTATE 01000]
Msg 8923, Sev 16: The repair level on the DBCC statement caused this repair to be bypassed. [SQLSTATE 01000]
Msg 8923, Sev 16: The repair level on the DBCC statement caused this repair to be bypassed. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 3487 rows in 218 pages for object 'sysindexes'. [SQLSTATE 01000]
Msg 8990, Sev 16: CHECKDB found 0 allocation errors and 16 consistency errors in table 'sysindexes' (object ID 2). [SQLSTATE 01000]

View 1 Replies View Related

DBCC CHECKDB WITH NO_INFOMSGS Error

Jun 1, 2006

When I run either "DBCC CHECKDB WITH NO_INFOMSGS" or using "check database integrity" in maintenance plan, I always got an error below:

The In-row data RSVD page count for object "tablename", index ID 0, partition ID 76911687696384, alloc unit ID 76911687696384 (type In-row data) is incorrect. Run DBCC UPDATEUSAGE.
CHECKDB found 0 allocation errors and 1 consistency errors in table 'tablename' (object ID 1173579219).
CHECKDB found 0 allocation errors and 1 consistency errors in database 'dbname'.

Can anyone help me please?

Regards,

View 10 Replies View Related

DBCC CHECKDB, MSSQLSERVER_8974 Error In Tempdb

Dec 5, 2007

During the night I run a checkdb that reported a error in tempdb, log down in post for more info.
Table error: Object ID 1109769969, index ID 0, partition ID 72057595983888384, alloc unit ID 72057596039200768 (type LOB data). The off-row data node at page (6:459), slot 0, text ID 296853831680 is not referenced.
If run a checkdb know it€™s not finding any problem. I€™m bit confused what to do restart the server to get new tempdb? I check with for SQL Server 2005 Books Online for the €œMSSQLSERVER_8974€? error, it tells me to look after a €œLook for Hardware Failure€?. In the sql server log its stands that its have found 82 errors
DBCC CHECKDB (tempdb) executed by AIR5MSSQLService found 82 errors and repaired 0 errors. Elapsed time: 0 hours 0 minutes 3 seconds.
Directly after this a stackdump are generated. Somewhere in the middle of my dbcc script.
After the i get the result of the next databases.
DBCC CHECKDB (model) executed by AIR5MSSQLService found 0 errors and repaired 0 errors. Elapsed time: 0 hours 0 minutes 0 seconds.
This is compress version of the log of dbcc job
NEW COMPONENT OUTPUT
Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.3042
Report was generated on "FLEFSE".
Maintenance Plan: Underhåll
Duration: 00:12:55
Status: Warning: One or more tasks failed..
Details:
Check Database Integrity (FLEFSE)
Execute TSQL on Local server connection
Execution time out: 1800
Task start: 2007-12-05T02:00:01.
Task end: 2007-12-05T02:12:57.
Failed-1073548784) Executing the query "DECLARE AllDatabases CURSOR LOCAL FAST_FORWARD READ_ONLY FOR
SELECT name FROM sys.databases WHERE state_desc='ONLINE'
OPEN AllDatabases
DECLARE @DBNameVar NVARCHAR(128)
DECLARE @Statement NVARCHAR(300)
FETCH NEXT FROM AllDatabases INTO @DBNameVar
WHILE (@@FETCH_STATUS = 0)
BEGIN
PRINT N'CHECKING DATABASE ' + @DBNameVar
SET @Statement = N'USE ' + @DBNameVar + CHAR(13)
+ N'DBCC CHECKDB (' + @DBNameVar + N')'
EXEC sp_executesql @Statement
PRINT CHAR(13) + CHAR(13)
FETCH NEXT FROM AllDatabases INTO @DBNameVar
END
CLOSE AllDatabases
DEALLOCATE AllDatabases
" failed with the following error: "Table error: Object ID 1109769969, index ID 0, partition ID 72057595983888384, alloc unit ID 72057596039200768 (type LOB data). The off-row data node at page (6:459), slot 0, text ID 296853831680 is not referenced.
Table error: Object ID 1109769969, index ID 0, partition ID 72057595983888384, alloc unit ID 72057596039200768 (type LOB data). The off-row data node at page (6:459), slot 1, text ID 296853897216 is not referenced.
... to ...
Table error: Object ID 1109769969, index ID 0, partition ID 72057595983888384, alloc unit ID 72057596039200768 (type LOB data). The off-row data node at page (6:459), slot 81, text ID 296871985152 is not referenced.
CHECKING DATABASE master
DBCC results for 'master'.
.... removed lines ...
CHECKDB found 0 allocation errors and 0 consistency errors in database 'master'.
DBCC results for 'mssqlsystemresource'.
.... removed lines ...
CHECKDB found 0 allocation errors and 0 consistency errors in database 'mssqlsystemresource'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
CHECKING DATABASE tempdb
DBCC results for 'tempdb'.
.... removed lines ...
CHECKDB found 0 allocation errors and 82 consistency errors in table '#4225BEF1' (object ID 1109769969).
.... removed lines ...
CHECKDB found 0 allocation errors and 82 consistency errors in database 'tempdb'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (tempdb).
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
CHECKING DATABASE model
DBCC results for 'model'.
.... removed lines ...
CHECKDB found 0 allocation errors and 0 consistency errors in database 'model'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
CHECKING DATABASE msdb
DBCC results for 'msdb'.
.... removed lines ...
CHECKDB found 0 allocation errors and 0 consistency errors in database 'msdb'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
CHECKING DATABASE ReportServer
DBCC results for 'ReportServer'.
.... removed lines ...
CHECKDB found 0 allocation errors and 0 consistency errors in database 'ReportServer'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
CHECKING DATABASE ReportServerTempDB
DBCC results for 'ReportServerTempDB'.
.... removed lines ...
CHECKDB found 0 allocation errors and 0 consistency errors in database 'ReportServerTempDB'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
CHECKING DATABASE caisqlp
DBCC results for 'caisqlp'.
.... removed lines ...
CHECKDB found 0 allocation errors and 0 consistency errors in database 'caisqlp'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
CHECKING DATABASE BKALKYL
DBCC results for 'BKALKYL'.
.... removed lines ...
CHECKDB found 0 allocation errors and 0 consistency errors in database 'BKALKYL'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
CHECKING DATABASE distribution
DBCC results for 'distribution'.
.... removed lines ...
CHECKDB found 0 allocation errors and 0 consistency errors in database 'distribution'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
CHECKING DATABASE DMVstatsDB
DBCC results for 'DMVstatsDB'.
.... removed lines ...
CHECKDB found 0 allocation errors and 0 consistency errors in database 'DMVstatsDB'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
CHECKING DATABASE BALDATA
DBCC results for 'BALDATA'.
.... removed lines ...
CHECKDB found 0 allocation errors and 0 consistency errors in database 'BALDATA'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
CHECKING DATABASE VirtualCenterDB
DBCC results for 'VirtualCenterDB'.
.... removed lines ...
CHECKDB found 0 allocation errors and 0 consistency errors in database 'VirtualCenterDB'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
CHECKING DATABASE BINGE01
DBCC results for 'BINGE01'.
.... removed lines ...
CHECKDB found 0 allocation errors and 0 consistency errors in database 'BINGE01'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
CHECKING DATABASE BMATINK
DBCC results for 'BMATINK'.
.... removed lines ...
CHECKDB found 0 allocation errors and 0 consistency errors in database 'BMATINK'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
CHECKING DATABASE BORDE01
DBCC results for 'BORDE01'.
.... removed lines ...
CHECKDB found 0 allocation errors and 0 consistency errors in database 'BORDE01'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
CHECKING DATABASE BSTATISTIK
DBCC results for 'BSTATISTIK'.
.... removed lines ...
CHECKDB found 0 allocation errors and 0 consistency errors in database 'BSTATISTIK'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
CHECKING DATABASE MPSmartDB
DBCC results for 'MPSmartDB'.
.... removed lines ...
CHECKDB found 0 allocation errors and 0 consistency errors in database 'MPSmartDB'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
CHECKING DATABASE SmarTeamPilot
DBCC results for 'SmarTeamPilot'.
.... removed lines ...
CHECKDB found 0 allocation errors and 0 consistency errors in database 'SmarTeamPilot'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
CHECKING DATABASE STATISTIK
DBCC results for 'STATISTIK'.
.... removed lines ...
CHECKDB found 0 allocation errors and 0 consistency errors in database 'STATISTIK'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
CHECKING DATABASE VBAS
DBCC results for 'VBAS'.
.... removed lines ...
CHECKDB found 0 allocation errors and 0 consistency errors in database 'VBAS'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
CHECKING DATABASE MDataMM_0F
DBCC results for 'MDataMM_0F'.
.... removed lines ...
CHECKDB found 0 allocation errors and 0 consistency errors in database 'MDataMM_0F'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
CHECKING DATABASE DLDB
DBCC results for 'DLDB'.
.... removed lines ...
CHECKDB found 0 allocation errors and 0 consistency errors in database 'DLDB'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
CHECKING DATABASE ILDB
DBCC results for 'ILDB'.
.... removed lines ...
CHECKDB found 0 allocation errors and 0 consistency errors in database 'ILDB'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Command:USE master;
GO
SET NOCOUNT ON;
GO
DECLARE AllDatabases CURSOR LOCAL FAST_FORWARD READ_ONLY FOR
SELECT name FROM sys.databases WHERE state_desc=''ONLINE''
OPEN AllDatabases
DECLARE @DBNameVar NVARCHAR(128)
DECLARE @Statement NVARCHAR(300)
FETCH NEXT FROM AllDatabases INTO @DBNameVar
WHILE (@@FETCH_STATUS = 0)
BEGIN
PRINT N''CHECKING DATABASE '' + @DBNameVar
SET @Statement = N''USE '' + @DBNameVar + CHAR(13)
+ N''DBCC CHECKDB ('' + @DBNameVar + N'')''
EXEC sp_executesql @Statement
PRINT CHAR(13) + CHAR(13)
FETCH NEXT FROM AllDatabases INTO @DBNameVar
END
CLOSE AllDatabases
DEALLOCATE AllDatabases
GO
SET NOCOUNT OFF;
GO

This is the top of the stack-dump
=====================================================================
BugCheck Dump
=====================================================================

This file is generated by Microsoft SQL Server
version 9.00.3042.00
upon detection of fatal unexpected error. Please return this file,
the query or program that produced the bugcheck, the database and
the error log, and any other pertinent information with a Service Request.


Computer type is AT/AT COMPATIBLE.
Current time is 02:00:08 12/05/07.
8 Unknown CPU 9., 2333 Mhz processor (s).
Windows NT 5.2 Build 3790 CSD Service Pack 2.

Memory
MemoryLoad = 98%
Total Physical = 8189 MB
Available Physical = 163 MB
Total Page File = 9795 MB
Available Page File = 1527 MB
Total Virtual = 8388607 MB
Available Virtual = 8373732 MB

DBCC RESULTS
--------------------

... lines removed ....
**Dump thread - spid = 107, PSS = 0x00000000EE497BC0, EC = 0x00000000EE497BD0
***Stack Dump being sent to C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGSQLDump0009.txt
* *******************************************************************************
*
* BEGIN STACK DUMP:
* 12/05/07 02:00:08 spid 107
*
* DBCC database corruption
*
* Input Buffer 510 bytes -
* DECLARE AllDatabases CURSOR LOCAL FAST_FORWARD READ_ONLY FOR
* SELECT name FROM sys.databases WHERE state_desc='ONLINE' OPEN AllDatab
* ases DECLARE @DBNameVar NVARCHAR(128) DECLARE @Statement NVARCHAR(30
* 0) FETCH NEXT FROM AllDatabases INTO @DBNameVar WHILE (@@FETCH_STATU
* S = 0) BEGIN PRINT N'CHECKING DATABASE ' + @DBNameVar SET @Stat
* ement = N'USE ' + @DBNameVar + CHAR(13) + N'DBCC CHECKDB (' + @DB
* NameVar + N')' EXEC sp_executesql @Statement PRINT CHAR(13) + C
* HAR(13) FETCH NEXT FROM AllDatabases INTO @DBNameVar END CLOSE A
* llDatabases DEALLOCATE AllDatabases
*
* *******************************************************************************
* -------------------------------------------------------------------------------
* Short Stack Dump
PSS @0x00000000EE497BC0
-----------------------

My DBCC script looks like this
USE master;
GO
SET NOCOUNT ON;
GO
DECLARE AllDatabases CURSOR LOCAL FAST_FORWARD READ_ONLY FOR
SELECT name FROM sys.databases WHERE state_desc='ONLINE'
OPEN AllDatabases
DECLARE @DBNameVar NVARCHAR(128)
DECLARE @Statement NVARCHAR(300)
FETCH NEXT FROM AllDatabases INTO @DBNameVar
WHILE (@@FETCH_STATUS = 0)
BEGIN
PRINT N'CHECKING DATABASE ' + @DBNameVar
SET @Statement = N'USE ' + @DBNameVar + CHAR(13)
+ N'DBCC CHECKDB (' + @DBNameVar + N')'
EXEC sp_executesql @Statement
PRINT CHAR(13) + CHAR(13)
FETCH NEXT FROM AllDatabases INTO @DBNameVar
END
CLOSE AllDatabases
DEALLOCATE AllDatabases
GO
SET NOCOUNT OFF;
GO

View 2 Replies View Related

Suspect Database - DBCC CHECKDB Throws Error

Apr 13, 2007

Hi all,

we've been having this ancient database with old accounting data running in suspect mode since as long as I can remember (I started working here a year ago), and finally I had some time on my hands so I thought I'd try to get it online again. However I'm running in to problems:

DBCC CHECKDB (myDBName) gives this error:
Msg 926, Level 14, State 1, Line 1
Database 'myDBName' cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server errorlog for more information.

Running sp_helpdb only does not display the suspect database and sp_helpdb 'myDBName' gives this error even though I'm a system administrator:
No permission to access database 'myDBName'.

It's possible that I might be able to dig up a backup but that would be quite tedious. Is it possible to bring the database to a state where I'm able to do a CHECKDB at least...?

--
Lumbago
"Real programmers don't document, if it was hard to write it should be hard to understand"

View 5 Replies View Related

Loical Consistency-based I/O Error

Oct 9, 2007

Hi,
In my database, when I try to start sql service, I got following message in event view.

SQL server is sql express version
Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86) Mar 23 2007 16:28:52 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

10/09/2007 10:48:47,spid5s,Unknown,Recovery is complete. This is an informational message only. No user action is required.
10/09/2007 10:48:47,spid15s,Unknown,SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:9; actual 0:0). It occurred during a read of page (1:9) in database ID 8 at offset 0x00000000012000 in file 'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmagirisilica_s24.mdf'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information<c/> see SQL Server Books Online.
10/09/2007 10:48:47,spid15s,Unknown,Error: 824<c/> Severity: 24<c/> State: 2.

When I try to make
dbcc dbcheckdb ...
I got this.

Msg 945, Level 14, State 2, Line 1
Database 'magirisilica_s24' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.


Any suggest.

Thanks in advance
Radovan

View 3 Replies View Related

SQL Tools :: DBCC CHECKDB Error / Internal Database Snapshot Cannot Be Created

Aug 22, 2013

We recently migrated our production server from SQL 2005 (Standard) on Win2003(32-bit) to SQL2012 (Standard; v11.0.3000) on Win2008-R2(64bit). Single-server Dell R510 with 1.2TB storage. Everything went smoothly; the only nagging issue remaining is failure of our maintenance jobs. I tracked the issue down to failure of DBCC CHECKDB.  Specifically, the error is:Executed as user: NT SERVICESQLSERVERAGENT. The database could not be exclusively locked to perform the operation. [SQLSTATE 42000] (Error 5030) Check statement aborted. The database could not be checked as a database snapshot could not be created and the database or table could not be lockedI have Googled this issue and read extensively. For instance, informative blogs (albeit dated) such as these by Paul Randal (Managing

CheckDB by default takes an internal DB snapshot to get the consistent, point-in-time view of the DB that it needs. If that snapshot creation fails, then it will try to get an exclusive database lock before proceeding (same as if you had executed DBCC CHECKDB WITH TABLOCK). The root problem is not that the lock could not be obtained, it's that the internal database snapshot could not be created. msdn.microsoft.com/en-us/library/ms188796.aspx details the specific situations when an internal database snapshot is not created and table locking is attempted. 

 I have verified the SQLSERVERAGENT service account has full permissions on the SQLDATA directory where the databases reside and has full permissions on each database within the directory. Just for giggles, I created a job (run as SQLSERVERAGENT) that creates and then deletes a text file in the SQLDATA directory.  It runs fine.

Also testedI get the snapshot creation error when manually running DBCC CHECKDB against any of our databases and when executing under a variety of administrator accounts that are members of the SQL sysadmin role and the Domain Admins security group (the Domain Admins is a member of the local Administrators group that has full permissions on all SQL directories/folders).

Additionally, the databases in question are small (200MB to 6GB) and the disk has plenty of elbow room (978GB free on 1.22TB RAID5 array) to create the internal database snapshots. CHECKDB doesn't surface an error message that is detailed enough to determine the precise cause of the error. Any example successfully running DBCC CHECKDB on the SQL2012 (Standard) on a Win2008 R2 (64-bit) server.

View 22 Replies View Related

How DBCC CHECKDB And DBCC CHECKCATALOG After Executing These Two Then Store Result

Mar 5, 2005

For Backup Database i used script
BACKUP DATABSE.

Then after that, i need to check Database inigrity, for that
i used DBCC CHECKDB and DBCC CHECKCATALOG

but, i want to store the result in a text file, after executing these two commends, how to write commend line please help me.

View 1 Replies View Related

SQL Server Detected A Logical Consistency-based I/O Error

Mar 15, 2007

Did anyone familiar with these errors:

SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0x1a00d2fd; actual: 0x1a02d2fd). It occurred during a read of page (1:103329) in database ID 11 at offset 0x00000032742000 in file 'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAServer02.mdf'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database c (Source: MSSQLServer, Error number: 824)
Get help: http://help/824

Thank you.

TJ_1



View 17 Replies View Related

CHECKDB Found 12 Consistency Errors

Feb 27, 2012

My Maintenance plan is failing because of this error.

[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 569873197. The text, ntext, or image node at page (1:13952), slot 42, text ID 49266360320 is not referenced.

[Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation errors and 12 consistency errors in table 'Orientation_ChkList' (object ID 569873197).
[Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation errors and 12 consistency errors in database.

How can I check which rows in this table is corrupted? I have three image fields in this table. This is happening since long time and restore from backup won't work here.

View 5 Replies View Related

CHECKDB: 97 Consistency Errors And None Repaired

May 11, 2006

Hi all,

I'm using WSUS2 to deploy software updates at my company, WSUS2 uses WMSDE (SQL Server Desktop Engine 2000 SP4) to store its database.

WSUS2 suddenly stopped working, I identified problems at the Database Log reading like this:

quote:
2006-05-11 12:17:52.64 spid54 Error: 7105, Severity: 22, State: 6
2006-05-11 12:17:52.64 spid54 Page (1:79), slot 29 for text, ntext, or image node does not exist..
[...]


So I ran a CHECKDB via osql on the commandline and got errors which should be repaired with a minimum of REPAIR_ALLOW_DATA_LOSS.

So I ran the following command on the corruprt Datebase 'SUSDB' after putting the DB into single user mode:


1> DBCC CHECKDB ('SUSDB',REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS
2> GO


And I got the fowllowing output (condensed):

quote:
Msg 8929, Level 16, State 1, Server FILESWSUS, Line 1
Object ID 2: Errors found in text ID 131203072 owned by data record identified
by RID = (1:24:2) id = 1 and indid = 3.
Msg 8929, Level 16, State 1, Server FILESWSUS, Line 1
Object ID 2: Errors found in text ID 131268608 owned by data record identified
by RID = (1:24:6) id = 3 and indid = 2.
Msg 8929, Level 16, State 1, Server FILESWSUS, Line 1
Object ID 2: Errors found in text ID 131334144 owned by data record identified
by RID = (1:24:7) id = 4 and indid = 1.
Msg 8929, Level 16, State 1, Server FILESWSUS, Line 1
Object ID 2: Errors found in text ID 131399680 owned by data record identified
by RID = (1:24:8) id = 4 and indid = 2.
Msg 8929, Level 16, State 1, Server FILESWSUS, Line 1
Object ID 2: Errors found in text ID 131465216 owned by data record identified
by RID = (1:24:13) id = 10 and indid = 2.
Msg 8929, Level 16, State 1, Server FILESWSUS, Line 1
Object ID 2: Errors found in text ID 131530752 owned by data record identified
by RID = (1:24:15) id = 11 and indid = 1.

[... MANY MANY MORE OF THOSE FAILURES WITH DIFFERENT IDs ...]

Object ID 2: Errors found in text ID 459538432 owned by data record identified
by RID = (1:104:27) id = 1858105660 and indid = 3.
The repair level on the DBCC statement caused this repair to be
bypassed.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
Msg 8929, Level 16, State 1, Server FILESWSUS, Line 1
Object ID 2: Errors found in text ID 459735040 owned by data record identified
by RID = (1:104:28) id = 1858105660 and indid = 4.
Msg 8929, Level 16, State 1, Server FILESWSUS, Line 1
Object ID 2: Errors found in text ID 4462411776 owned by data record identified
by RID = (1:107:5) id = 373576369 and indid = 6.
Msg 8929, Level 16, State 1, Server FILESWSUS, Line 1
Object ID 2: Errors found in text ID 327745536 owned by data record identified
by RID = (1:107:10) id = 487672785 and indid = 1.

[... MANY MANY MORE OF THOSE FAILURES WITH DIFFERENT IDs ...]

Msg 8964, Level 16, State 1, Server FILESWSUS, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:64), slot
4, text ID 459735040 is not referenced.
Msg 8964, Level 16, State 1, Server FILESWSUS, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:68), slot
7, text ID 197459968 is not referenced.
Msg 8964, Level 16, State 1, Server FILESWSUS, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:69), slot
0, text ID 197263360 is not referenced.
Msg 8964, Level 16, State 1, Server FILESWSUS, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:70), slot
0, text ID 4462411776 is not referenced.
Msg 8964, Level 16, State 1, Server FILESWSUS, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:71), slot
5, text ID 197197824 is not referenced.
Msg 8928, Level 16, State 1, Server FILESWSUS, Line 1
Object ID 2, index ID 255: Page (1:79) could not be processed. See other errors
for details.
Msg 8965, Level 16, State 1, Server FILESWSUS, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:79), slot
0, text ID 327745536 is referenced by page (1:107), slot 10, but was not seen
in the scan.

[... MANY MANY MORE OF THOSE FAILURES WITH DIFFERENT IDs ...]

The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
CHECKDB found 0 allocation errors and 97 consistency errors in table
'sysindexes' (object ID 2).
CHECKDB found 0 allocation errors and 97 consistency errors in database
'SUSDB'.


None of the errors are repaired, what can I do to repair the Database?

Thanks for any hints!

http://www.linuxhelpforum.de

View 5 Replies View Related

DBCC Page / DBCC Checkdb Errors

Jan 9, 2007

Following the below topic:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=53271

I followed the advice of Paul Randal, but Im stumped as I am not able to determin what the corruption issues are. This is SQL 2000 and the database is a Solomon database that was recently upgraded to 6.5. the error I get when running the DBCC checkdb is as follows:

Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (1:18645) with latch type SH. sysindexes failed.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

When I run select * from sysindexes, I get:

Server: Msg 3624, Level 20, State 1, Line 1

Location: blobman.cpp:1780
Expression: sourceLength == sizeof (TextPointer)
SPID: 53
Process ID: 256

Connection Broken

When I run dbcc page (dbname, 1, 18645, 3)
dbcc traceon(3604), It finishes with what appears to be no errors log is as follows:


PAGE: (1:18645)
---------------

BUFFER:
-------

BUF @0x0144C880
---------------
bpage = 0x681B4000 bhash = 0x00000000 bpageno = (1:18645)
bdbid = 12 breferences = 1 bstat = 0x9
bspin = 0 bnext = 0x00000000

PAGE HEADER:
------------

Page @0x681B4000
----------------
m_pageId = (1:18645) m_headerVersion = 1 m_type = 1
m_typeFlagBits = 0x0 m_level = 0 m_flagBits = 0x2
m_objId = 2 m_indexId = 0 m_prevPage = (1:505)
m_nextPage = (1:213) pminlen = 82 m_slotCnt = 16
m_freeCnt = 3988 m_freeData = 5796 m_reservedCnt = 0
m_lsn = (42700:4549:10) m_xactReserved = 0 m_xdesId = (0:2539719)
m_ghostRecCnt = 0 m_tornBits = 0

Allocation Status
-----------------
GAM (1:2) = ALLOCATED SGAM (1:3) = NOT ALLOCATED
PFS (1:16176) = 0x40 ALLOCATED 0_PCT_FULL DIFF (1:6) = CHANGED
ML (1:7) = NOT MIN_LOGGED

Slot 0 Offset 0xf8c
-------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B4F8C: 00520030 013f142a 00004012 00000000 0.R.*.?..@......
681B4F9C: 00010000 00000000 02600000 00010001 ..........`.....
681B4FAC: 00000000 00000000 00000000 00000000 ................
681B4FBC: 00000000 00000000 027a0000 00000022 ..........z."...
681B4FCC: 00000000 00000000 00000000 00000000 ................
681B4FDC: 001b0000 00000000 00800003 80a60096 ................
681B4FEC: 00af03af 0000000a 3400d008 00000000 ...........4....
681B4FFC: 0001000a 00000000 00010016 00000000 ................
681B500C: 006d0073 006e0049 00420076 00740061 s.m.I.n.v.B.a.t.
681B501C: 00680063 00000030 002a869d 00570000 c.h.0.....*...W.
681B502C: 00010000 0007 ......
id = 20911146
status = 16402
first = 0
indid = 1
root = 0
minlen = 608
keycnt = 1
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 634
maxirow = 34
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0

keys
--------------------------------
681B4FEC: 00af03af 0000000a 3400d008 00000000 ...........4....
681B4FFC: 0001000a 00000000 00010016 00000000 ................
name = smInvBatch0

statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182647062528 RowId = (1:87:7)

Slot 1 Offset 0x12c4
--------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B52C4: 00520030 013f142a 00000000 00000000 0.R.*.?.........
681B52D4: 00020000 00000000 00150000 00010003 ................
681B52E4: 00000000 00000000 00000000 00000000 ................
681B52F4: 00000000 00000000 00260000 0000002c ..........&.,...
681B5304: 00000000 00000000 00000000 00000000 ................
681B5314: 001b0000 00000000 00c00003 80e600d6 ................
681B5324: 00af03af 0000000a 3400d008 00000000 ...........4....
681B5334: 00010016 00000000 00010072 00000000 ........r.......
681B5344: 00af03af 0000000a 3400d008 00000000 ...........4....
681B5354: 000b000a 00000000 000b0016 00000000 ................
681B5364: 00af03af 0000000a 3400d008 00000000 ...........4....
681B5374: 000b000a 00000000 00010016 00030000 ................
681B5384: 006d0073 006e0049 00420076 00740061 s.m.I.n.v.B.a.t.
681B5394: 00680063 00000031 002a869f 00570000 c.h.1.....*...W.
681B53A4: 00010000 0008 ......
id = 20911146
status = 0
first = 0
indid = 2
root = 0
minlen = 21
keycnt = 3
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 38
maxirow = 44
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0

keys
--------------------------------
681B5324: 00af03af 0000000a 3400d008 00000000 ...........4....
681B5334: 00010016 00000000 00010072 00000000 ........r.......
681B5344: 00af03af 0000000a 3400d008 00000000 ...........4....
681B5354: 000b000a 00000000 000b0016 00000000 ................
681B5364: 00af03af 0000000a 3400d008 00000000 ...........4....
681B5374: 000b000a 00000000 00010016 00030000 ................
name = smInvBatch1

statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182647193600 RowId = (1:87:8)

Slot 2 Offset 0x1440
--------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B5440: 00520030 01584911 00004012 000000c6 0.R..IX..@......
681B5450: 00010001 00000095 09a20001 00010001 ................
681B5460: 00000001 00000005 00000005 00000000 ................
681B5470: 00000000 00000003 09ba0000 0000001a ................
681B5480: 00000000 00000096 00000001 00000000 ................
681B5490: 001b0000 00000000 00800003 80a60096 ................
681B54A0: 00340134 00050002 00000000 00000000 4.4.............
681B54B0: 00010020 00000000 000102c1 00000000 ...............
681B54C0: 00700052 00520074 006e0075 00690074 R.p.t.R.u.n.t.i.
681B54D0: 0065006d 00000030 002a87a9 03a00000 m.e.0.....*.....
681B54E0: 00010000 0019 ......
id = 22563089
status = 16402
first = 0
indid = 1
root = 0
minlen = 2466
keycnt = 1
groupid = 1
dpages = 1
reserved = 5
used = 5
rowcnt = 0
rowmodctr = 3
reserved3 = 0
reserved4 = 0
xmaxlen = 2490
maxirow = 26
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0

keys
--------------------------------
681B54A0: 00340134 00050002 00000000 00000000 4.4.............
681B54B0: 00010020 00000000 000102c1 00000000 ...............
name = RptRuntime0

statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182664626176 RowId = (1:928:25)

Slot 3 Offset 0x15bc
--------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B55BC: 00520030 01584911 00000000 000000e6 0.R..IX.........
681B55CC: 00020001 000000e6 00470001 00010003 ..........G.....
681B55DC: 00000001 00000002 00000002 00000000 ................
681B55EC: 00000000 00000000 00580000 0000005e ..........X.^...
681B55FC: 00000000 00000161 00000001 00000000 ....a...........
681B560C: 001b0000 00000000 00c00003 80e600d6 ................
681B561C: 00af03af 00000015 3400d008 00000000 ...........4....
681B562C: 00010008 00000000 0001004b 00000000 ........K.......
681B563C: 00af03af 0000002f 3400d008 00000000 ..../......4....
681B564C: 0016003f 00000000 0016096b 00000000 ?.......k.......
681B565C: 00340134 00050002 00000000 00000000 4.4.............
681B566C: 00450020 00000000 000102c1 00010000 .E.............
681B567C: 00700052 00520074 006e0075 00690074 R.p.t.R.u.n.t.i.
681B568C: 0065006d 00000031 002a87ab 3eb70000 m.e.1.....*....>
681B569C: 00010000 0004 ......
id = 22563089
status = 0
first = 0
indid = 2
root = 0
minlen = 71
keycnt = 3
groupid = 1
dpages = 1
reserved = 2
used = 2
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 88
maxirow = 94
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0

keys
--------------------------------
681B561C: 00af03af 00000015 3400d008 00000000 ...........4....
681B562C: 00010008 00000000 0001004b 00000000 ........K.......
681B563C: 00af03af 0000002f 3400d008 00000000 ..../......4....
681B564C: 0016003f 00000000 0016096b 00000000 ?.......k.......
681B565C: 00340134 00050002 00000000 00000000 4.4.............
681B566C: 00450020 00000000 000102c1 00010000 .E.............
name = RptRuntime1

statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182664757248 RowId = (1:16055:4)

Slot 4 Offset 0xc04
-------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B4C04: 00520030 0175b502 00004012 00000000 0.R...u..@......
681B4C14: 00010000 00000000 040c0000 00010001 ................
681B4C24: 00000000 00000000 00000000 00000000 ................
681B4C34: 00000000 00000000 04270000 00000022 ..........'."...
681B4C44: 00000000 00000000 00000000 00000000 ................
681B4C54: 001b0000 00000000 00800003 80a60096 ................
681B4C64: 00af03af 0000000a 3400d008 00000000 ...........4....
681B4C74: 0001004e 00000000 000103e6 00000000 N...............
681B4C84: 006f0057 006b0072 00650043 0074006e W.o.r.k.C.e.n.t.
681B4C94: 00720065 00000030 002a84b7 55880000 e.r.0.....*....U
681B4CA4: 00010000 0007 ......
id = 24491266
status = 16402
first = 0
indid = 1
root = 0
minlen = 1036
keycnt = 1
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 1063
maxirow = 34
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0

keys
--------------------------------
681B4C64: 00af03af 0000000a 3400d008 00000000 ...........4....
681B4C74: 0001004e 00000000 000103e6 00000000 N...............
name = WorkCenter0

statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182615212032 RowId = (1:21896:7)

Slot 5 Offset 0xb64
-------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B4B64: 00520030 01ab548a 00004012 00000000 0.R..T...@......
681B4B74: 00010000 00000000 038e0000 00010001 ................
681B4B84: 00000000 00000000 00000000 00000000 ................
681B4B94: 00000000 00000000 03b00000 0000001a ................
681B4BA4: 00000000 00000000 00000000 00000000 ................
681B4BB4: 001b0000 00000000 00800003 80a00090 ................
681B4BC4: 00af03af 00000002 3400d008 00000000 ...........4....
681B4BD4: 0001007b 00000000 000102bb 00000000 {...............
681B4BE4: 004f0053 00650053 00750074 00300070 S.O.S.e.t.u.p.0.
681B4BF4: 84010000 0000002a 00000f23 00070001 ....*...#.......
id = 28005514
status = 16402
first = 0
indid = 1
root = 0
minlen = 910
keycnt = 1
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 944
maxirow = 26
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0

keys
--------------------------------
681B4BC4: 00af03af 00000002 3400d008 00000000 ...........4....
681B4BD4: 0001007b 00000000 000102bb 00000000 {...............
name = SOSetup0

statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182603284480 RowId = (1:3875:7)

Slot 6 Offset 0x58c
-------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B458C: 00520030 01c4f563 00004012 00000000 0.R.c....@......
681B459C: 00010000 00000000 04c70000 00010002 ................
681B45AC: 00000000 00000000 00000000 00000000 ................
681B45BC: 00000000 00000000 04e80000 00000027 ............'...
681B45CC: 00000000 00000000 00000000 00000000 ................
681B45DC: 001b0000 00000000 00a00003 80c400b4 ................
681B45EC: 00af03af 0000000a 3400d008 00000000 ...........4....
681B45FC: 00010034 00000000 0001016e 00000000 4.......n.......
681B460C: 00af03af 00000005 3400d008 00000000 ...........4....
681B461C: 000b002a 00000000 000b0135 00000000 *.......5.......
681B462C: 00750050 004f0072 00640072 00650044 P.u.r.O.r.d.D.e.
681B463C: 00300074 82fd0000 0000002a 0000068a t.0.....*.......
681B464C: 00490001 ..I.
id = 29685091
status = 16402
first = 0
indid = 1
root = 0
minlen = 1223
keycnt = 2
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 1256
maxirow = 39
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0

keys
--------------------------------
681B45EC: 00af03af 0000000a 3400d008 00000000 ...........4....
681B45FC: 00010034 00000000 0001016e 00000000 4.......n.......
681B460C: 00af03af 00000005 3400d008 00000000 ...........4....
681B461C: 000b002a 00000000 000b0135 00000000 *.......5.......
name = PurOrdDet0

statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182586245120 RowId = (1:1674:73)

Slot 7 Offset 0x650
-------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B4650: 00520030 01c4f563 00000000 00000000 0.R.c...........
681B4660: 00020000 00000000 002e0000 00010003 ................
681B4670: 00000000 00000000 00000000 00000000 ................
681B4680: 00000000 00000000 003f0000 00000045 ..........?.E...
681B4690: 00000000 00000000 00000000 00000000 ................
681B46A0: 001b0000 00000000 00c00003 80e400d4 ................
681B46B0: 00af03af 0000001e 3400d008 00000000 ...........4....
681B46C0: 00010024 00000000 00010109 00000000 $...............
681B46D0: 00af03af 0000000a 3400d008 00000000 ...........4....
681B46E0: 001f0034 00000000 0001016e 00010000 4.......n.......
681B46F0: 00af03af 00000005 3400d008 00000000 ...........4....
681B4700: 0029002a 00000000 000b0135 00010000 *.).....5.......
681B4710: 00750050 004f0072 00640072 00650044 P.u.r.O.r.d.D.e.
681B4720: 00310074 83040000 0000002a 0000068a t.1.....*.......
681B4730: 004a0001 ..J.
id = 29685091
status = 0
first = 0
indid = 2
root = 0
minlen = 46
keycnt = 3
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 63
maxirow = 69
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0

keys
--------------------------------
681B46B0: 00af03af 0000001e 3400d008 00000000 ...........4....
681B46C0: 00010024 00000000 00010109 00000000 $...............
681B46D0: 00af03af 0000000a 3400d008 00000000 ...........4....
681B46E0: 001f0034 00000000 0001016e 00010000 4.......n.......
681B46F0: 00af03af 00000005 3400d008 00000000 ...........4....
681B4700: 0029002a 00000000 000b0135 00010000 *.).....5.......
name = PurOrdDet1

statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182586703872 RowId = (1:1674:74)

Slot 8 Offset 0x734
-------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B4734: 00520030 01c4f563 00000000 00000000 0.R.c...........
681B4744: 00030000 00000000 00340000 00010004 ..........4.....
681B4754: 00000000 00000000 00000000 00000000 ................
681B4764: 00000000 00000000 00450000 0000004b ..........E.K...
681B4774: 00000000 00000000 00000000 00000000 ................
681B4784: 001b0000 00000000 00e00003 810400f4 ................
681B4794: 00af03af 00000006 3400d008 00000000 ...........4....
681B47A4: 00010044 00000000 000101ea 00000000 D...............
681B47B4: 00af03af 0000001e 3400d008 00000000 ...........4....
681B47C4: 00070024 00000000 00070109 00000000 $...............
681B47D4: 00af03af 0000000a 3400d008 00000000 ...........4....
681B47E4: 00250034 00000000 0001016e 00010000 4.%.....n.......
681B47F4: 00af03af 00000005 3400d008 00000000 ...........4....
681B4804: 002f002a 00000000 000b0135 00010000 *./.....5.......
681B4814: 00750050 004f0072 00640072 00650044 P.u.r.O.r.d.D.e.
681B4824: 00320074 83050000 0000002a 0000068a t.2.....*.......
681B4834: 004b0001 ..K.
id = 29685091
status = 0
first = 0
indid = 3
root = 0
minlen = 52
keycnt = 4
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 69
maxirow = 75
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0

keys
--------------------------------
681B4794: 00af03af 00000006 3400d008 00000000 ...........4....
681B47A4: 00010044 00000000 000101ea 00000000 D...............
681B47B4: 00af03af 0000001e 3400d008 00000000 ...........4....
681B47C4: 00070024 00000000 00070109 00000000 $...............
681B47D4: 00af03af 0000000a 3400d008 00000000 ...........4....
681B47E4: 00250034 00000000 0001016e 00010000 4.%.....n.......
681B47F4: 00af03af 00000005 3400d008 00000000 ...........4....
681B4804: 002f002a 00000000 000b0135 00010000 *./.....5.......
name = PurOrdDet2

statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182586769408 RowId = (1:1674:75)

Slot 9 Offset 0x838
-------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B4838: 00520030 01c4f563 00000000 00000000 0.R.c...........
681B4848: 00040000 00000000 00120000 00010005 ................
681B4858: 00000000 00000000 00000000 00000000 ................
681B4868: 00000000 00000000 00230000 00000029 ..........#.)...
681B4878: 00000000 00000000 00000000 00000000 ................
681B4888: 001b0000 00000000 01000003 81240114 ..............$.
681B4898: 00af03af 0000000a 3400d008 00000000 ...........4....
681B48A8: 00010034 00000000 0001016e 00000000 4.......n.......
681B48B8: 00af03af 00000005 3400d008 00000000 ...........4....
681B48C8: 000b002a 00000000 000b0135 00000000 *.......5.......
681B48D8: 00340134 00050002 00000000 00000000 4.4.............
681B48E8: 00100029 00000000 00100133 00000000 ).......3.......
681B48F8: 00af03af 0000000a 3400d008 00000000 ...........4....
681B4908: 00010034 00000000 0001016e 00030000 4.......n.......
681B4918: 00af03af 00000005 3400d008 00000000 ...........4....
681B4928: 000b002a 00000000 000b0135 00030000 *.......5.......
681B4938: 00750050 004f0072 00640072 00650044 P.u.r.O.r.d.D.e.
681B4948: 00330074 83060000 0000002a 0000068a t.3.....*.......
681B4958: 004c0001 ..L.
id = 29685091
status = 0
first = 0
indid = 4
root = 0
minlen = 18
keycnt = 5
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 35
maxirow = 41
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0

keys
--------------------------------
681B4898: 00af03af 0000000a 3400d008 00000000 ...........4....
681B48A8: 00010034 00000000 0001016e 00000000 4.......n.......
681B48B8: 00af03af 00000005 3400d008 00000000 ...........4....
681B48C8: 000b002a 00000000 000b0135 00000000 *.......5.......
681B48D8: 00340134 00050002 00000000 00000000 4.4.............
681B48E8: 00100029 00000000 00100133 00000000 ).......3.......
681B48F8: 00af03af 0000000a 3400d008 00000000 ...........4....
681B4908: 00010034 00000000 0001016e 00030000 4.......n.......
681B4918: 00af03af 00000005 3400d008 00000000 ...........4....
681B4928: 000b002a 00000000 000b0135 00030000 *.......5.......
name = PurOrdDet3

statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182586834944 RowId = (1:1674:76)

Slot 10 Offset 0x95c
--------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B495C: 00520030 01c4f563 00000000 00000000 0.R.c...........
681B496C: 00050000 00000000 003a0000 00010005 ..........:.....
681B497C: 00000000 00000000 00000000 00000000 ................
681B498C: 00000000 00000000 004b0000 00000051 ..........K.Q...
681B499C: 00000000 00000000 00000000 00000000 ................
681B49AC: 001b0000 00000000 01000003 81240114 ..............$.
681B49BC: 00af03af 0000001e 3400d008 00000000 ...........4....
681B49CC: 00010024 00000000 00010109 00000000 $...............
681B49DC: 00af03af 0000000a 3400d008 00000000 ...........4....
681B49EC: 001f005e 00000000 001f032b 00000000 ^.......+.......
681B49FC: 00340134 00050002 00000000 00000000 4.4.............
681B4A0C: 0029002f 00000000 00290154 00000000 /.).....T.).....
681B4A1C: 00af03af 0000000a 3400d008 00000000 ...........4....
681B4A2C: 002b0034 00000000 0001016e 00010000 4.+.....n.......
681B4A3C: 00af03af 00000005 3400d008 00000000 ...........4....
681B4A4C: 0035002a 00000000 000b0135 00010000 *.5.....5.......
681B4A5C: 00750050 004f0072 00640072 00650044 P.u.r.O.r.d.D.e.
681B4A6C: 00340074 83070000 0000002a 0000068a t.4.....*.......
681B4A7C: 004d0001 ..M.
id = 29685091
status = 0
first = 0
indid = 5
root = 0
minlen = 58
keycnt = 5
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 75
maxirow = 81
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0

keys
--------------------------------
681B49BC: 00af03af 0000001e 3400d008 00000000 ...........4....
681B49CC: 00010024 00000000 00010109 00000000 $...............
681B49DC: 00af03af 0000000a 3400d008 00000000 ...........4....
681B49EC: 001f005e 00000000 001f032b 00000000 ^.......+.......
681B49FC: 00340134 00050002 00000000 00000000 4.4.............
681B4A0C: 0029002f 00000000 00290154 00000000 /.).....T.).....
681B4A1C: 00af03af 0000000a 3400d008 00000000 ...........4....
681B4A2C: 002b0034 00000000 0001016e 00010000 4.+.....n.......
681B4A3C: 00af03af 00000005 3400d008 00000000 ...........4....
681B4A4C: 0035002a 00000000 000b0135 00010000 *.5.....5.......
name = PurOrdDet4

statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182586900480 RowId = (1:1674:77)

Slot 11 Offset 0xa80
--------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B4A80: 00520030 01c4f563 00000000 00000000 0.R.c...........
681B4A90: 00060000 00000000 00200000 00010003 .......... .....
681B4AA0: 00000000 00000000 00000000 00000000 ................
681B4AB0: 00000000 00000000 00310000 00000037 ..........1.7...
681B4AC0: 00000000 00000000 00000000 00000000 ................
681B4AD0: 001b0000 00000000 00c00003 80e400d4 ................
681B4AE0: 00af03af 00000010 3400d008 00000000 ...........4....
681B4AF0: 00010036 00000000 0001017a 00000000 6.......z.......
681B4B00: 00af03af 0000000a 3400d008 00000000 ...........4....
681B4B10: 00110034 00000000 0001016e 00010000 4.......n.......
681B4B20: 00af03af 00000005 3400d008 00000000 ...........4....
681B4B30: 001b002a 00000000 000b0135 00010000 *.......5.......
681B4B40: 00750050 004f0072 00640072 00650044 P.u.r.O.r.d.D.e.
681B4B50: 00350074 83080000 0000002a 0000068a t.5.....*.......
681B4B60: 004e0001 ..N.
id = 29685091
status = 0
first = 0
indid = 6
root = 0
minlen = 32
keycnt = 3
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 49
maxirow = 55
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0

keys
--------------------------------
681B4AE0: 00af03af 00000010 3400d008 00000000 ...........4....
681B4AF0: 00010036 00000000 0001017a 00000000 6.......z.......
681B4B00: 00af03af 0000000a 3400d008 00000000 ...........4....
681B4B10: 00110034 00000000 0001016e 00010000 4.......n.......
681B4B20: 00af03af 00000005 3400d008 00000000 ...........4....
681B4B30: 001b002a 00000000 000b0135 00010000 *.......5.......
name = PurOrdDet5

statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182586966016 RowId = (1:1674:78)

Slot 12 Offset 0xcac
--------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B4CAC: 00520030 01c4f563 00000000 00000000 0.R.c...........
681B4CBC: 00070000 00000000 00110000 00010003 ................
681B4CCC: 00000000 00000000 00000000 00000000 ................
681B4CDC: 00000000 00000000 00220000 00000028 ..........".(...
681B4CEC: 00000000 00000000 00000000 00000000 ................
681B4CFC: 001b0000 00000000 00c00003 80ee00de ................
681B4D0C: 00af03af 00000001 3400d008 00000000 ...........4....
681B4D1C: 00010033 00000000 0001016d 00000000 3.......m.......
681B4D2C: 00af03af 0000000a 3400d008 00000000 ...........4....
681B4D3C: 00020034 00000000 0001016e 00010000 4.......n.......
681B4D4C: 00af03af 00000005 3400d008 00000000 ...........4....
681B4D5C: 000c002a 00000000 000b0135 00010000 *.......5.......
681B4D6C: 00750070 006f0072 00640072 00650064 p.u.r.o.r.d.d.e.
681B4D7C: 005f0074 00740073 00610072 0000006e t._.s.t.r.a.n...
681B4D8C: 002a84c7 78450000 00010000 001d ..*...Ex......
id = 29685091
status = 0
first = 0
indid = 7
root = 0
minlen = 17
keycnt = 3
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 34
maxirow = 40
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0

keys
--------------------------------
681B4D0C: 00af03af 00000001 3400d008 00000000 ...........4....
681B4D1C: 00010033 00000000 0001016d 00000000 3.......m.......
681B4D2C: 00af03af 0000000a 3400d008 00000000 ...........4....
681B4D3C: 00020034 00000000 0001016e 00010000 4.......n.......
681B4D4C: 00af03af 00000005 3400d008 00000000 ...........4....
681B4D5C: 000c002a 00000000 000b0135 00010000 *.......5.......
name = purorddet_stran

statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182616260608 RowId = (1:30789:29)

Slot 13 Offset 0xd4
-------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B40D4: 00520030 01d345b0 00004012 00000000 0.R..E...@......
681B40E4: 00010000 00000000 019b0000 00010006 ................
681B40F4: 00000000 00000000 00000000 00000000 ................
681B4104: 00000000 00000000 01b00000 0000007b ............{...
681B4114: 00000000 00000000 00000000 00000000 ................
681B4124: 001b0000 00000000 01200003 81460136 .......... .6.F.
681B4134: 00af03af 0000001e 3400d008 00000000 ...........4....
681B4144: 00010008 00000000 00010041 00000000 ........A.......
681B4154: 00af03af 00000004 3400d008 00000000 ...........4....
681B4164: 001f0007 00000000 001f003d 00000000 ........=.......
681B4174: 00af03af 0000001e 3400d008 00000000 ...........4....
681B4184: 00230010 00000000 00230084 00000000 ..#.......#.....
681B4194: 00af03af 00000001 3400d008 00000000 ...........4....
681B41A4: 00410006 00000000 0041003c 00000000 ..A.....<.A.....
681B41B4: 00af03af 00000004 3400d008 00000000 ...........4....
681B41C4: 00420004 00000000 0042001a 00000000 ..B.......B.....
681B41D4: 00af03af 0000001e 3400d008 00000000 ...........4....
681B41E4: 00460005 00000000 0046001e 00000000 ..F.......F.....
681B41F4: 0070004f 00440074 00700065 00780045 O.p.t.D.e.p.E.x.
681B4204: 006c0063 00000030 002a8221 4d150000 c.l.0...!.*....M
681B4214: 00010000 003f ....?.
id = 30623152
status = 16402
first = 0
indid = 1
root = 0
minlen = 411
keycnt = 6
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 432
maxirow = 123
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0

keys
--------------------------------
681B4134: 00af03af 0000001e 3400d008 00000000 ...........4....
681B4144: 00010008 00000000 00010041 00000000 ........A.......
681B4154: 00af03af 00000004 3400d008 00000000 ...........4....
681B4164: 001f0007 00000000 001f003d 00000000 ........=.......
681B4174: 00af03af 0000001e 3400d008 00000000 ...........4....
681B4184: 00230010 00000000 00230084 00000000 ..#.......#.....
681B4194: 00af03af 00000001 3400d008 00000000 ...........4....
681B41A4: 00410006 00000000 0041003c 00000000 ..A.....<.A.....
681B41B4: 00af03af 00000004 3400d008 00000000 ...........4....
681B41C4: 00420004 00000000 0042001a 00000000 ..B.......B.....
681B41D4: 00af03af 0000001e 3400d008 00000000 ...........4....
681B41E4: 00460005 00000000 0046001e 00000000 ..F.......F.....
name = OptDepExcl0

statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182571827200 RowId = (1:19733:63)

Slot 14 Offset 0x21c
--------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B421C: 00520030 01d345b0 00000000 00000000 0.R..E..........
681B422C: 00020000 00000000 00640000 00010008 ..........d.....
681B423C: 00000000 00000000 00000000 00000000 ................
681B424C: 00000000 00000000 00750000 0000007b ..........u.{...
681B425C: 00000000 00000000 00000000 00000000 ................
681B426C: 001b0000 00000000 01600003 81860176 ..........`.v...
681B427C: 00af03af 0000001e 3400d008 00000000 ...........4....
681B428C: 00010005 00000000 0001001e 00000000 ................
681B429C: 00af03af 00000004 3400d008 00000000 ...........4....
681B42AC: 001f0004 00000000 001f001a 00000000 ................
681B42BC: 00af03af 0000001e 3400d008 00000000 ...........4....
681B42CC: 00230008 00000000 00010041 00010000 ..#.....A.......
681B42DC: 00af03af 00000004 3400d008 00000000 ...........4....
681B42EC: 00410007 00000000 001f003d 00010000 ..A.....=.......
681B42FC: 00af03af 0000001e 3400d008 00000000 ...........4....
681B430C: 00450010 00000000 00230084 00010000 ..E.......#.....
681B431C: 00af03af 00000001 3400d008 00000000 ...........4....
681B432C: 00630006 00000000 0041003c 00010000 ..c.....<.A.....
681B433C: 00af03af 00000004 3400d008 00000000 ...........4....
681B434C: 001f0004 00000000 0042001a 00030000 ..........B.....
681B435C: 00af03af 0000001e 3400d008 00000000 ...........4....
681B436C: 00010005 00000000 0046001e 00030000 ..........F.....
681B437C: 0070004f 00440074 00700065 00780045 O.p.t.D.e.p.E.x.
681B438C: 006c0063 00000031 002a8224 4d150000 c.l.1...$.*....M
681B439C: 00010000 0040 ....@.
id = 30623152
status = 0
first = 0
indid = 2
root = 0
minlen = 100
keycnt = 8
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 117
maxirow = 123
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0

keys
--------------------------------
681B427C: 00af03af 0000001e 3400d008 00000000 ...........4....
681B428C: 00010005 00000000 0001001e 00000000 ................
681B429C: 00af03af 00000004 3400d008 00000000 ...........4....
681B42AC: 001f0004 00000000 001f001a 00000000 ................
681B42BC: 00af03af 0000001e 3400d008 00000000 ...........4....
681B42CC: 00230008 00000000 00010041 00010000 ..#.....A.......
681B42DC: 00af03af 00000004 3400d008 00000000 ...........4....
681B42EC: 00410007 00000000 001f003d 00010000 ..A.....=.......
681B42FC: 00af03af 0000001e 3400d008 00000000 ...........4....
681B430C: 00450010 00000000 00230084 00010000 ..E.......#.....
681B431C: 00af03af 00000001 3400d008 00000000 ...........4....
681B432C: 00630006 00000000 0041003c 00010000 ..c.....<.A.....
681B433C: 00af03af 00000004 3400d008 00000000 ...........4....
681B434C: 001f0004 00000000 0042001a 00030000 ..........B.....
681B435C: 00af03af 0000001e 3400d008 00000000 ...........4....
681B436C: 00010005 00000000 0046001e 00030000 ..........F.....
name = OptDepExcl1

statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182572023808 RowId = (1:19733:64)

Slot 15 Offset 0x3a4
--------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B43A4: 00520030 01d345b0 00000000 00000000 0.R..E..........
681B43B4: 00030000 00000000 00660000 0001000b ..........f.....
681B43C4: 00000000 00000000 00000000 00000000 ................
681B43D4: 00000000 00000000 00770000 0000007d ..........w.}...
681B43E4: 00000000 00000000 00000000 00000000 ................
681B43F4: 001b0000 00000000 01c00003 81e601d6 ................
681B4404: 00af03af 0000001e 3400d008 00000000 ...........4....
681B4414: 00010008 00000000 00010041 00000000 ........A.......
681B4424: 00af03af 00000004 3400d008 00000000 ...........4....
681B4434: 001f0007 00000000 001f003d 00000000 ........=.......
681B4444: 00af03af 0000001e 3400d008 00000000 ...........4....
681B4454: 00230010 00000000 00230084 00000000 ..#.......#.....
681B4464: 00af03af 00000001 3400d008 00000000 ...........4....
681B4474: 00410006 00000000 0041003c 00000000 ..A.....<.A.....
681B4484: 00340134 00050002 00000000 00000000 4.4.............
681B4494: 0042000a 00000000 00420063 00000000 ..B.....c.B.....
681B44A4: 00af03af 0000001e 3400d008 00000000 ...........4....
681B44B4: 00010008 00000000 00010041 00030000 ........A.......
681B44C4: 00af03af 00000004 3400d008 00000000 ...........4....
681B44D4: 001f0007 00000000 001f003d 00030000 ........=.......
681B44E4: 00af03af 0000001e 3400d008 00000000 ...........4....
681B44F4: 00230010 00000000 00230084 00030000 ..#.......#.....
681B4504: 00af03af 00000001 3400d008 00000000 ...........4....
681B4514: 00410006 00000000 0041003c 00030000 ..A.....<.A.....
681B4524: 00af03af 00000004 3400d008 00000000 ...........4....
681B4534: 00440004 00000000 0042001a 00010000 ..D.......B.....
681B4544: 00af03af 0000001e 3400d008 00000000 ...........4....
681B4554: 00480005 00000000 0046001e 00010000 ..H.......F.....
681B4564: 0070004f 00440074 00700065 00780045 O.p.t.D.e.p.E.x.
681B4574: 006c0063 00000032 002a8225 4d150000 c.l.2...%.*....M
681B4584: 00010000 0041 ....A.
id = 30623152
status = 0
first = 0
indid = 3
root = 0
minlen = 102
keycnt = 11
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 119
maxirow = 125
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0

keys
--------------------------------
681B4404: 00af03af 0000001e 3400d008 00000000 ...........4....
681B4414: 00010008 00000000 00010041 00000000 ........A.......
681B4424: 00af03af 00000004 3400d008 00000000 ...........4....
681B4434: 001f0007 00000000 001f003d 00000000 ........=.......
681B4444: 00af03af 0000001e 3400d008 00000000 ...........4....
681B4454: 00230010 00000000 00230084 00000000 ..#.......#.....
681B4464: 00af03af 00000001 3400d008 00000000 ...........4....
681B4474: 00410006 00000000 0041003c 00000000 ..A.....<.A.....
681B4484: 00340134 00050002 00000000 00000000 4.4.............
681B4494: 0042000a 00000000 00420063 00000000 ..B.....c.B.....
681B44A4: 00af03af 0000001e 3400d008 00000000 ...........4....
681B44B4: 00010008 00000000 00010041 00030000 ........A.......
681B44C4: 00af03af 00000004 3400d008 00000000 ...........4....
681B44D4: 001f0007 00000000 001f003d 00030000 ........=.......
681B44E4: 00af03af 0000001e 3400d008 00000000 ...........4....
681B44F4: 00230010 00000000 00230084 00030000 ..#.......#.....
681B4504: 00af03af 00000001 3400d008 00000000 ...........4....
681B4514: 00410006 00000000 0041003c 00030000 ..A.....<.A.....
681B4524: 00af03af 00000004 3400d008 00000000 ...........4....
681B4534: 00440004 00000000 0042001a 00010000 ..D.......B.....
681B4544: 00af03af 0000001e 3400d008 00000000 ...........4....
681B4554: 00480005 00000000 0046001e 00010000 ..H.......F.....
name = OptDepExcl2

statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182572089344 RowId = (1:19733:65)

DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Now, the bad news. I am a bit of a novice and have picked this up from someone who left my company. It appears the latch error has been around for some time and only reared up when I instituted a new back up system that runs a dbcc check befor backing up. I don't think I have any clean backups.

Any help would be greatly appreciated.

Alex Mauer

View 17 Replies View Related

Using Colors In HTML Heading And Also Printing Colors To Failure / DBCC CHECKDB Error?

Apr 14, 2015

I need to print in RED if there's atleast 1 or more consistency error and need a heading color of the table (Caption) how to do it.

DECLARE @tableHTML NVARCHAR(MAX) ;
SET @tableHTML =
N'<H1>DB Corruption Report:</H1>' +
N'<table border="1">' +
N'<tr><th>DBName</th><th>MessageText</th>' +

[code]....

View 1 Replies View Related

SQL Server 2012 :: Error Creating Temp Table Based On IF Logic

Nov 13, 2014

I could deploy across my environment, which is a mix of 2008R2/2012 servers, to give some information on log files. Running into a silly issue right off the bat. The table that DBCC LogInfo() conjures out of magic is different between the two. In 2012 it gained the RecoveryUnitID column. So I'm trying to write some logic to create a temp table based on which version is running. I would like to avoid a global temp table if possible. Here's what I've tried:

sp_executesql creates a table outside of the scope of my session:
DECLARE @PrVers NVARCHAR(128)
, @PrVersNum DECIMAL(10,2)
, @StageTable NVARCHAR(1024) = N''

[code]....

View 9 Replies View Related

DBCC Consistency Errors

Dec 12, 2005

I would need help to debug the following allocation errors on DBCC:

Msg 2576, Sev 16: IAM page (0:0) is pointed to by the previous pointer of IAM page (1:958608) object ID 16 index ID 0 but was not detected in the scan. [SQLSTATE 42000]
Msg 2576, Sev 16: IAM page (0:0) is pointed to by the previous pointer of IAM page (1:985853) object ID 16 index ID 2 but was not detected in the scan. [SQLSTATE 42000]
Msg 2576, Sev 16: IAM page (0:0) is pointed to by the previous pointer of IAM page (1:958600) object ID 16 index ID 255 but was not detected in the scan. [SQLSTATE 42000]
Msg 2576, Sev 16: IAM page (0:0) is pointed to by the previous pointer of IAM page (1:1067763) object ID 17 index ID 0 but was not detected in the scan. [SQLSTATE 42000]
Msg 2576, Sev 16: IAM page (0:0) is pointed to by the previous pointer of IAM page (1:1120026) object ID 17 index ID 2 but was not detected in the scan. [SQLSTATE 42000]
Msg 2576, Sev 16: IAM page (0:0) is pointed to by the previous pointer of IAM page (1:1154482) object ID 17 index ID 3 but was not detected in the scan. [SQLSTATE 42000]
Msg 2536, Sev 16: DBCC results for 'SalesHistoryDB'. [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'sysobjects'. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 289 rows in 7 pages for object 'sysobjects'. [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'sysindexes'. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 277 rows in 19 pages for object 'sysindexes'. [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'syscolumns'. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 1809 rows in 43 pages for object 'syscolumns'. [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'systypes'. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 28 rows in 1 pages for object 'systypes'. [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'syscomments'. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 301 rows in 101 pages for object 'syscomments'. [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'sysfiles1'. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 2 rows in 1 pages for object 'sysfiles1'. [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'syspermissions'. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 311 rows in 3 pages for object 'syspermissions'. [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'sysusers'. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 28 rows in 1 pages for object 'sysusers'. [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'sysproperties'. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 199 rows in 6 pages for object 'sysproperties'. [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'sysdepends'. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 1768 rows in 11 pages for object 'sysdepends'. [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'sysreferences'. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 0 rows in 1 pages for object 'sysreferences'. [SQLSTATE 01000]
Msg 8990, Sev 16: CHECKDB found 3 allocation errors and 0 consistency errors in table '(Object ID 16)' (object ID 16). [SQLSTATE 01000]
Msg 8990, Sev 16: CHECKDB found 3 allocation errors and 0 consistency errors in table '(Object ID 17)' (object ID 17). [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'sysfulltextcatalogs'. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 0 rows in 1 pages for object 'sysfulltextcatalogs'. [SQLSTATE 01000]
DBCC results for 'sysfulltextnotify'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'sysfulltextnotify'. [SQLSTATE 01000]
DBCC results for 'sysfilegroups'. [SQLSTATE 01000]
There are 1 rows in 1 pages for object 'sysfilegroups'. [SQLSTATE 01000]
DBCC results for 'IgnoreSalesRep'. [SQLSTATE 01000]
There are 406 rows in 2 pages for object 'IgnoreSalesRep'. [SQLSTATE 01000]
DBCC results for 'invnsrc'. [SQLSTATE 01000]
There are 6101966 rows in 15067 pages for object 'invnsrc'. [SQLSTATE 01000]
DBCC results for 'INVO_ERRS'. [SQLSTATE 01000]
There are 333 rows in 12 pages for object 'INVO_ERRS'. [SQLSTATE 01000]
DBCC results for 'INVO_ERRS_old'. [SQLSTATE 01000]
There are 152 rows in 3 pages for object 'INVO_ERRS_old'. [SQLSTATE 01000]
DBCC results for 'INVO_HIST'. [SQLSTATE 01000]
There are 55159551 rows in 937501 pages for object 'INVO_HIST'. [SQLSTATE 01000]
DBCC results for 'INVO_HIST_SMALL'. [SQLSTATE 01000]
There are 1124659 rows in 21220 pages for object 'INVO_HIST_SMALL'. [SQLSTATE 01000]
DBCC results for 'InvoiceHistory'. [SQLSTATE 01000]
There are 0 rows in 1 pages for object 'InvoiceHistory'. [SQLSTATE 01000]
DBCC results for 'QUAR_INVO_HIST'. [SQLSTATE 01000]
There are 1430739 rows in 5379 pages for object 'QUAR_INVO_HIST'. [SQLSTATE 01000]
DBCC results for 'MARKETING_REPORTS'. [SQLSTATE 01000]
There are 36371 rows in 151 pages for object 'MARKETING_REPORTS'. [SQLSTATE 01000]
DBCC results for 'MKP90'. [SQLSTATE 01000]
There are 36030746 rows in 205890 pages for object 'MKP90'. [SQLSTATE 01000]
DBCC results for 'MR_CLASS_MANU'. [SQLSTATE 01000]
There are 12159 rows in 46 pages for object 'MR_CLASS_MANU'. [SQLSTATE 01000]
DBCC results for 'MR_GROUP_MANU'. [SQLSTATE 01000]
There are 16889 rows in 66 pages for object 'MR_GROUP_MANU'. [SQLSTATE 01000]
DBCC results for 'MR_MANU_CLASS'. [SQLSTATE 01000]
There are 4876 rows in 19 pages for object 'MR_MANU_CLASS'. [SQLSTATE 01000]
DBCC results for 'MR_MANU_GROUP'. [SQLSTATE 01000]
There are 15565 rows in 61 pages for object 'MR_MANU_GROUP'. [SQLSTATE 01000]
DBCC results for 'PseudoLeaders'. [SQLSTATE 01000]
There are 79 rows in 2 pages for object 'PseudoLeaders'. [SQLSTATE 01000]
DBCC results for 'InvoiceHeader'. [SQLSTATE 01000]
There are 0 rows in 1 pages for object 'InvoiceHeader'. [SQLSTATE 01000]
DBCC results for 'FedTeamGoals'. [SQLSTATE 01000]
There are 0 rows in 1 pages for object 'FedTeamGoals'. [SQLSTATE 01000]
DBCC results for 'SALES_MODIFIER'. [SQLSTATE 01000]
There are 1 rows in 1 pages for object 'SALES_MODIFIER'. [SQLSTATE 01000]
DBCC results for 'FedTeamPlayers'. [SQLSTATE 01000]
There are 0 rows in 1 pages for object 'FedTeamPlayers'. [SQLSTATE 01000]
DBCC results for 'CGTempWMS'. [SQLSTATE 01000]
There are 25 rows in 1 pages for object 'CGTempWMS'. [SQLSTATE 01000]
DBCC results for 'srcinvn'. [SQLSTATE 01000]
There are 1 rows in 1 pages for object 'srcinvn'. [SQLSTATE 01000]
DBCC results for 'TEMP_ExtranetData'. [SQLSTATE 01000]
There are 0 rows in 1 pages for object 'TEMP_ExtranetData'. [SQLSTATE 01000]
DBCC results for 'EMP10'. [SQLSTATE 01000]
There are 113373 rows in 1471 pages for object 'EMP10'. [SQLSTATE 01000]
DBCC results for 'EMP10_UNIQUE'. [SQLSTATE 01000]
There are 18947 rows in 245 pages for object 'EMP10_UNIQUE'. [SQLSTATE 01000]
DBCC results for 'ITEM_SALES_306090'. [SQLSTATE 01000]
There are 310629 rows in 929 pages for object 'ITEM_SALES_306090'. [SQLSTATE 01000]
DBCC results for 'temp_SalesSummaryData'. [SQLSTATE 01000]
There are 45781 rows in 751 pages for object 'temp_SalesSummaryData'. [SQLSTATE 01000]
DBCC results for 'Rob_DeletedFromCustomerPricingMatrix20031107'. [SQLSTATE 01000]
There are 1469 rows in 6 pages for object 'Rob_DeletedFromCustomerPricingMatrix20031107'. [SQLSTATE 01000]
DBCC results for 'COMMISSION_ADJ'. [SQLSTATE 01000]
There are 1645553 rows in 37801 pages for object 'COMMISSION_ADJ'. [SQLSTATE 01000]
DBCC results for 'SalesSummaryData'. [SQLSTATE 01000]
There are 2288331 rows in 36372 pages for object 'SalesSummaryData'. [SQLSTATE 01000]
DBCC results for 'CDW_CODB'. [SQLSTATE 01000]
There are 2 rows in 1 pages for object 'CDW_CODB'. [SQLSTATE 01000]
DBCC results for 'dtproperties'. [SQLSTATE 01000]
There are 14 rows in 1 pages for object 'dtproperties'. [SQLSTATE 01000]
DBCC results for 'Temp_SalesData_new'. [SQLSTATE 01000]
There are 7275 rows in 94 pages for object 'Temp_SalesData_new'. [SQLSTATE 01000]
DBCC results for 'MKP97'. [SQLSTATE 01000]
There are 818535 rows in 6628 pages for object 'MKP97'. [SQLSTATE 01000]
DBCC results for 'MARKETING_REPORTS_Saved'. [SQLSTATE 01000]
There are 28431 rows in 113 pages for object 'MARKETING_REPORTS_Saved'. [SQLSTATE 01000]
DBCC results for 'Commission_Adjustment'. [SQLSTATE 01000]
There are 0 rows in 1 pages for object 'Commission_Adjustment'. [SQLSTATE 01000]
DBCC results for 'F1730A'. [SQLSTATE 01000]
There are 1124104 rows in 16059 pages for object 'F1730A'. [SQLSTATE 01000]
DBCC results for 'OEP80U'. [SQLSTATE 01000]
There are 1357451 rows in 11634 pages for object 'OEP80U'. [SQLSTATE 01000]
DBCC results for 'OE40LN'. [SQLSTATE 01000]
There are 1281910 rows in 10155 pages for object 'OE40LN'. [SQLSTATE 01000]
DBCC results for 'sysarticles'. [SQLSTATE 01000]
There are 2 rows in 1 pages for object 'sysarticles'. [SQLSTATE 01000]
DBCC results for 'sysschemaarticles'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'sysschemaarticles'. [SQLSTATE 01000]
DBCC results for 'syspublications'. [SQLSTATE 01000]
There are 1 rows in 1 pages for object 'syspublications'. [SQLSTATE 01000]
DBCC results for 'CommissionGoalsRange'. [SQLSTATE 01000]
There are 12 rows in 1 pages for object 'CommissionGoalsRange'. [SQLSTATE 01000]
DBCC results for 'LOSGoals'. [SQLSTATE 01000]
There are 107 rows in 1 pages for object 'LOSGoals'. [SQLSTATE 01000]
DBCC results for 'OrderInstallInfo'. [SQLSTATE 01000]
There are 318699 rows in 1241 pages for object 'OrderInstallInfo'. [SQLSTATE 01000]
DBCC results for 'syssubscriptions'. [SQLSTATE 01000]
There are 4 rows in 1 pages for object 'syssubscriptions'. [SQLSTATE 01000]
DBCC results for 'sysarticleupdates'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'sysarticleupdates'. [SQLSTATE 01000]
DBCC results for 'MSpub_identity_range'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'MSpub_identity_range'. [SQLSTATE 01000]
DBCC results for 'systranschemas'. [SQLSTATE 01000]
Msg 2576, Sev 16: IAM page (1:1170538) is pointed to by the previous pointer of IAM page (1:1170540) object ID 1583344705 index ID 0 but was not detected in the scan. [SQLSTATE 42000]
Msg 8947, Sev 16: Table error: Multiple IAM pages for object ID 1583344705, index ID 0 contain allocations for the same interval. IAM pages (1:1170540) and (1:2502333). [SQLSTATE 42000]
Msg 2576, Sev 16: IAM page (1:2502332) is pointed to by the previous pointer of IAM page (1:2502333) object ID 1583344705 index ID 0 but was not detected in the scan. [SQLSTATE 42000]
Msg 2593, Sev 16: There are 0 rows in 0 pages for object 'systranschemas'. [SQLSTATE 01000]
Msg 8990, Sev 16: CHECKDB found 3 allocation errors and 0 consistency errors in table '(Object ID 1583344705)' (object ID 1583344705). [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'DummyTrans'. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 0 rows in 0 pages for object 'DummyTrans'. [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'InvoiceDownloadCheck'. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 9 rows in 1 pages for object 'InvoiceDownloadCheck'. [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'ORDER_HIST_MUNICH'. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 0 rows in 0 pages for object 'ORDER_HIST_MUNICH'. [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'ACTIONS'. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 3864063 rows in 43417 pages for object 'ACTIONS'. [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'CALLVOLUME_REQ'. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 24 rows in 1 pages for object 'CALLVOLUME_REQ'. [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'COMMISH_GOALS'. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 273 rows in 2 pages for object 'COMMISH_GOALS'. [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'CM210X'. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 1826290 rows in 97778 pages for object 'CM210X'. [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'CM30'. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 96 rows in 1 pages for object 'CM30'. [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'CM31'. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 32 rows in 1 pages for object 'CM31'. [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'COMMISSION_ADJ_INDEX'. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 1 rows in 1 pages for object 'COMMISSION_ADJ_INDEX'. [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'COMMISSION_DAILY'. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 1659173 rows in 17841 pages for object 'COMMISSION_DAILY'. [SQLSTATE 01000]
DBCC results for 'COMMISSION_EMP'. [SQLSTATE 01000]
There are 12080 rows in 58 pages for object 'COMMISSION_EMP'. [SQLSTATE 01000]
DBCC results for 'CUST_INVO_SUMMARY'. [SQLSTATE 01000]
There are 9512732 rows in 65156 pages for object 'CUST_INVO_SUMMARY'. [SQLSTATE 01000]
DBCC results for 'DAILY_PHONE'. [SQLSTATE 01000]
There are 1918105 rows in 20566 pages for object 'DAILY_PHONE'. [SQLSTATE 01000]
DBCC results for 'Dates2Run'. [SQLSTATE 01000]
There are 31 rows in 1 pages for object 'Dates2Run'. [SQLSTATE 01000]
DBCC results for 'DAILY_PHONE_ERRORS'. [SQLSTATE 01000]
There are 1701 rows in 18 pages for object 'DAILY_PHONE_ERRORS'. [SQLSTATE 01000]
CHECKDB found 9 allocation errors and 0 consistency errors in database 'SalesHistoryDB'. [SQLSTATE 01000]
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (SalesHistoryDB ). [SQLSTATE 01000]
DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000]

View 6 Replies View Related

DBCC Consistency Errors

Dec 12, 2005

Lou writes "Msg 2576, Sev 16: IAM page (0:0) is pointed to by the previous pointer of IAM page (1:958608) object ID 16 index ID 0 but was not detected in the scan. [SQLSTATE 42000]
Msg 2576, Sev 16: IAM page (0:0) is pointed to by the previous pointer of IAM page (1:985853) object ID 16 index ID 2 but was not detected in the scan. [SQLSTATE 42000]
Msg 2576, Sev 16: IAM page (0:0) is pointed to by the previous pointer of IAM page (1:958600) object ID 16 index ID 255 but was not detected in the scan. [SQLSTATE 42000]
Msg 2576, Sev 16: IAM page (0:0) is pointed to by the previous pointer of IAM page (1:1067763) object ID 17 index ID 0 but was not detected in the scan. [SQLSTATE 42000]
Msg 2576, Sev 16: IAM page (0:0) is pointed to by the previous pointer of IAM page (1:1120026) object ID 17 index ID 2 but was not detected in the scan. [SQLSTATE 42000]
Msg 2576, Sev 16: IAM page (0:0) is pointed to by the previous pointer of IAM page (1:1154482) object ID 17 index ID 3 but was not detected in the scan. [SQLSTATE 42000]
Msg 2536, Sev 16: DBCC results for 'SalesHistoryDB'. [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'sysobjects'. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 289 rows in 7 pages for object 'sysobjects'. [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'sysindexes'. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 277 rows in 19 pages for object 'sysindexes'. [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'syscolumns'. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 1809 rows in 43 pages for object 'syscolumns'. [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'systypes'. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 28 rows in 1 pages for object 'systypes'. [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'syscomments'. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 301 rows in 101 pages for object 'syscomments'. [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'sysfiles1'. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 2 rows in 1 pages for object 'sysfiles1'. [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'syspermissions'. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 311 rows in 3 pages for object 'syspermissions'. [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'sysusers'. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 28 rows in 1 pages for object 'sysusers'. [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'sysproperties'. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 199 rows in 6 pages for object 'sysproperties'. [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'sysdepends'. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 1768 rows in 11 pages for object 'sysdepends'. [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'sysreferences'. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 0 rows in 1 pages for object 'sysreferences'. [SQLSTATE 01000]
Msg 8990, Sev 16: CHECKDB found 3 allocation errors and 0 consistency errors in table '(Object ID 16)' (object ID 16). [SQLSTATE 01000]
Msg 8990, Sev 16: CHECKDB found 3 allocation errors and 0 consistency errors in table '(Object ID 17)' (object ID 17). [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'sysfulltextcatalogs'. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 0 rows in 1 pages for object 'sysfulltextcatalogs'. [SQLSTATE 01000]
DBCC results for 'sysfulltextnotify'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'sysfulltextnotify'. [SQLSTATE 01000]
DBCC results for 'sysfilegroups'. [SQLSTATE 01000]
There are 1 rows in 1 pages for object 'sysfilegroups'. [SQLSTATE 01000]
DBCC results for 'IgnoreSalesRep'. [SQLSTATE 01000]
There are 406 rows in 2 pages for object 'IgnoreSalesRep'. [SQLSTATE 01000]
DBCC results for 'invnsrc'. [SQLSTATE 01000]
There are 6101966 rows in 15067 pages for object 'invnsrc'. [SQLSTATE 01000]
DBCC results for 'INVO_ERRS'. [SQLSTATE 01000]
There are 333 rows in 12 pages for object 'INVO

View 4 Replies View Related

DBCC Consistency Errors

Jan 11, 2008

Hello!

I am running SQL Server 2005 (SP2). Recently, DBCC CHECK TABLE reported an error on one of the tables:

...
Table error: Object ID 69575286, index ID 1, partition ID 72057594191216640, alloc unit ID 72057594202161152 (type In-row data). Keys out of order on page (1:261791), slots 8 and 9.
Msg 8986, Level 16, State 1, Line 1
Too many errors found (201) for object ID 69575286. To see all error messages rerun the statement using "WITH ALL_ERRORMSGS".
There are 142506 rows in 6583 pages for object "AllLinks".
CHECKTABLE found 0 allocation errors and 1141 consistency errors in table 'AllLinks' (object ID 69575286).
repair_rebuild is the minimum repair level for the errors found by DBCC CHECKTABLE (STS_Content_TFS.dbo.AllLinks).
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

The interesting thing is that I can query entire table without problems. I managed to pull all data into new table and recreate all indexes. My undertanding is that Index ID 1 is a clustered index. It looks to me this error is not very critical although repair_rebuild is advised.

Any thoughts on this matter is greately appreciated.

Igor

View 2 Replies View Related

DBCC CheckDB

Jan 27, 2000

I have a few extremely large databases in SQL Server 6.5 sp3
(soon to be 5a - but we won't talk about that!!) NT 4.0 sp4
(about 10 GIG each). I don't have a big window of down-time
in order to do any maintenance. Does anyone know of a way to
be able to run dbcc checkdb or other dbcc's that I can run to
verify the database yet complete within a reasonable amount
of time? The last time dbcc checkdb was run, it was started
Friday night and still not complete Sunday night.
Over a weekend, I may have up to a 24 hour maintenance window.

Any suggestions would be appreciated.
Thanks!
Toni

View 1 Replies View Related

DBCC CHECKDB

Nov 9, 1999

Hai ,
When I ran DBCC CHECK DB of userdatabase, its reporting along with usual messages as
Descriptor for system table '8' in database '8' not found in the descriptor hash table.
I could'nt understand being familiar error encounterd .
Any one will appreciate for the help

Thank you

View 1 Replies View Related

DBCC Checkdb

Jan 17, 1999

Hello All,

I recently took over a SQL server with 300 MB of data. I am relatively new to SQL 6.5 and have been reading that DBCC checkdb and checkalloc should be run at least once per week. Apparently the person before me never ran any of those checks. Is not running the database consistency checks for so long going to present a problem? has anyone run into problems when running those checks? Any advise is greatly appreciated.

Pauli

View 4 Replies View Related

Dbcc Checkdb

Aug 28, 2006

I ran "dbcc checkdb(MCMSdb) with no_infomsgs" and I get the following:
Server: Msg 8946, Level 16, State 12, Line 2
Table error: Allocation page (1:274992) has invalid PFS_PAGE page header values. Type is 0. Check type, object ID and page ID on the page.

What cane be done to correct this problem?
Can this error prevent a user from connecting to the database?

View 3 Replies View Related

Dbcc Checkdb

Oct 25, 2006

hi guys

I ran checkdb and found 4 error message on the db.. it seen like same object.. can anyone tell me what it is.. and how can i fix it? thanks !!!!

1.
Server: Msg 8976, Level 16, State 1, Line 35
Table error: Object ID 2094630505, index ID 1. Page (1:809859) was not seen in the scan although its parent (1:77885) and previous (1:809767) refer to it. Check any previous errors.
2.
Server: Msg 8978, Level 16, State 1, Line 35
Table error: Object ID 2094630505, index ID 1. Page (1:809860) is missing a reference from previous page (1:809859). Possible chain linkage problem.
3.
Server: Msg 8976, Level 16, State 1, Line 35
Table error: Object ID 2094630505, index ID 1. Page (1:1453795) was not seen in the scan although its parent (1:1453347) and previous (1:1453796) refer to it. Check any previous errors.
4.
Server: Msg 8978, Level 16, State 1, Line 35
Table error: Object ID 2094630505, index ID 1. Page (1:1453801) is missing a reference from previous page (1:1453795). Possible chain linkage problem.

View 2 Replies View Related

DBCC Checkdb

Dec 8, 2006

Hi All,

Does anybody know if the results of DBCC CHECKDB are stored anywhere? If yes, where?
Also, if you don't select "attempt to repair minor problems" option when you set up the maintenance plan, will SQL Server let you know about any errors Integrity check encounters? If yes, where the erros can be found?

Thanks.

View 10 Replies View Related

DBCC CHECKDB

Jul 12, 2001

Hello all,

in the SQL 6.5 documentation it says when running the DBCC CHECKDB, you should make the database read Only or DBO use only. Do you guys know if SQL 6.5 locks rows while this runs? In SQL 7.0/2000 it only locks the schema.

Thanks,

Lee E. Smith

View 1 Replies View Related

Dbcc Checkdb

Nov 11, 1998

I am using windows nt40 and sql server 6.5 on a DEC ALPHA and accidentlly
started a dbcc checkdb. Is it possible to stop the process with out damaging the database?

View 1 Replies View Related

DBCC CheckDB

Nov 8, 2000

When running dbcc checkdb from my workstation(nt) I recieve some of
the output and then I get "Connection Broken" this is on a 6.5 machine
with the service pack 5, what could be causing my ODBC connection to drop
during the proccess of running checkdb?


Kevin

View 1 Replies View Related

Dbcc Checkdb

Dec 12, 2006

Hi All,

How can I make the dbcc checkdb fail so I can get the errors displayed in the report log? DBCC Checkdb is the step in the integrity job that I run once a month. What I am trying to do is when the dbcc checkdb fails for any reason, I want to get notified so I can correct the problem. I don't want to use repair fast or any other repair parameters that you can select when you run dbcc checkdb function because most of my dbs are 24x7.

Thanks.

View 12 Replies View Related

Dbcc Checkdb

Jul 5, 2007

How often do you run it in your shop?

I'm seeing (from the new SQL Best Practices Analyzer) that MS recommends that it be done once every two weeks on SQL 2005.

I have never been in the habit of running it in production. I have never experienced database corruption in any form.

Just curious.

Regards,

hmscott

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved