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
ADVERTISEMENT
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
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
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
Jan 21, 2008
Hello,
I am facing an issue with a table in my database.
1) When I run a query Select * from MY_Table the query never completes. If I press cancel in Query Analyzer after 1 second or 2 minutes, it always shows the same 174 records. The total table size is 800 KB with 3148 rows .. according to TaskPad
2) No queries, even queries that would return only 1 record complete execution against that table
3) I am unable to rename the table, if I try to rename the table Enterprise Manager becomes unresponsive and has to be closed.
4) If I try to browse the rows through Enterprise manager by scrolling through the records, it allows me to go down through a number of rows and then Enterprise manager gives me a timeout expired error.
5) I ran a DBCC CheckDB command ran for 1 hr and 7 minutes. It says there are 0 allocation errors and 0 consistency errors in the database.
6) The other database tables seem to be OK and the Database is operational except for calls involving the 1 Table
7) I am unable to Drop the Table
8) DBCC CheckAlloc finds 0 allocation errors and 0 consistency errors.
9) DBCC CheckTable on MY_Table returns with: There are 3148 rows in 33 pages for object 'MY_Table' .. no errors are printed.
Can one of the SQL Gurus on this forum please recommend a course of action.
Thanks in advance.
View 1 Replies
View Related
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
View Related
Apr 20, 2006
Starwin writes "when i execute DBCC CHECKDB, DBCC CHECKCATALOG
I reveived the following error.
how to solve it?
Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID -2093955965, index ID 711, page ID (3:2530). The PageId in the page header = (34443:343146507).
. . . .
. . . .
CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID -1635188736)' (object ID -1635188736).
CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID -1600811521)' (object ID -1600811521).
. . . .
. . . .
Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID -8748568, index ID 50307, page ID (3:2497). The PageId in the page header = (26707:762626875).
Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID -7615284, index ID 35836, page ID (3:2534). The PageId in the page heade"
View 1 Replies
View Related
Jun 1, 2001
Hi,
Over the last few weeks we've been having problems with a particular table in our live OLTP database - dbcc checkdb has been reporting consistency errors.
Initially i took the db offline and fixed the errors using checkdb and replacing the deleted records from a backup of the table. After some investigation it appeared that the errors were being caused when the unique clustered index on the table was rebuilt during weekend maintenance. After a lot of testing i was sure this was the case - so i just deleted the index (the table is small and was over-indexed anyway) and the errors stopped occurring. I didn't understand why the errors had occurred in the first place, and i wasn't convinced that the index was the real problem, but the errors had gone - so that was ok for the short term.
A few things still bugged me:
1. For audit purposes we maintain a copy of the table in question (populated via triggers on the live table) and this showed up consistency errors too. This led me to suspect the problem was with the data itself or the structure of the table - unfortunately there's nothing remarkable about this small, rarely updated table at all (apart from the fact that it's vital for our business!).
2. Any database built from backups of the live db consistently report errors now despite the fact that the backups were made after the problem was resolved and when dbcc checkdb reported NO errors (I maintain a number of test and olap databases in this way). What's happening here? (My guess is that the backup and restore process involves rebuilding indexes, rearranging data, etc. and this is resurrecting the problem) I couldn't help feeling that despite having apparently fixed the errors they were still lurking out there somewhere....
3. At no point did the data in the table appear to be corrupt in any way from the user perspective. This provokes two questions - is dbcc checkdb reliable at both reporting and fixing errors, and how serious are consistency errors?
After removing the suspect index everything was fine for a few weeks until this morning - when errors were again reported on the same table. After hours spent testing and playing around with this (dropping indexes, dropping or truncating the table and re-populating from ascii files, etc.) i've now hit a brick wall. I still suspect the problem is related to the data itself or the structure of the table but can't get any further.....so..
Has anyone come up against a similar problem?
Any suggestions for the next course of action?
Can anyone point me to documentation on checkdb or consistency errors (other than what's in BOL or the MS knowledge base)?
thanks,
d.
View 5 Replies
View Related
Aug 1, 2005
Sorry as the last Topic thread was closed...
I just had the same problem. I put the DB in single_user mode then ran a DBCC CheckTable with Repair and then had 80 consis errors. A DBCC CheckTable with Repiar_Rebuild didn't fix it either. A DBCC Reindex of the Table cleared all errors without data loss and another CHeckTable was clean as well. Any ideas?
Below are the results of a DBCC CHeckTable.
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Order_Item_Images' (ID 829962033). Missing or invalid key in index 'IX_Order_Item_Images' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (4:8:2) identified by (RID = (4:8:2) WorkOrder = 5339343 and Instruction = '0053100230106 ' and order_seq = 3 and Node = 1) has index values (WorkOrder = 5339343 and Instruction = '0053100230106 ' and order_seq = 3 and ImageID = '0053100230106' and WorkOrder = 5339343 and Instruction = '0053100230106 ' and order_seq = 3 and Node = 1).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Order_Item_Images' (ID 829962033). Missing or invalid key in index 'IX_Order_Item_Images' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (4:8:3) identified by (RID = (4:8:3) WorkOrder = 5339863 and Instruction = '0053010240041 ' and order_seq = 1 and Node = 1) has index values (WorkOrder = 5339863 and Instruction = '0053010240041 ' and order_seq = 1 and ImageID = '0053010240041' and WorkOrder = 5339863 and Instruction = '0053010240041 ' and order_seq = 1 and Node = 1).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Order_Item_Images' (ID 829962033). Missing or invalid key in index 'IX_Order_Item_Images' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (4:8:4) identified by (RID = (4:8:4) WorkOrder = 5339992 and Instruction = '0053021340004 ' and order_seq = 1 and Node = 1) has index values (WorkOrder = 5339992 and Instruction = '0053021340004 ' and order_seq = 1 and ImageID = '0053021340004' and WorkOrder = 5339992 and Instruction = '0053021340004 ' and order_seq = 1 and Node = 1).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Order_Item_Images' (ID 829962033). Missing or invalid key in index 'IX_Order_Item_Images' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (4:8:5) identified by (RID = (4:8:5) WorkOrder = 5339992 and Instruction = '0053021340005 ' and order_seq = 2 and Node = 1) has index values (WorkOrder = 5339992 and Instruction = '0053021340005 ' and order_seq = 2 and ImageID = '0053021340005' and WorkOrder = 5339992 and Instruction = '0053021340005 ' and order_seq = 2 and Node = 1).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Order_Item_Images' (ID 829962033). Missing or invalid key in index 'IX_Order_Item_Images' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (4:8:6) identified by (RID = (4:8:6) WorkOrder = 5339993 and Instruction = '0053021340011 ' and order_seq = 1 and Node = 1) has index values (WorkOrder = 5339993 and Instruction = '0053021340011 ' and order_seq = 1 and ImageID = '0053021340011' and WorkOrder = 5339993 and Instruction = '0053021340011 ' and order_seq = 1 and Node = 1).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Order_Item_Images' (ID 829962033). Missing or invalid key in index 'IX_Order_Item_Images' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (4:8:7) identified by (RID = (4:8:7) WorkOrder = 5339994 and Instruction = '0053022740041 ' and order_seq = 1 and Node = 1) has index values (WorkOrder = 5339994 and Instruction = '0053022740041 ' and order_seq = 1 and ImageID = '0053022740041' and WorkOrder = 5339994 and Instruction = '0053022740041 ' and order_seq = 1 and Node = 1).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Order_Item_Images' (ID 829962033). Missing or invalid key in index 'IX_Order_Item_Images' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (4:8:8) identified by (RID = (4:8:8) WorkOrder = 5339994 and Instruction = '0053022740052 ' and order_seq = 2 and Node = 1) has index values (WorkOrder = 5339994 and Instruction = '0053022740052 ' and order_seq = 2 and ImageID = '0053022740052' and WorkOrder = 5339994 and Instruction = '0053022740052 ' and order_seq = 2 and Node = 1).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Order_Item_Images' (ID 829962033). Missing or invalid key in index 'IX_Order_Item_Images' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (4:8:9) identified by (RID = (4:8:9) WorkOrder = 5339996 and Instruction = '0053021340034 ' and order_seq = 1 and Node = 1) has index values (WorkOrder = 5339996 and Instruction = '0053021340034 ' and order_seq = 1 and ImageID = '0053021340034' and WorkOrder = 5339996 and Instruction = '0053021340034 ' and order_seq = 1 and Node = 1).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Order_Item_Images' (ID 829962033). Missing or invalid key in index 'IX_Order_Item_Images' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (4:8:10) identified by (RID = (4:8:10) WorkOrder = 5339996 and Instruction = '0053021340034 ' and order_seq = 101 and Node = 1) has index values (WorkOrder = 5339996 and Instruction = '0053021340034 ' and order_seq = 101 and ImageID = '0053021340034' and WorkOrder = 5339996 and Instruction = '0053021340034 ' and order_seq = 101 and Node = 1).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Order_Item_Images' (ID 829962033). Missing or invalid key in index 'IX_Order_Item_Images' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (4:8:11) identified by (RID = (4:8:11) WorkOrder = 5339996 and Instruction = '0053021340044 ' and order_seq = 2 and Node = 1) has index values (WorkOrder = 5339996 and Instruction = '0053021340044 ' and order_seq = 2 and ImageID = '0053021340044' and WorkOrder = 5339996 and Instruction = '0053021340044 ' and order_seq = 2 and Node = 1).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Order_Item_Images' (ID 829962033). Missing or invalid key in index 'IX_Order_Item_Images' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (4:8:12) identified by (RID = (4:8:12) WorkOrder = 5339996 and Instruction = '0053021340044 ' and order_seq = 3 and Node = 1) has index values (WorkOrder = 5339996 and Instruction = '0053021340044 ' and order_seq = 3 and ImageID = '0053021340044' and WorkOrder = 5339996 and Instruction = '0053021340044 ' and order_seq = 3 and Node = 1).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Order_Item_Images' (ID 829962033). Missing or invalid key in index 'IX_Order_Item_Images' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (4:8:13) identified by (RID = (4:8:13) WorkOrder = 5339996 and Instruction = '0053021340044 ' and order_seq = 102 and Node = 1) has index values (WorkOrder = 5339996 and Instruction = '0053021340044 ' and order_seq = 102 and ImageID = '0053021340044' and WorkOrder = 5339996 and Instruction = '0053021340044 ' and order_seq = 102 and Node = 1).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Order_Item_Images' (ID 829962033). Missing or invalid key in index 'IX_Order_Item_Images' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (4:8:14) identified by (RID = (4:8:14) WorkOrder = 5339996 and Instruction = '0053021340044 ' and order_seq = 103 and Node = 1) has index values (WorkOrder = 5339996 and Instruction = '0053021340044 ' and order_seq = 103 and ImageID = '0053021340044' and WorkOrder = 5339996 and Instruction = '0053021340044 ' and order_seq = 103 and Node = 1).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Order_Item_Images' (ID 829962033). Missing or invalid key in index 'IX_Order_Item_Images_1' (ID 3) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (4:8:0) identified by (RID = (4:8:0) WorkOrder = 5339343 and Instruction = '0053100230106 ' and order_seq = 1 and Node = 1) has index values (ImageID = '0053100230106' and WorkOrder = 5339343 and Instruction = '0053100230106 ' and order_seq = 1 and Node = 1).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Order_Item_Images' (ID 829962033). Missing or invalid key in index 'IX_Order_Item_Images_1' (ID 3) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (4:8:1) identified by (RID = (4:8:1) WorkOrder = 5339343 and Instruction = '0053100230106 ' and order_seq = 2 and Node = 1) has index values (ImageID = '0053100230106' and WorkOrder = 5339343 and Instruction = '0053100230106 ' and order_seq = 2 and Node = 1).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Order_Item_Images' (ID 829962033). Missing or invalid key in index 'IX_Order_Item_Images_1' (ID 3) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (4:8:2) identified by (RID = (4:8:2) WorkOrder = 5339343 and Instruction = '0053100230106 ' and order_seq = 3 and Node = 1) has index values (ImageID = '0053100230106' and WorkOrder = 5339343 and Instruction = '0053100230106 ' and order_seq = 3 and Node = 1).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Order_Item_Images' (ID 829962033). Missing or invalid key in index 'IX_Order_Item_Images_1' (ID 3) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (4:8:3) identified by (RID = (4:8:3) WorkOrder = 5339863 and Instruction = '0053010240041 ' and order_seq = 1 and Node = 1) has index values (ImageID = '0053010240041' and WorkOrder = 5339863 and Instruction = '0053010240041 ' and order_seq = 1 and Node = 1).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Order_Item_Images' (ID 829962033). Missing or invalid key in index 'IX_Order_Item_Images_1' (ID 3) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (4:8:4) identified by (RID = (4:8:4) WorkOrder = 5339992 and Instruction = '0053021340004 ' and order_seq = 1 and Node = 1) has index values (ImageID = '0053021340004' and WorkOrder = 5339992 and Instruction = '0053021340004 ' and order_seq = 1 and Node = 1).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Order_Item_Images' (ID 829962033). Missing or invalid key in index 'IX_Order_Item_Images_1' (ID 3) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (4:8:5) identified by (RID = (4:8:5) WorkOrder = 5339992 and Instruction = '0053021340005 ' and order_seq = 2 and Node = 1) has index values (ImageID = '0053021340005' and WorkOrder = 5339992 and Instruction = '0053021340005 ' and order_seq = 2 and Node = 1).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Order_Item_Images' (ID 829962033). Missing or invalid key in index 'IX_Order_Item_Images_1' (ID 3) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (4:8:6) identified by (RID = (4:8:6) WorkOrder = 5339993 and Instruction = '0053021340011 ' and order_seq = 1 and Node = 1) has index values (ImageID = '0053021340011' and WorkOrder = 5339993 and Instruction = '0053021340011 ' and order_seq = 1 and Node = 1).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Order_Item_Images' (ID 829962033). Missing or invalid key in index 'IX_Order_Item_Images_1' (ID 3) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (4:8:7) identified by (RID = (4:8:7) WorkOrder = 5339994 and Instruction = '0053022740041 ' and order_seq = 1 and Node = 1) has index values (ImageID = '0053022740041' and WorkOrder = 5339994 and Instruction = '0053022740041 ' and order_seq = 1 and Node = 1).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Order_Item_Images' (ID 829962033). Missing or invalid key in index 'IX_Order_Item_Images_1' (ID 3) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (4:8:8) identified by (RID = (4:8:8) WorkOrder = 5339994 and Instruction = '0053022740052 ' and order_seq = 2 and Node = 1) has index values (ImageID = '0053022740052' and WorkOrder = 5339994 and Instruction = '0053022740052 ' and order_seq = 2 and Node = 1).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Order_Item_Images' (ID 829962033). Missing or invalid key in index 'IX_Order_Item_Images_1' (ID 3) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (4:8:9) identified by (RID = (4:8:9) WorkOrder = 5339996 and Instruction = '0053021340034 ' and order_seq = 1 and Node = 1) has index values (ImageID = '0053021340034' and WorkOrder = 5339996 and Instruction = '0053021340034 ' and order_seq = 1 and Node = 1).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Order_Item_Images' (ID 829962033). Missing or invalid key in index 'IX_Order_Item_Images_1' (ID 3) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (4:8:10) identified by (RID = (4:8:10) WorkOrder = 5339996 and Instruction = '0053021340034 ' and order_seq = 101 and Node = 1) has index values (ImageID = '0053021340034' and WorkOrder = 5339996 and Instruction = '0053021340034 ' and order_seq = 101 and Node = 1).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Order_Item_Images' (ID 829962033). Missing or invalid key in index 'IX_Order_Item_Images_1' (ID 3) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (4:8:11) identified by (RID = (4:8:11) WorkOrder = 5339996 and Instruction = '0053021340044 ' and order_seq = 2 and Node = 1) has index values (ImageID = '0053021340044' and WorkOrder = 5339996 and Instruction = '0053021340044 ' and order_seq = 2 and Node = 1).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Order_Item_Images' (ID 829962033). Missing or invalid key in index 'IX_Order_Item_Images_1' (ID 3) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (4:8:12) identified by (RID = (4:8:12) WorkOrder = 5339996 and Instruction = '0053021340044 ' and order_seq = 3 and Node = 1) has index values (ImageID = '0053021340044' and WorkOrder = 5339996 and Instruction = '0053021340044 ' and order_seq = 3 and Node = 1).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Order_Item_Images' (ID 829962033). Missing or invalid key in index 'IX_Order_Item_Images_1' (ID 3) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (4:8:13) identified by (RID = (4:8:13) WorkOrder = 5339996 and Instruction = '0053021340044 ' and order_seq = 102 and Node = 1) has index values (ImageID = '0053021340044' and WorkOrder = 5339996 and Instruction = '0053021340044 ' and order_seq = 102 and Node = 1).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Order_Item_Images' (ID 829962033). Missing or invalid key in index 'IX_Order_Item_Images_1' (ID 3) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (4:8:14) identified by (RID = (4:8:14) WorkOrder = 5339996 and Instruction = '0053021340044 ' and order_seq = 103 and Node = 1) has index values (ImageID = '0053021340044' and WorkOrder = 5339996 and Instruction = '0053021340044 ' and order_seq = 103 and Node = 1).
DBCC results for 'Order_Item_Images'.
There are 9816281 rows in 221056 pages for object 'Order_Item_Images'.
CHECKTABLE found 0 allocation errors and 28 consistency errors in table 'Order_Item_Images' (object ID 829962033).
repair_fast is the minimum repair level for the errors found by DBCC CHECKTABLE (PIP.dbo.Order_Item_Images ).
Thanks DeWayne McCallie DBA
Olan Mills, Inc.
Chattanooga TN...
View 8 Replies
View Related
Nov 22, 2005
Hi all, long time reader, first time poster, budding dba passionate about SQL Server.
I received the following Consistency errors:
4] Database IMM481_Nidderdale_Visitor: Check Data and Index Linkage...
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 8970: [Microsoft][ODBC SQL Server Driver][SQL Server]Row error: Object ID 573245097, index ID 0, page ID (1:170), row ID 0. Column 'p_created_date' was created NOT NULL, but is NULL in the row.
[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 573245097. The text, ntext, or image node at page (1:102), slot 1, text ID 1122172928 is not referenced.
[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 573245097. The text, ntext, or image node at page (1:102), slot 2, text ID 1122238464 is not referenced.
[Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation errors and 3 consistency errors in table 'page_data' (object ID 573245097).
[Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation errors and 3 consistency errors in database 'IMM481_Nidderdale_Visitor'.
[Microsoft][ODBC SQL Server Driver][SQL Server]repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (IMM481_Nidderdale_Visitor ).
The following errors were found:
[Microsoft][ODBC SQL Server Driver][SQL Server]Row error: Object ID 573245097, index ID 0, page ID (1:170), row ID 0. Column 'p_created_date' was created NOT NULL, but is NULL in the row.
[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 573245097. The text, ntext, or image node at page (1:102), slot 1, text ID 1122172928 is not referenced.
[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 573245097. The text, ntext, or image node at page (1:102), slot 2, text ID 1122238464 is not referenced.
[Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation errors and 3 consistency errors in table 'page_data' (object ID 573245097).
[Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation errors and 3 consistency errors in database 'IMM481_Nidderdale_Visitor'.
[Microsoft][ODBC SQL Server Driver][SQL Server]repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (IMM481_Nidderdale_Visitor ).
** Execution Time: 0 hrs, 0 mins, 1 secs **
I'm trying to see the extent of the problem by running:
Begin Tran TranStart
DBCC CheckDB ('IMM481_Nidderdale_Visitor', Repair_Allow_Data_Loss)
However, SQL Server is bitching about the db not being in Single User Mode. I've refreshed the process info to only find the sa using the db.
What have I missed?
Many thanks,
Drew
(You will get sick of this name)
View 11 Replies
View Related
Jan 12, 2006
I need some help with some consistency errors.
Today I recieved this alert from the SQL Server:
Error: 823, Severity: 24, State: 2
I/O error (bad page ID) detected during read at offset 0x00002245b90000 in file 'D:MSSQLDataPortal.mdf'.
Running dbcc checkdb with ALL_ERRORMSGS, NO_INFOMSGS yield the following:
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 542624976: Errors found in text ID 35900555264 owned by data record identified by RID = (1:10804409:35) add_user = 'AMiller' and correspond_id = 53750.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 542624976: Errors found in text ID 343740186624 owned by data record identified by RID = (1:10804652:14) add_user = 'AShallah' and correspond_id = 1457578.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 542624976: Errors found in text ID 293307285504 owned by data record identified by RID = (1:10806770:23) add_user = 'CCruzon' and correspond_id = 1341479.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 542624976: Errors found in text ID 335802204160 owned by data record identified by RID = (1:10807332:20) add_user = 'CLopez' and correspond_id = 1439003.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 542624976: Errors found in text ID 335808167936 owned by data record identified by RID = (1:10807332:21) add_user = 'CLopez' and correspond_id = 1439019.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 542624976: Errors found in text ID 249395871744 owned by data record identified by RID = (1:10807530:25) add_user = 'CrJohnson' and correspond_id = 1210177.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 542624976: Errors found in text ID 335808233472 owned by data record identified by RID = (1:10808745:16) add_user = 'DKlett' and correspond_id = 1439020.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 542624976: Errors found in text ID 335810330624 owned by data record identified by RID = (1:10808745:17) add_user = 'DKlett' and correspond_id = 1439026.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 542624976: Errors found in text ID 335810658304 owned by data record identified by RID = (1:10808745:18) add_user = 'DKlett' and correspond_id = 1439028.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 542624976: Errors found in text ID 335812231168 owned by data record identified by RID = (1:10809251:13) add_user = 'DNealy' and correspond_id = 1439030.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 542624976: Errors found in text ID 335816359936 owned by data record identified by RID = (1:10809251:14) add_user = 'DNealy' and correspond_id = 1439041.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 542624976: Errors found in text ID 342354165760 owned by data record identified by RID = (1:10816733:32) add_user = 'Jhawkins' and correspond_id = 1452702.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 542624976: Errors found in text ID 342359015424 owned by data record identified by RID = (1:10818038:3) add_user = 'JTheis' and correspond_id = 1452722.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 542624976: Errors found in text ID 333403914240 owned by data record identified by RID = (1:10818166:12) add_user = 'JThongdy' and correspond_id = 1431000.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 542624976: Errors found in text ID 301036273664 owned by data record identified by RID = (1:10819716:19) add_user = 'KHaines' and correspond_id = 1359551.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 542624976: Errors found in text ID 218653261824 owned by data record identified by RID = (1:10822560:19) add_user = 'MPena' and correspond_id = 1163647.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 542624976: Errors found in text ID 342353838080 owned by data record identified by RID = (1:10822879:0) add_user = 'MWiley' and correspond_id = 1452698.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 542624976: Errors found in text ID 342353969152 owned by data record identified by RID = (1:10822879:1) add_user = 'MWiley' and correspond_id = 1452699.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 542624976: Errors found in text ID 333405749248 owned by data record identified by RID = (1:10832505:23) add_user = 'PGutierrez' and correspond_id = 1431011.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 542624976, index ID 255: Page (1:885006) could not be processed. See other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 542624976, index ID 255, page (1:885006). Test (IS_ON (BUF_IOERR, bp->bstat) &&bp->berrcode) failed. Values are 2057 and -1.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 542624976. The text, ntext, or image node at page (1:885006), slot 0, text ID 35900555264 is referenced by page (1:885004), slot 0, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 542624976. The text, ntext, or image node at page (1:885006), slot 1, text ID 333403914240 is referenced by page (1:10818166), slot 12, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 542624976. The text, ntext, or image node at page (1:885006), slot 2, text ID 333405749248 is referenced by page (1:10832505), slot 23, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 542624976. The text, ntext, or image node at page (1:885006), slot 3, text ID 335802204160 is referenced by page (1:10807332), slot 20, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 542624976. The text, ntext, or image node at page (1:885006), slot 4, text ID 335808167936 is referenced by page (1:10807332), slot 21, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 542624976. The text, ntext, or image node at page (1:885006), slot 5, text ID 335808233472 is referenced by page (1:10808745), slot 16, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 542624976. The text, ntext, or image node at page (1:885006), slot 6, text ID 335810330624 is referenced by page (1:10808745), slot 17, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 542624976. The text, ntext, or image node at page (1:885006), slot 7, text ID 335810658304 is referenced by page (1:10808745), slot 18, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 542624976. The text, ntext, or image node at page (1:885006), slot 8, text ID 335812231168 is referenced by page (1:10809251), slot 13, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 542624976. The text, ntext, or image node at page (1:885006), slot 9, text ID 335816359936 is referenced by page (1:10809251), slot 14, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 542624976. The text, ntext, or image node at page (1:885006), slot 10, text ID 342353838080 is referenced by page (1:17300344), slot 0, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 542624976. The text, ntext, or image node at page (1:885006), slot 11, text ID 342353838080 is referenced by page (1:10822879), slot 0, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 542624976. The text, ntext, or image node at page (1:885006), slot 12, text ID 342353969152 is referenced by page (1:10822879), slot 1, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 542624976. The text, ntext, or image node at page (1:885006), slot 13, text ID 342354165760 is referenced by page (1:10816733), slot 32, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 542624976. The text, ntext, or image node at page (1:885006), slot 14, text ID 342359015424 is referenced by page (1:10818038), slot 3, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 542624976. The text, ntext, or image node at page (1:885006), slot 15, text ID 343740186624 is referenced by page (1:19351761), slot 0, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 542624976. The text, ntext, or image node at page (1:885006), slot 16, text ID 343740186624 is referenced by page (1:10804652), slot 14, but was not seen in the scan.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 542624976, index ID 255: Page (1:8398158) could not be processed. See other errors for details.
Server: Msg 8944, Level 16, State 1, Line 1
Table error: Object ID 542624976, index ID 255, page (1:8398158), row 0. Test (offsetNull >= BASEOFFSET) failed. Values are 0 and 4.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 542624976. The text, ntext, or image node at page (1:8398158), slot 0, text ID 301036273664 is referenced by page (1:8398150), slot 0, but was not seen in the scan.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 542624976, index ID 255: Page (1:9154510) could not be processed. See other errors for details.
Server: Msg 8944, Level 16, State 1, Line 1
Table error: Object ID 542624976, index ID 255, page (1:9154510), row 0. Test (!(hdr->r_tagA & (VERSION_MASK | RECTAG_RESV_A | RECTAG_RESV_B))) failed. Values are 255 and 193.
Server: Msg 8944, Level 16, State 4, Line 1
Table error: Object ID 542624976, index ID 255, page (1:9154510), row 0. Test (GetRecType (pRec) >= 0 && GetRecType (pRec) <= LAST_REC_TYPE) failed. Values are 14 and 12.
Server: Msg 8944, Level 16, State 1, Line 1
Table error: Object ID 542624976, index ID 255, page (1:9154510), row 0. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 65535 and 7838.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 542624976. The text, ntext, or image node at page (1:9154510), slot 0, text ID 218653261824 is referenced by page (1:9154493), slot 0, but was not seen in the scan.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 542624976, index ID 255: Page (1:10444815) could not be processed. See other errors for details.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 542624976. The text, ntext, or image node at page (1:10444815), slot 0, text ID 249395871744 is referenced by page (1:10444775), slot 0, but was not seen in the scan.
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 542624976, index ID 255, page ID (1:15257220). The PageId in the page header = (1:15257228).
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 542624976, index ID 255: Page (1:15257220) could not be processed. See other errors for details.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 542624976. The text, ntext, or image node at page (1:15257220), slot 0, text ID 293307285504 is referenced by page (1:15089406), slot 0, but was not seen in the scan.
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 542624976, index ID 255, page ID (1:15257221). The PageId in the page header = (1:15257229).
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 542624976, index ID 255: Page (1:15257221) could not be processed. See other errors for details.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 542624976. The text, ntext, or image node at page (1:15257221), slot 0, text ID 293307285504 is referenced by page (1:15089406), slot 0, but was not seen in the scan.
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 542624976, index ID 255, page ID (1:15257222). The PageId in the page header = (1:15257230).
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 542624976, index ID 255: Page (1:15257222) could not be processed. See other errors for details.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 542624976. The text, ntext, or image node at page (1:15257222), slot 0, text ID 293307285504 is referenced by page (1:15089406), slot 0, but was not seen in the scan.
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 542624976, index ID 255, page ID (1:15257223). The PageId in the page header = (1:15257231).
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 542624976, index ID 255: Page (1:15257223) could not be processed. See other errors for details.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 542624976. The text, ntext, or image node at page (1:15257223), slot 0, text ID 293307285504 is referenced by page (1:15089406), slot 0, but was not seen in the scan.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 542624976. The text, ntext, or image node at page (1:17030749), slot 0, text ID 335802204160 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 542624976. The text, ntext, or image node at page (1:17030760), slot 0, text ID 335808167936 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 542624976. The text, ntext, or image node at page (1:17053063), slot 0, text ID 335808233472 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 542624976. The text, ntext, or image node at page (1:17053071), slot 0, text ID 335810330624 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 542624976. The text, ntext, or image node at page (1:17053079), slot 0, text ID 335810658304 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 542624976. The text, ntext, or image node at page (1:17064698), slot 0, text ID 335812231168 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 542624976. The text, ntext, or image node at page (1:17064707), slot 0, text ID 335816359936 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 542624976. The text, ntext, or image node at page (1:17294071), slot 0, text ID 342359015424 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 542624976. The text, ntext, or image node at page (1:17295780), slot 0, text ID 342354165760 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 542624976. The text, ntext, or image node at page (1:17300344), slot 0, text ID 342353838080 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 542624976. The text, ntext, or image node at page (1:17300352), slot 0, text ID 342353969152 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 542624976. The text, ntext, or image node at page (1:19351761), slot 0, text ID 343740186624 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 542624976. The text, ntext, or image node at page (1:19675671), slot 0, text ID 333403914240 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 542624976. The text, ntext, or image node at page (1:19676212), slot 0, text ID 333405749248 is not referenced.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 552493147: Errors found in text ID 263269974016 owned by data record identified by RID = (1:9422783:33).
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 552493147: Errors found in text ID 263272202240 owned by data record identified by RID = (1:9422783:34).
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 552493147: Errors found in text ID 263278231552 owned by data record identified by RID = (1:9422783:35).
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 552493147, index ID 255: Page (1:11912175) could not be processed. See other errors for details.
Server: Msg 8941, Level 16, State 1, Line 1
Table error: Object ID 552493147, index ID 255, page (1:11912175). Test (sorted [i].offset <= m_freeData) failed. Slot 1, offset 0xff00 is invalid.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 552493147. The text, ntext, or image node at page (1:11912175), slot 0, text ID 263269974016 is referenced by page (1:11912174), slot 5, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 552493147. The text, ntext, or image node at page (1:11912175), slot 1, text ID 263272202240 is referenced by page (1:11912174), slot 6, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 552493147. The text, ntext, or image node at page (1:11912175), slot 2, text ID 263278231552 is referenced by page (1:11912174), slot 7, but was not seen in the scan.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 942626401, index ID 10: Page (1:21868423) could not be processed. See other errors for details.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 942626401, index ID 10. Page (1:21868423) was not seen in the scan although its parent (1:21864202) and previous (1:21868422) refer to it. Check any previous errors.
Server: Msg 8944, Level 16, State 1, Line 1
Table error: Object ID 942626401, index ID 10, page (1:21868423), row 368. Test (((UNALIGNED DataRecHdr*) m_pRec)->r_tagB == 0) failed. Values are 21 and 0.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 942626401, index ID 10. Page (1:21870760) is missing a reference from previous page (1:21868423). Possible chain linkage problem.
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 1310679767, index ID 0, page ID (1:17968584). The PageId in the page header = (1:17968528).
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1310679767, index ID 0: Page (1:17968584) could not be processed. See other errors for details.
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 1310679767, index ID 0, page ID (1:17968585). The PageId in the page header = (1:17968529).
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1310679767, index ID 0: Page (1:17968585) could not be processed. See other errors for details.
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 1310679767, index ID 0, page ID (1:17968586). The PageId in the page header = (1:17968530).
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1310679767, index ID 0: Page (1:17968586) could not be processed. See other errors for details.
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 1310679767, index ID 0, page ID (1:17968587). The PageId in the page header = (1:17968531).
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1310679767, index ID 0: Page (1:17968587) could not be processed. See other errors for details.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 1310679767, index ID 1. Page (1:17968584) was not seen in the scan although its parent (1:17955256) and previous (1:17967263) refer to it. Check any previous errors.
Server: Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1310679767, index ID 1. Index node page (1:17955256), slot 225 refers to child page (1:17968585) and previous child (1:17968584), but they were not encountered.
Server: Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1310679767, index ID 1. Index node page (1:17955256), slot 226 refers to child page (1:17968586) and previous child (1:17968585), but they were not encountered.
Server: Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1310679767, index ID 1. Index node page (1:17955256), slot 227 refers to child page (1:17968587) and previous child (1:17968586), but they were not encountered.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 1310679767, index ID 1. Page (1:17968588) is missing a reference from previous page (1:17968587). Possible chain linkage problem.
Server: Msg 8944, Level 16, State 1, Line 1
Table error: Object ID 1546018973, index ID 255, page (1:10444815), row 0. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 7709 and 2220.
CHECKDB found 0 allocation errors and 74 consistency errors in table 'correspond' (object ID 542624976).
CHECKDB found 0 allocation errors and 8 consistency errors in table 'raaaeport_run' (object ID 552493147).
CHECKDB found 0 allocation errors and 4 consistency errors in table 'coverage' (object ID 942626401).
CHECKDB found 0 allocation errors and 13 consistency errors in table 'payment_detail' (object ID 1310679767).
CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID 1546018973)' (object ID 1546018973).
CHECKDB found 0 allocation errors and 100 consistency errors in database 'Portal'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (Portal ).
This Portal database is 180GB with 75% of that being blob data.
The only new software change to the SQL server is the addition of Redgate SQL Backup 2 weeks ago. No hardware has been added or modified. However, the server was bounced this past Sunday when it became unresponsive.
When I ran DBCC checkdb a few hours ago, there were only 44 consistency errors. Now that there are 100 is troubling.
Any ideas on how to resolve these consistency errors?
Thanks,
Ray
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
View 3 Replies
View Related
Dec 18, 2006
we were doing migration from sql 2K to sql 2005. we used the backup/restore method. after i restored the sql sk db to 2005, i ran checkdb and there were consistency errors. The error was as follows:
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1241979701,referenced_minor_id=4) of row (class=0,object_id=467024945,column_id=0,referenced_major_id=1241979701,referenced_minor_id=4) in sys.sql_dependencies does not have a matching row (object_id=1241979701,column_id=4) in sys.columns.
Please help. Not sure what the fix is. If i run checkdb on sql 2k, there are no consistency errors. could this be due to hardware issue or is there something that needs to be done before migration?
View 1 Replies
View Related
Nov 13, 2007
over the weekend SQL returned errors on all 3 integrity checks which run each night at 8 pm through the normal maintenance plan. Pretty much the same each night. 2 consistency errors on a particular table. Today I ran a manual DBCC Checkdb on the database and it returned 0 consistency errors.
What should I believe. SQL said 0 were repaired during the maintenance plans, which is normal because it is not set to auto repair.
Thanks for any help,
Jeff
View 3 Replies
View Related
Apr 5, 2008
sql server 2000 .. harddrive problems resolved but now several of my datatbases have consistency errors.. lots of them.
best way to repair????????? need to get this resolved asap
View 3 Replies
View Related
Jul 6, 2005
Vimal Kanth writes "I am using SQL Server 2000 and one of my databases has loads of consistency errors. When i try to query a particular record from a table it displays an error message similar to this
Could not find the index entry for RID '168927001232500300' in index page (1:95510), index ID 0, database 'Tristar'.
Then, i executed the DBCC CHECKDB command after going through some documentation. The results of which were something like this
Table error: Database 'Tristar', index 'DMS_VOUCHER.index_1739153241' (ID 1739153241) (index ID 2). Extra or invalid key for the keys:
Index row (1:11229:144) with values (ROWGUID = 22814645-5B2B-4B4E-A1D8-9B49DF7C8CEF`¢0; and DEALER_ID = 10121 and BRANCH_ID = 1.242260474E-307 and VOUCHER_ID = 9507) points to the data row identified by ().
Then, i executed the DBCC CHECKDB REPAIR_ALLOW_DATA_LOSS command. I lost around 3000 records when i excuted this
I dont want any data loss as this is very critical.Can you please help me overcome this problem? Thanks in advance.
Regards
Vimal Kanth"
View 20 Replies
View Related
Sep 9, 2005
Hello Everyone, have somo consistency errors. Database hosted on a cluster with disk raid 5. SQL Server 2000 SP4.
I run:
dbcc checkdb (laf, NOINDEX) WITH NO_INFOMSGS, ALL_ERRORMSGS
and get this result:
Object ID 2: Errors found in text ID 5748948992 owned by data record identified by RID = (1:66410:1) id = 945438442 and indid = 2.
Server: Msg 8961, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:7658), slot 6, text ID 5748949504 does not match its reference from page (1:66410), slot 1.
Server: Msg 8961, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:21382), slot 0, text ID 5748948992 does not match its reference from page (1:7658), slot 6.
CHECKDB found 0 allocation errors and 3 consistency errors in table 'sysindexes' (object ID 2).
CHECKDB found 0 allocation errors and 3 consistency errors in database 'LAF'.
Then I run:
select object_name('945438442') and get: 'laf_ca_proceso_tm33'
Then I run:
dbcc dbreindex ('laf_ca_proceso_tm33')
and get:
Server: Msg 7105, Level 22, State 6, Line 1
Page (1:7658), slot 6 for text, ntext, or image node does not exist.
Connection Broken
How should I solve the problem?
Thanks a lot.
View 6 Replies
View Related
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
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
Feb 15, 2006
Hi all,
Would appreciate your words of wisdom on the errors below. It's SQL Server 2000 SP3 on Windows 2000. We had hardware problems on one of the disks in the array the data files are on, which precipitated a number of errors in the Application Event log:
Event ID 17052,MSSQLSERVER,Error: 823, Severity: 24, State: 2 I/O error (torn page) detected during read at offset 0x000002ed448000 in file 'E:SQLDATA2XDB_Data.MDF'.
Running DBCC CHECKDB resulted in the following:
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1901458048, index ID 0: Page (1:1534500) could not be processed. See other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 1901458048, index ID 0, page (1:1534500). Test (IS_ON (BUF_IOERR, bp->bstat) &&bp->berrcode) failed. Values are 2057 and -1.
DBCC results for 'XDB'.
DBCC results for 'sysobjects'.
There are 328 rows in 18 pages for object 'sysobjects'.
DBCC results for 'sysindexes'.
There are 843 rows in 56 pages for object 'sysindexes'.
DBCC results for 'syscolumns'.
There are 4018 rows in 98 pages for object 'syscolumns'.
DBCC results for 'systypes'.
There are 26 rows in 1 pages for object 'systypes'.
<snip lots more successful checks>
DBCC results for 'tblXMLListsRecords'.
There are 3302391 rows in 79187 pages for object 'tblXMLListsRecords'.
CHECKDB found 0 allocation errors and 2 consistency errors in table 'tblXMLListsRecords' (object ID 1901458048).
DBCC results for 'tblPhotosFolder'.
There are 6121 rows in 228 pages for object 'tblPhotosFolder'.
DBCC results for 'tblImageUpload'.
There are 5 rows in 1 pages for object 'tblImageUpload'.
DBCC results for 'tblLogs'.
There are 2049298 rows in 50892 pages for object 'tblLogs'.
CHECKDB found 0 allocation errors and 2 consistency errors in database 'XDB'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (XDB ).
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
So the questions are - what does the first error mean (the table error)? And does a report of 2 consistency errors in tblXMLListRecords mean that we will lose two records? We have a backup but it would mean losing today's work if we went back to it - admittedly not much, but I'd like to be able to make an informed choice as to whether repairing the database or restoring it would be favourite. Any thoughts gratefully received!
I've also taken a backup of the corrupted database, restored it to another server and run
DBCC CHECKDB ('XDB',REPAIR_ALLOW_DATA_LOSS) with the following results. So now I'm thinking restoring from backup is probably best after all - correct?
DBCC results for 'XDB'.
DBCC results for 'sysobjects'.
There are 329 rows in 18 pages for object 'sysobjects'.
DBCC results for 'sysindexes'.
There are 843 rows in 56 pages for object 'sysindexes'.
DBCC results for 'syscolumns'.
There are 4018 rows in 95 pages for object 'syscolumns'.
<snip successful checks>
DBCC results for 'tblMenus'.
There are 0 rows in 1 pages for object 'tblMenus'.
DBCC results for 'tblImageProcessingFilenames'.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1901458048, index ID 0: Page (1:1534500) could not be processed. See other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 1901458048, index ID 0, page (1:1534500). Test (IS_ON (BUF_IOERR, bp->bstat) &&bp->berrcode) failed. Values are 2057 and -1.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 1901458048, index ID 1. Page (1:1180423) is missing a reference from previous page (1:1534500). Possible chain linkage problem.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 1901458048, index ID 1. Page (1:1534500) was not seen in the scan although its parent (1:1243134) and previous (1:1232752) refer to it. Check any previous errors.
There are 687 rows in 188 pages for object 'tblImageProcessingFilenames'.
DBCC results for 'tblData15C69B09E60A4DC5B19D8C8BD69E6C15'.
There are 842 rows in 23 pages for object 'tblData15C69B09E60A4DC5B19D8C8BD69E6C15'.
DBCC results for 'tblDataLinksChild15C69B09E60A4DC5B19D8C8BD69E6C15'.
There are 848 rows in 24 pages for object 'tblDataLinksChild15C69B09E60A4DC5B19D8C8BD69E6C15'.
DBCC results for 'tblUpdateFields'.
There are 1 rows in 3 pages for object 'tblUpdateFields'.
DBCC results for 'tblData1FDBC8FBD862435E8AD7C648F37F6D3A'.
There are 5 rows in 1 pages for object 'tblData1FDBC8FBD862435E8AD7C648F37F6D3A'.
DBCC results for 'tblDataLinksChild1FDBC8FBD862435E8AD7C648F37F6D3A'.
There are 5 rows in 1 pages for object 'tblDataLinksChild1FDBC8FBD862435E8AD7C648F37F6D3A'.
DBCC results for 'tblXML031029'.
There are 83683 rows in 3331 pages for object 'tblXML031029'.
DBCC results for 'tblXMLListsRecords'.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
Repair: Page (1:1534500) has been deallocated from object ID 1901458048, index ID 0.
Clustered index successfully restored for object 'dbo.tblXMLListsRecords' in database 'XDB'.
There are 3302279 rows in 79187 pages for object 'tblXMLListsRecords'.
CHECKDB found 0 allocation errors and 4 consistency errors in table 'tblXMLListsRecords' (object ID 1901458048).
CHECKDB fixed 0 allocation errors and 4 consistency errors in table 'tblXMLListsRecords' (object ID 1901458048).
DBCC results for 'tblPhotosFolder'.
There are 6109 rows in 224 pages for object 'tblPhotosFolder'.
DBCC results for 'tblImageUpload'.
There are 5 rows in 1 pages for object 'tblImageUpload'.
DBCC results for 'tblLogs'.
There are 2048554 rows in 50870 pages for object 'tblLogs'.
CHECKDB found 0 allocation errors and 4 consistency errors in database 'XDB'.
CHECKDB fixed 0 allocation errors and 4 consistency errors in database 'XDB'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Please let me know if there is anything else I should post - many thanks in advance.
View 2 Replies
View Related
Apr 27, 2006
Can anyone please tell me why I recieved these errors when running dbcc check db. Thank god it was a user created "test" table in a production database and I was able to just drop the table and rerun dbcc with no errors, but this is the second time this has happened in the last month(I just started this job the week of the first error)- and we ended up having to restore to the last good backup.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1543676547. The text, ntext, or image node at page (1:652192), slot 3, text ID 225434796032 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1543676547. The text, ntext, or image node at page (1:652192), slot 4, text ID 225434861568 is not referenced.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1543676547, index ID 255: Page (1:652193) could not be processed. See other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 1543676547, index ID 255, page (1:652193). Test (IS_ON (BUF_IOERR, bp->bstat) &&bp->berrcode) failed. Values are 2057 and -1.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1543676547. The text, ntext, or image node at page (1:652194), slot 0, text ID 225434730496 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1543676547. The text, ntext, or image node at page (1:652194), slot 1, text ID 225434927104 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1543676547. The text, ntext, or image node at page (1:652194), slot 2, text ID 225434992640 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1543676547. The text, ntext, or image node at page (1:652194), slot 3, text ID 225435058176 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1543676547. The text, ntext, or image node at page (1:652194), slot 4, text ID 225435123712 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1543676547. The text, ntext, or image node at page (1:652194), slot 5, text ID 225435189248 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1543676547. The text, ntext, or image node at page (1:652194), slot 6, text ID 225435254784 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1543676547. The text, ntext, or image node at page (1:652194), slot 7, text ID 225435320320 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1543676547. The text, ntext, or image node at page (1:652195), slot 0, text ID 225435385856 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1543676547. The text, ntext, or image node at page (1:652195), slot 1, text ID 225435451392 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1543676547. The text, ntext, or image node at page (1:652195), slot 2, text ID 225435516928 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1543676547. The text, ntext, or image node at page (1:652195), slot 3, text ID 225435582464 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1543676547. The text, ntext, or image node at page (1:652195), slot 4, text ID 225435648000 is not referenced.
DBCC results for 'BILL_PRT_DETAIL'.
There are 909154 rows in 101409 pages for object 'BILL_PRT_DETAIL'.
DBCC results for 'BILLG_ERR_MSGS'.
There are 971 rows in 52 pages for object 'BILLG_ERR_MSGS'.
DBCC results for 'WORK_COMPCY_LEVEL'.
There are 0 rows in 0 pages for object 'WORK_COMPCY_LEVEL'.
DBCC results for 'BILL_PRT_HEADER'.
There are 196396 rows in 24550 pages for object 'BILL_PRT_HEADER'.
DBCC results for 'WORK_COMPCY_TYPE'.
There are 0 rows in 0 pages for object 'WORK_COMPCY_TYPE'.
DBCC results for 'BILL_PRT_MSGS'.
There are 0 rows in 0 pages for object 'BILL_PRT_MSGS'.
DBCC results for 'MTR_TMP_DTA_SEL'.
There are 0 rows in 0 pages for object 'MTR_TMP_DTA_SEL'.
DBCC results for 'WORK_IN_PROGRESS'.
There are 1 rows in 1 pages for object 'WORK_IN_PROGRESS'.
DBCC results for 'BILL_PYMT'.
There are 750053 rows in 19951 pages for object 'BILL_PYMT'.
DBCC results for 'NOTES'.
There are 26812 rows in 457 pages for object 'NOTES'.
DBCC results for 'WORK_ORDER_MASTER'.
There are 0 rows in 0 pages for object 'WORK_ORDER_MASTER'.
DBCC results for 'BUD_BILLG_AMT'.
There are 0 rows in 0 pages for object 'BUD_BILLG_AMT'.
DBCC results for 'NOTES_RELSHP'.
There are 22428 rows in 252 pages for object 'NOTES_RELSHP'.
DBCC results for 'WO_ACT_STAT'.
There are 0 rows in 0 pages for object 'WO_ACT_STAT'.
DBCC results for 'BUD_BILLG_CNSM_HST'.
There are 0 rows in 0 pages for object 'BUD_BILLG_CNSM_HST'.
DBCC results for 'NXT_NBR'.
There are 7 rows in 1 pages for object 'NXT_NBR'.
DBCC results for 'WO_ADDTNL_INFO'.
There are 0 rows in 0 pages for object 'WO_ADDTNL_INFO'.
DBCC results for 'BUD_BILLG_HST'.
There are 0 rows in 0 pages for object 'BUD_BILLG_HST'.
DBCC results for 'PARENT_HST'.
There are 0 rows in 0 pages for object 'PARENT_HST'.
DBCC results for 'WO_APPVL_ROUTING'.
There are 0 rows in 0 pages for object 'WO_APPVL_ROUTING'.
DBCC results for 'BUD_BILLG_WTHR_HST'.
There are 0 rows in 0 pages for object 'BUD_BILLG_WTHR_HST'.
DBCC results for 'PHY_ADDR'.
There are 70776 rows in 7905 pages for object 'PHY_ADDR'.
DBCC results for 'WO_BEHAVIOR_RULE'.
There are 0 rows in 0 pages for object 'WO_BEHAVIOR_RULE'.
DBCC results for 'BUD_BILLG_WTHR_SEV'.
There are 0 rows in 0 pages for object 'BUD_BILLG_WTHR_SEV'.
DBCC results for 'POSTAL_TOWN_CD'.
There are 29539 rows in 569 pages for object 'POSTAL_TOWN_CD'.
DBCC results for 'WO_COMPONENTS'.
There are 0 rows in 0 pages for object 'WO_COMPONENTS'.
DBCC results for 'BUS_UNT'.
There are 1310 rows in 25 pages for object 'BUS_UNT'.
DBCC results for 'cash match'.
There are 738871 rows in 6720 pages for object 'cash match'.
DBCC results for 'POSTED_HISTORY'.
There are 1230436 rows in 26768 pages for object 'POSTED_HISTORY'.
DBCC results for 'WO_CONSTANTS'.
There are 0 rows in 0 pages for object 'WO_CONSTANTS'.
DBCC results for 'BUS_UNT_MSTR'.
There are 0 rows in 0 pages for object 'BUS_UNT_MSTR'.
DBCC results for 'Cashmatch7_30'.
There are 727509 rows in 6619 pages for object 'Cashmatch7_30'.
DBCC results for 'PROFILE_CAT'.
There are 0 rows in 0 pages for object 'PROFILE_CAT'.
DBCC results for 'WO_EDIT_RULE'.
There are 0 rows in 0 pages for object 'WO_EDIT_RULE'.
DBCC results for 'CNSMPTN_SVC_CONTN'.
There are 36776 rows in 928 pages for object 'CNSMPTN_SVC_CONTN'.
DBCC results for 'Trace_cash_match'.
There are 815011 rows in 7412 pages for object 'Trace_cash_match'.
DBCC results for 'PROOF_BILL_PRT_DTL'.
There are 0 rows in 0 pages for object 'PROOF_BILL_PRT_DTL'.
DBCC results for 'WO_MASTER_FILE'.
There are 0 rows in 0 pages for object 'WO_MASTER_FILE'.
DBCC results for 'cash match 8-24'.
There are 815011 rows in 7414 pages for object 'cash match 8-24'.
CHECKDB found 0 allocation errors and 17 consistency errors in table 'cash match 8-24' (object ID 1543676547).
DBCC results for 'PROOF_BILL_PRT_HDR'.
There are 0 rows in 0 pages for object 'PROOF_BILL_PRT_HDR'.
DBCC results for 'CNVRGT_BILLG_DTL'.
There are 0 rows in 0 pages for object 'CNVRGT_BILLG_DTL'.
DBCC results for 'WO_RTG_APPVL_MSTR'.
There are 0 rows in 0 pages for object 'WO_RTG_APPVL_MSTR'.
DBCC results for 'PYMT_TERMS'.
There are 2 rows in 1 pages for object 'PYMT_TERMS'.
DBCC results for 'CNVRGT_BILLG_HDR'.
There are 0 rows in 0 pages for object 'CNVRGT_BILLG_HDR'.
DBCC results for 'WO_STAT'.
There are 0 rows in 0 pages for object 'WO_STAT'.
DBCC results for 'Cash Matching Process'.
There are 836838 rows in 7612 pages for object 'Cash Matching Process'.
DBCC results for 'RD_CYCLE'.
There are 55 rows in 1 pages for object 'RD_CYCLE'.
DBCC results for 'WO_STAT_RULES'.
There are 0 rows in 0 pages for object 'WO_STAT_RULES'.
DBCC results for 'REASON_CD'.
There are 0 rows in 0 pages for object 'REASON_CD'.
DBCC results for 'WO_TYP'.
There are 0 rows in 0 pages for object 'WO_TYP'.
DBCC results for 'COLCT_RULES'.
There are 30 rows in 1 pages for object 'COLCT_RULES'.
DBCC results for 'RECEIPTS_BTCH'.
There are 2109 rows in 44 pages for object 'RECEIPTS_BTCH'.
DBCC results for 'nightly107'.
There are 344086 rows in 3225 pages for object 'nightly107'.
DBCC results for 'WO_TYP_ACT_STAT'.
There are 0 rows in 0 pages for object 'WO_TYP_ACT_STAT'.
DBCC results for 'COMPONENT_MASTER'.
There are 0 rows in 0 pages for object 'COMPONENT_MASTER'.
DBCC results for 'RECEIPTS_I_FILE'.
There are 51698 rows in 3244 pages for object 'RECEIPTS_I_FILE'.
DBCC results for 'NightCash10-12'.
There are 64657 rows in 592 pages for object 'NightCash10-12'.
DBCC results for 'WRK_CENTER_WRK_SCH'.
There are 0 rows in 0 pages for object 'WRK_CENTER_WRK_SCH'.
DBCC results for 'CONS_SVC_CONN_CD'.
There are 1524 rows in 20 pages for object 'CONS_SVC_CONN_CD'.
DBCC results for 'RECEIPT_ITM'.
There are 151581 rows in 6334 pages for object 'RECEIPT_ITM'.
DBCC results for 'Utiligy Cash Match Trace'.
There are 321627 rows in 2928 pages for object 'Utiligy Cash Match Trace'.
DBCC results for 'WRTOFF_GL_CLASS_CD'.
There are 0 rows in 0 pages for object 'WRTOFF_GL_CLASS_CD'.
DBCC results for 'CONTACT_INFO'.
There are 1 rows in 1 pages for object 'CONTACT_INFO'.
DBCC results for 'REFUND_HISTORY'.
There are 906 rows in 24 pages for object 'REFUND_HISTORY'.
DBCC results for 'RECEIPTS_I_FILE2'.
There are 48343 rows in 3022 pages for object 'RECEIPTS_I_FILE2'.
DBCC results for 'CUST_ADDR_REL'.
There are 70611 rows in 2258 pages for object 'CUST_ADDR_REL'.
DBCC results for 'REPORT_TYPE'.
There are 42 rows in 1 pages for object 'REPORT_TYPE'.
DBCC results for 'CUST_CNTRCT_RELSHP'.
There are 0 rows in 0 pages for object 'CUST_CNTRCT_RELSHP'.
DBCC results for 'REQ_READ_SCH'.
There are 1 rows in 1 pages for object 'REQ_READ_SCH'.
DBCC results for 'RESOURCE_ASGNDS'.
There are 0 rows in 0 pages for object 'RESOURCE_ASGNDS'.
DBCC results for 'CUST_INFO'.
There are 36779 rows in 2480 pages for object 'CUST_INFO'.
DBCC results for 'RESOURCE_MASTER'.
There are 0 rows in 0 pages for object 'RESOURCE_MASTER'.
DBCC results for 'RESOURCE_WORK_SCH'.
There are 0 rows in 0 pages for object 'RESOURCE_WORK_SCH'.
DBCC results for 'CUST_PYMT_ACCT'.
There are 0 rows in 0 pages for object 'CUST_PYMT_ACCT'.
DBCC results for 'ROUTE'.
There are 95 rows in 2 pages for object 'ROUTE'.
DBCC results for 'ADDR'.
There are 70767 rows in 861 pages for object 'ADDR'.
DBCC results for 'CUST_STMT_HST'.
There are 0 rows in 0 pages for object 'CUST_STMT_HST'.
DBCC results for 'ROUTE_RD_CYCLE'.
There are 0 rows in 0 pages for object 'ROUTE_RD_CYCLE'.
DBCC results for 'AGING_DAYS_TBL'.
There are 5 rows in 1 pages for object 'AGING_DAYS_TBL'.
DBCC results for 'CUST_SVC_RELSHP'.
There are 73551 rows in 1415 pages for object 'CUST_SVC_RELSHP'.
DBCC results for 'RPT_TYPE_CRITERIA'.
There are 116 rows in 2 pages for object 'RPT_TYPE_CRITERIA'.
DBCC results for 'AMX_MSG_LG'.
There are 0 rows in 0 pages for object 'AMX_MSG_LG'.
DBCC results for 'RPT_VERSION'.
There are 32 rows in 1 pages for object 'RPT_VERSION'.
DBCC results for 'DED_MTR_CONSUM'.
There are 0 rows in 0 pages for object 'DED_MTR_CONSUM'.
DBCC results for 'ASGND_BILL_CAT_CD'.
There are 0 rows in 0 pages for object 'ASGND_BILL_CAT_CD'.
DBCC results for 'RPT_VRSN_CRITERIA'.
There are 15 rows in 1 pages for object 'RPT_VRSN_CRITERIA'.
DBCC results for 'DED_MTR_POS'.
There are 0 rows in 0 pages for object 'DED_MTR_POS'.
DBCC results for 'ASGND_CUST_CAT_CD'.
There are 0 rows in 0 pages for object 'ASGND_CUST_CAT_CD'.
DBCC results for 'SCH_POOL'.
There are 0 rows in 0 pages for object 'SCH_POOL'.
DBCC results for 'DED_MTR_RDING_HIST'.
There are 0 rows in 0 pages for object 'DED_MTR_RDING_HIST'.
CHECKDB found 0 allocation errors and 17 consistency errors in database 'UtiligyPD'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (UtiligyPD ).
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Thanks!
Anita
View 5 Replies
View Related
Aug 1, 2007
We've got the following error when we ran the "DBCC CHECKDB WITH ALL_ERRORMSGS" command. Please advise what would be the best method to fix this problem without lossing any data (if possible).
--------------
DBCC results for 'PRODUCTION'.
DBCC results for 'sysobjects'.
There are 314 rows in 7 pages for object 'sysobjects'.
DBCC results for 'sysindexes'.
There are 361 rows in 15 pages for object 'sysindexes'.
DBCC results for 'syscolumns'.
There are 1009 rows in 15 pages for object 'syscolumns'.
DBCC results for 'systypes'.
There are 26 rows in 1 pages for object 'systypes'.
DBCC results for 'syscomments'.
There are 153 rows in 19 pages for object 'syscomments'.
DBCC results for 'sysfiles1'.
There are 2 rows in 1 pages for object 'sysfiles1'.
DBCC results for 'syspermissions'.
There are 153 rows in 1 pages for object 'syspermissions'.
DBCC results for 'sysusers'.
There are 14 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 353 rows in 2 pages for object 'sysdepends'.
DBCC results for 'sysreferences'.
There are 62 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 'MHGROUP.CUSTOM1'.
There are 17010 rows in 107 pages for object 'MHGROUP.CUSTOM1'.
DBCC results for 'MHGROUP.FORMS'.
There are 12 rows in 1 pages for object 'MHGROUP.FORMS'.
DBCC results for 'MHGROUP.CUSTOM2'.
There are 161612 rows in 1495 pages for object 'MHGROUP.CUSTOM2'.
DBCC results for 'MHGROUP.DOCCACHE'.
There are 0 rows in 0 pages for object 'MHGROUP.DOCCACHE'.
DBCC results for 'MHGROUP.FORM_CONTROLS'.
There are 579 rows in 7 pages for object 'MHGROUP.FORM_CONTROLS'.
DBCC results for 'MHGROUP.CUSTOM3'.
There are 0 rows in 0 pages for object 'MHGROUP.CUSTOM3'.
DBCC results for 'MHGROUP.QUICK_RETRIEVE'.
There are 15656 rows in 131 pages for object 'MHGROUP.QUICK_RETRIEVE'.
DBCC results for 'MHGROUP.CUSTOM4'.
There are 0 rows in 0 pages for object 'MHGROUP.CUSTOM4'.
DBCC results for 'MHGROUP.ROLES'.
There are 5 rows in 1 pages for object 'MHGROUP.ROLES'.
DBCC results for 'MHGROUP.CUSTOM5'.
There are 0 rows in 0 pages for object 'MHGROUP.CUSTOM5'.
DBCC results for 'MHGROUP.USERROLES'.
There are 4 rows in 1 pages for object 'MHGROUP.USERROLES'.
DBCC results for 'MHGROUP.CUSTOM6'.
There are 0 rows in 0 pages for object 'MHGROUP.CUSTOM6'.
DBCC results for 'MHGROUP.KEYWORDS'.
There are 0 rows in 0 pages for object 'MHGROUP.KEYWORDS'.
DBCC results for 'MHGROUP.CUSTOM7'.
There are 0 rows in 0 pages for object 'MHGROUP.CUSTOM7'.
DBCC results for 'MHGROUP.DOC_KEYWORDS'.
There are 0 rows in 0 pages for object 'MHGROUP.DOC_KEYWORDS'.
DBCC results for 'MHGROUP.ROLE_PROFILES'.
There are 182 rows in 2 pages for object 'MHGROUP.ROLE_PROFILES'.
DBCC results for 'MHGROUP.CUSTOM8'.
There are 0 rows in 0 pages for object 'MHGROUP.CUSTOM8'.
DBCC results for 'MHGROUP.SECURITY_TEMPLATE'.
There are 1 rows in 1 pages for object 'MHGROUP.SECURITY_TEMPLATE'.
DBCC results for 'MHGROUP.CUSTOM9'.
There are 0 rows in 0 pages for object 'MHGROUP.CUSTOM9'.
DBCC results for 'MHGROUP.SYSTEM_PREFERENCES'.
There are 7 rows in 1 pages for object 'MHGROUP.SYSTEM_PREFERENCES'.
DBCC results for 'MHGROUP.CUSTOM10'.
There are 0 rows in 0 pages for object 'MHGROUP.CUSTOM10'.
DBCC results for 'MHGROUP.USER_PREFERENCES'.
There are 0 rows in 0 pages for object 'MHGROUP.USER_PREFERENCES'.
DBCC results for 'MHGROUP.USR_SCTY_ACC_TEMP'.
There are 1 rows in 1 pages for object 'MHGROUP.USR_SCTY_ACC_TEMP'.
DBCC results for 'MHGROUP.CUSTOM11'.
There are 0 rows in 0 pages for object 'MHGROUP.CUSTOM11'.
DBCC results for 'MHGROUP.CUSTOM12'.
There are 0 rows in 0 pages for object 'MHGROUP.CUSTOM12'.
DBCC results for 'MHGROUP.GRP_SCTY_ACC_TEMP'.
There are 1 rows in 1 pages for object 'MHGROUP.GRP_SCTY_ACC_TEMP'.
DBCC results for 'MHGROUP.CUSTOM29'.
There are 14 rows in 1 pages for object 'MHGROUP.CUSTOM29'.
DBCC results for 'MHGROUP.CUSTOM30'.
There are 131 rows in 3 pages for object 'MHGROUP.CUSTOM30'.
DBCC results for 'MHGROUP.USR_SCTY_TEMP_ASSC'.
There are 1 rows in 1 pages for object 'MHGROUP.USR_SCTY_TEMP_ASSC'.
DBCC results for 'MHGROUP.CUSTOM31'.
There are 0 rows in 0 pages for object 'MHGROUP.CUSTOM31'.
DBCC results for 'MHGROUP.USERACTIONS'.
There are 4 rows in 1 pages for object 'MHGROUP.USERACTIONS'.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 190233706496 owned by data record identified by RID = (1:70653:1) EDITWHEN = May 3 2007 12:42AM and DOCNUM = 438753 and VERSION = 2.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 249893486592 owned by data record identified by RID = (1:78576:3) EDITWHEN = May 3 2007 4:04AM and DOCNUM = 547171 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 226056470528 owned by data record identified by RID = (1:79561:4) EDITWHEN = May 3 2007 4:34AM and DOCNUM = 506724 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 250617135104 owned by data record identified by RID = (1:93581:0) EDITWHEN = May 7 2007 8:56AM and DOCNUM = 300158 and VERSION = 41.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 148611661824 owned by data record identified by RID = (1:97144:1) EDITWHEN = May 8 2007 8:48AM and DOCNUM = 371047 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 247374348288 owned by data record identified by RID = (1:101411:1) EDITWHEN = May 9 2007 8:53AM and DOCNUM = 542832 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 251084603392 owned by data record identified by RID = (1:103097:4) EDITWHEN = May 10 2007 3:39AM and DOCNUM = 549268 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 183028940800 owned by data record identified by RID = (1:104120:0) EDITWHEN = May 10 2007 9:04AM and DOCNUM = 429670 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 10331947008 owned by data record identified by RID = (1:105331:1) EDITWHEN = May 11 2007 3:41AM and DOCNUM = 84626 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 251640938496 owned by data record identified by RID = (1:108119:7) EDITWHEN = May 14 2007 4:34AM and DOCNUM = 550202 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 252161425408 owned by data record identified by RID = (1:116159:0) EDITWHEN = May 16 2007 8:09AM and DOCNUM = 551368 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 252471803904 owned by data record identified by RID = (1:120284:4) EDITWHEN = May 18 2007 2:02AM and DOCNUM = 551970 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 250536984576 owned by data record identified by RID = (1:122958:2) EDITWHEN = May 18 2007 8:20AM and DOCNUM = 548281 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 206225408000 owned by data record identified by RID = (1:123289:0) EDITWHEN = May 18 2007 10:14AM and DOCNUM = 449652 and VERSION = 8.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 252530786304 owned by data record identified by RID = (1:123815:1) EDITWHEN = May 21 2007 2:29AM and DOCNUM = 552102 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 58982203392 owned by data record identified by RID = (1:125063:1) EDITWHEN = May 21 2007 6:42AM and DOCNUM = 197503 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 250440187904 owned by data record identified by RID = (1:125578:10) EDITWHEN = May 21 2007 9:52AM and DOCNUM = 548097 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 252884549632 owned by data record identified by RID = (1:126217:3) EDITWHEN = May 21 2007 10:37AM and DOCNUM = 552814 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 252885336064 owned by data record identified by RID = (1:126217:4) EDITWHEN = May 21 2007 10:37AM and DOCNUM = 552823 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 252898705408 owned by data record identified by RID = (1:126371:0) EDITWHEN = May 21 2007 1:49PM and DOCNUM = 552720 and VERSION = 2.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 252899229696 owned by data record identified by RID = (1:126371:2) EDITWHEN = May 21 2007 1:52PM and DOCNUM = 552738 and VERSION = 2.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 252677914624 owned by data record identified by RID = (1:126371:4) EDITWHEN = May 21 2007 2:06PM and DOCNUM = 552331 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 252900016128 owned by data record identified by RID = (1:126371:6) EDITWHEN = May 21 2007 2:36PM and DOCNUM = 552842 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 246325903360 owned by data record identified by RID = (1:126371:7) EDITWHEN = May 21 2007 2:40PM and DOCNUM = 541091 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 251883880448 owned by data record identified by RID = (1:126371:8) EDITWHEN = May 21 2007 2:49PM and DOCNUM = 522753 and VERSION = 5.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 117782872064 owned by data record identified by RID = (1:126447:2) EDITWHEN = May 22 2007 1:22AM and DOCNUM = 316151 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 164379951104 owned by data record identified by RID = (1:126447:3) EDITWHEN = May 22 2007 1:22AM and DOCNUM = 397610 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 183754752000 owned by data record identified by RID = (1:127392:0) EDITWHEN = May 22 2007 1:28AM and DOCNUM = 430878 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 166120128512 owned by data record identified by RID = (1:127392:1) EDITWHEN = May 22 2007 1:29AM and DOCNUM = 400652 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 252898705408 owned by data record identified by RID = (1:127392:3) EDITWHEN = May 22 2007 1:30AM and DOCNUM = 552720 and VERSION = 2.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 229398937600 owned by data record identified by RID = (1:127393:0) EDITWHEN = May 22 2007 1:31AM and DOCNUM = 511737 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 252900016128 owned by data record identified by RID = (1:127393:1) EDITWHEN = May 22 2007 1:31AM and DOCNUM = 552842 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 251084603392 owned by data record identified by RID = (1:127395:2) EDITWHEN = May 22 2007 1:40AM and DOCNUM = 549268 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 204838666240 owned by data record identified by RID = (1:127398:0) EDITWHEN = May 22 2007 1:55AM and DOCNUM = 469609 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 148611661824 owned by data record identified by RID = (1:127824:1) EDITWHEN = May 22 2007 2:00AM and DOCNUM = 371047 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 58982203392 owned by data record identified by RID = (1:127825:2) EDITWHEN = May 22 2007 2:06AM and DOCNUM = 197503 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 195948838912 owned by data record identified by RID = (1:127826:1) EDITWHEN = May 22 2007 2:14AM and DOCNUM = 453377 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 2315714560 owned by data record identified by RID = (1:127830:4) EDITWHEN = May 22 2007 2:42AM and DOCNUM = 49333 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 219683880960 owned by data record identified by RID = (1:127831:2) EDITWHEN = May 22 2007 2:44AM and DOCNUM = 446037 and VERSION = 7.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 136499429376 owned by data record identified by RID = (1:127831:4) EDITWHEN = May 22 2007 2:45AM and DOCNUM = 351353 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 97868775424 owned by data record identified by RID = (1:127992:4) EDITWHEN = May 22 2007 2:47AM and DOCNUM = 277606 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 108305776640 owned by data record identified by RID = (1:127996:1) EDITWHEN = May 22 2007 2:57AM and DOCNUM = 297781 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 246325903360 owned by data record identified by RID = (1:127996:2) EDITWHEN = May 22 2007 2:58AM and DOCNUM = 541091 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 208979886080 owned by data record identified by RID = (1:127996:3) EDITWHEN = May 22 2007 3:02AM and DOCNUM = 477254 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 211872514048 owned by data record identified by RID = (1:127996:5) EDITWHEN = May 22 2007 3:02AM and DOCNUM = 479398 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 73371942912 owned by data record identified by RID = (1:127998:0) EDITWHEN = May 22 2007 3:07AM and DOCNUM = 228381 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 226056470528 owned by data record identified by RID = (1:127999:1) EDITWHEN = May 22 2007 3:17AM and DOCNUM = 506724 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 180270596096 owned by data record identified by RID = (1:128064:3) EDITWHEN = May 22 2007 3:18AM and DOCNUM = 424808 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 153409421312 owned by data record identified by RID = (1:128065:1) EDITWHEN = May 22 2007 3:19AM and DOCNUM = 378903 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 176867508224 owned by data record identified by RID = (1:128068:0) EDITWHEN = May 22 2007 3:33AM and DOCNUM = 418823 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 127582076928 owned by data record identified by RID = (1:128068:1) EDITWHEN = May 22 2007 3:33AM and DOCNUM = 335751 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 41496477696 owned by data record identified by RID = (1:128070:1) EDITWHEN = May 22 2007 3:44AM and DOCNUM = 160458 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 252530786304 owned by data record identified by RID = (1:128070:4) EDITWHEN = May 22 2007 3:45AM and DOCNUM = 552102 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 250617135104 owned by data record identified by RID = (1:128070:6) EDITWHEN = May 22 2007 3:49AM and DOCNUM = 300158 and VERSION = 41.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 213345239040 owned by data record identified by RID = (1:128071:2) EDITWHEN = May 22 2007 3:50AM and DOCNUM = 484473 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 211040141312 owned by data record identified by RID = (1:128240:2) EDITWHEN = May 22 2007 3:54AM and DOCNUM = 480799 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 215276191744 owned by data record identified by RID = (1:128241:2) EDITWHEN = May 22 2007 3:58AM and DOCNUM = 484020 and VERSION = 2.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 227707453440 owned by data record identified by RID = (1:128245:3) EDITWHEN = May 22 2007 4:08AM and DOCNUM = 509645 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 17572626432 owned by data record identified by RID = (1:128245:5) EDITWHEN = May 22 2007 4:09AM and DOCNUM = 104597 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 190558240768 owned by data record identified by RID = (1:128247:3) EDITWHEN = May 22 2007 4:15AM and DOCNUM = 443514 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 233244852224 owned by data record identified by RID = (1:128392:5) EDITWHEN = May 22 2007 4:18AM and DOCNUM = 518211 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 236761710592 owned by data record identified by RID = (1:128395:0) EDITWHEN = May 22 2007 4:27AM and DOCNUM = 135768 and VERSION = 3.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 4776329216 owned by data record identified by RID = (1:128396:0) EDITWHEN = May 22 2007 4:31AM and DOCNUM = 67067 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 4781637632 owned by data record identified by RID = (1:128396:1) EDITWHEN = May 22 2007 4:31AM and DOCNUM = 67147 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 57178390528 owned by data record identified by RID = (1:128396:2) EDITWHEN = May 22 2007 4:31AM and DOCNUM = 193517 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 132154130432 owned by data record identified by RID = (1:128397:1) EDITWHEN = May 22 2007 4:36AM and DOCNUM = 343930 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 181863710720 owned by data record identified by RID = (1:128399:3) EDITWHEN = May 22 2007 4:43AM and DOCNUM = 427662 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 157604446208 owned by data record identified by RID = (1:128399:4) EDITWHEN = May 22 2007 4:44AM and DOCNUM = 385594 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 53393555456 owned by data record identified by RID = (1:128512:0) EDITWHEN = May 22 2007 4:47AM and DOCNUM = 185489 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 249893486592 owned by data record identified by RID = (1:128544:2) EDITWHEN = May 22 2007 6:01AM and DOCNUM = 547171 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 252885336064 owned by data record identified by RID = (1:131422:1) EDITWHEN = May 23 2007 4:54AM and DOCNUM = 552823 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 4781637632 owned by data record identified by RID = (1:217589:1) EDITWHEN = Jan 30 2002 2:45PM and DOCNUM = 67147 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 2315714560 owned by data record identified by RID = (1:217981:11) EDITWHEN = Apr 19 2002 5:22AM and DOCNUM = 49333 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 190233706496 owned by data record identified by RID = (1:226945:0) EDITWHEN = May 26 2007 2:04AM and DOCNUM = 438753 and VERSION = 2.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 97868775424 owned by data record identified by RID = (1:231817:5) EDITWHEN = Oct 11 2004 5:51PM and DOCNUM = 277606 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 17055547392 owned by data record identified by RID = (1:232186:10) EDITWHEN = Oct 26 2004 3:22PM and DOCNUM = 103068 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 247127146496 owned by data record identified by RID = (1:234352:0) EDITWHEN = May 28 2007 8:01AM and DOCNUM = 542357 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 117782872064 owned by data record identified by RID = (1:235268:9) EDITWHEN = Mar 4 2005 3:41PM and DOCNUM = 316151 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 17572626432 owned by data record identified by RID = (1:237531:0) EDITWHEN = Jun 9 2005 11:48AM and DOCNUM = 104597 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 108305776640 owned by data record identified by RID = (1:237547:6) EDITWHEN = Jun 9 2005 6:03PM and DOCNUM = 297781 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 132154130432 owned by data record identified by RID = (1:239829:14) EDITWHEN = Sep 17 2005 12:07PM and DOCNUM = 343930 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 153409421312 owned by data record identified by RID = (1:240034:13) EDITWHEN = Sep 26 2005 7:07AM and DOCNUM = 378903 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 250536984576 owned by data record identified by RID = (1:241157:1) EDITWHEN = May 29 2007 8:07AM and DOCNUM = 548281 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 53393555456 owned by data record identified by RID = (1:241754:16) EDITWHEN = Oct 26 2005 8:13AM and DOCNUM = 185489 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 252471803904 owned by data record identified by RID = (1:243337:1) EDITWHEN = May 31 2007 7:23AM and DOCNUM = 551970 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 164379951104 owned by data record identified by RID = (1:245986:11) EDITWHEN = Dec 8 2005 8:10AM and DOCNUM = 397610 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 166120128512 owned by data record identified by RID = (1:246003:5) EDITWHEN = Dec 9 2005 3:55AM and DOCNUM = 400652 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 183028940800 owned by data record identified by RID = (1:246096:0) EDITWHEN = Jun 5 2007 3:19AM and DOCNUM = 429670 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 251883880448 owned by data record identified by RID = (1:247655:2) EDITWHEN = Jun 6 2007 10:08AM and DOCNUM = 522753 and VERSION = 5.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 252884549632 owned by data record identified by RID = (1:248826:4) EDITWHEN = Jun 7 2007 11:59AM and DOCNUM = 552814 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 136499429376 owned by data record identified by RID = (1:251952:13) EDITWHEN = Feb 17 2006 10:57AM and DOCNUM = 351353 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 251640938496 owned by data record identified by RID = (1:252074:1) EDITWHEN = Jun 13 2007 12:54AM and DOCNUM = 550202 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 178253660160 owned by data record identified by RID = (1:252644:5) EDITWHEN = Jun 13 2007 10:49AM and DOCNUM = 421231 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 157604446208 owned by data record identified by RID = (1:253275:6) EDITWHEN = Feb 24 2006 11:58AM and DOCNUM = 385594 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 178253660160 owned by data record identified by RID = (1:253835:11) EDITWHEN = Mar 7 2006 6:35PM and DOCNUM = 421231 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 183754752000 owned by data record identified by RID = (1:254587:12) EDITWHEN = Apr 4 2006 2:11PM and DOCNUM = 430878 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 181863710720 owned by data record identified by RID = (1:254770:13) EDITWHEN = Apr 13 2006 10:45AM and DOCNUM = 427662 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 127582076928 owned by data record identified by RID = (1:255302:1) EDITWHEN = Apr 27 2006 3:33PM and DOCNUM = 335751 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 243133972480 owned by data record identified by RID = (1:256195:3) EDITWHEN = Jun 18 2007 1:37AM and DOCNUM = 535717 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 180270596096 owned by data record identified by RID = (1:256497:3) EDITWHEN = May 24 2006 12:06PM and DOCNUM = 424808 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 176867508224 owned by data record identified by RID = (1:256516:2) EDITWHEN = May 24 2006 3:20PM and DOCNUM = 418823 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 132764663808 owned by data record identified by RID = (1:259424:0) EDITWHEN = Jun 21 2007 2:01AM and DOCNUM = 322854 and VERSION = 2.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 235844730880 owned by data record identified by RID = (1:260029:0) EDITWHEN = Jun 21 2007 9:19AM and DOCNUM = 522982 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 70246727680 owned by data record identified by RID = (1:263169:1) EDITWHEN = Jun 15 2006 5:05PM and DOCNUM = 218997 and VERSION = 2.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 252161425408 owned by data record identified by RID = (1:267150:1) EDITWHEN = Jun 29 2007 2:17AM and DOCNUM = 551368 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 250440187904 owned by data record identified by RID = (1:268884:1) EDITWHEN = Jul 3 2007 7:07AM and DOCNUM = 548097 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 252899229696 owned by data record identified by RID = (1:268887:3) EDITWHEN = Jul 3 2007 7:19AM and DOCNUM = 552738 and VERSION = 2.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 247374348288 owned by data record identified by RID = (1:269197:6) EDITWHEN = Jul 4 2007 2:47AM and DOCNUM = 542832 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 70246727680 owned by data record identified by RID = (1:273514:4) EDITWHEN = Jul 11 2007 4:26AM and DOCNUM = 218997 and VERSION = 2.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 17055547392 owned by data record identified by RID = (1:273514:5) EDITWHEN = Jul 11 2007 4:27AM and DOCNUM = 103068 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 190558240768 owned by data record identified by RID = (1:278155:8) EDITWHEN = Jul 27 2006 3:49PM and DOCNUM = 443514 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 225814315008 owned by data record identified by RID = (1:279369:10) EDITWHEN = Jul 20 2007 3:30AM and DOCNUM = 506132 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 206225408000 owned by data record identified by RID = (1:281667:3) EDITWHEN = Jul 23 2007 3:23AM and DOCNUM = 449652 and VERSION = 8.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 248579358720 owned by data record identified by RID = (1:283210:3) EDITWHEN = Jul 25 2007 3:41AM and DOCNUM = 544720 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 252677914624 owned by data record identified by RID = (1:285801:6) EDITWHEN = Jul 29 2007 7:05AM and DOCNUM = 552331 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 247185997824 owned by data record identified by RID = (1:286463:3) EDITWHEN = Jul 30 2007 9:40AM and DOCNUM = 525566 and VERSION = 3.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 10331947008 owned by data record identified by RID = (1:286858:8) EDITWHEN = Jul 31 2007 1:52AM and DOCNUM = 84626 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 71545126912 owned by data record identified by RID = (1:286860:10) EDITWHEN = Jul 31 2007 2:01AM and DOCNUM = 224547 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 204838666240 owned by data record identified by RID = (1:288739:4) EDITWHEN = Aug 28 2006 2:44PM and DOCNUM = 469609 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 132764663808 owned by data record identified by RID = (1:290973:5) EDITWHEN = Sep 7 2006 3:55PM and DOCNUM = 322854 and VERSION = 2.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 41496477696 owned by data record identified by RID = (1:291224:7) EDITWHEN = Sep 14 2006 2:26PM and DOCNUM = 160458 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 211872514048 owned by data record identified by RID = (1:294648:6) EDITWHEN = Sep 22 2006 9:49AM and DOCNUM = 479398 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 73371942912 owned by data record identified by RID = (1:301158:8) EDITWHEN = Oct 2 2006 4:06PM and DOCNUM = 228381 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 215276191744 owned by data record identified by RID = (1:303316:6) EDITWHEN = Oct 6 2006 5:04PM and DOCNUM = 484020 and VERSION = 2.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 208979886080 owned by data record identified by RID = (1:303334:1) EDITWHEN = Oct 9 2006 11:20AM and DOCNUM = 477254 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 219683880960 owned by data record identified by RID = (1:307749:6) EDITWHEN = Nov 3 2006 2:36PM and DOCNUM = 446037 and VERSION = 7.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 71545126912 owned by data record identified by RID = (1:308015:17) EDITWHEN = Nov 15 2006 12:54PM and DOCNUM = 224547 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 225814315008 owned by data record identified by RID = (1:308666:16) EDITWHEN = Dec 11 2006 3:46PM and DOCNUM = 506132 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 195948838912 owned by data record identified by RID = (1:309091:7) EDITWHEN = Dec 19 2006 3:15PM and DOCNUM = 453377 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 211040141312 owned by data record identified by RID = (1:309183:7) EDITWHEN = Dec 26 2006 7:56AM and DOCNUM = 480799 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 235844730880 owned by data record identified by RID = (1:310481:14) EDITWHEN = Feb 12 2007 1:57AM and DOCNUM = 522982 and VERSION = 1.
DBCC results for 'MHGROUP.ARCHIVETBL'.
There are 0 rows in 0 pages for object 'MHGROUP.ARCHIVETBL'.
DBCC results for 'MHGROUP.USERHISTORY'.
There are 3325 rows in 37 pages for object 'MHGROUP.USERHISTORY'.
DBCC results for 'MHGROUP.RESTORETBL'.
There are 0 rows in 0 pages for object 'MHGROUP.RESTORETBL'.
DBCC results for 'MHGROUP.DOCMASTER'.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 229398937600 owned by data record identified by RID = (1:310481:15) EDITWHEN = Feb 12 2007 1:58AM and DOCNUM = 511737 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 236761710592 owned by data record identified by RID = (1:310531:3) EDITWHEN = Feb 13 2007 2:40AM and DOCNUM = 135768 and VERSION = 3.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 57178390528 owned by data record identified by RID = (1:310908:12) EDITWHEN = Feb 28 2007 12:48AM and DOCNUM = 193517 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 4776329216 owned by data record identified by RID = (1:310908:14) EDITWHEN = Feb 28 2007 12:51AM and DOCNUM = 67067 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 213345239040 owned by data record identified by RID = (1:311313:12) EDITWHEN = Mar 8 2007 7:40AM and DOCNUM = 484473 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 243133972480 owned by data record identified by RID = (1:312159:4) EDITWHEN = Mar 28 2007 3:04AM and DOCNUM = 535717 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 227707453440 owned by data record identified by RID = (1:312868:1) EDITWHEN = Apr 12 2007 4:05AM and DOCNUM = 509645 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 247127146496 owned by data record identified by RID = (1:312967:13) EDITWHEN = Apr 16 2007 2:48AM and DOCNUM = 542357 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 248579358720 owned by data record identified by RID = (1:313311:12) EDITWHEN = Apr 23 2007 11:26AM and DOCNUM = 544720 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 247185997824 owned by data record identified by RID = (1:313312:12) EDITWHEN = Apr 23 2007 11:31AM and DOCNUM = 525566 and VERSION = 3.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 233244852224 owned by data record identified by RID = (1:313352:10) EDITWHEN = Apr 24 2007 6:03AM and DOCNUM = 518211 and VERSION = 1.
Server: Msg 8935, Level 16, State 1, Line 1
Table error: Object ID 597577167, index ID 4. The previous link (1:321250) on page (1:321251) does not match the previous page (1:128129) that the parent (1:92152), slot 9 expects for this page.
Server: Msg 8936, Level 16, State 1, Line 1
Table error: Object ID 597577167, index ID 4. B-tree chain linkage mismatch. (1:128129)->next = (1:321251), but (1:321251)->Prev = (1:321250).
Server: Msg 8935, Level 16, State 1, Line 1
Table error: Object ID 597577167, index ID 22. The previous link (1:417102) on page (1:122442) does not match the previous page (1:127506) that the parent (1:321964), slot 59 expects for this page.
Server: Msg 8936, Level 16, State 1, Line 1
Table error: Object ID 597577167, index ID 22. B-tree chain linkage mismatch. (1:127506)->next = (1:122442), but (1:122442)->Prev = (1:417102).
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 597577167, index ID 22. Parent node for page (1:127505) was not encountered.
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 597577167, index ID 22. The high key value on page (1:282065) (level 0) is not less than the low key value in the parent (1:127505), slot 0 of the next page (1:417545).
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 597577167, index ID 22. The high key value on page (1:282065) (level 0) is not less than the low key value in the parent (1:127505), slot 0 of the next page (1:417545).
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 597577167, index ID 22. The high key value on page (1:417467) (level 1) is not less than the low key value in the parent (0:1), slot 0 of the next page (1:127505).
Server: Msg 8935, Level 16, State 1, Line 1
Table error: Object ID 597577167, index ID 22. The previous link (1:127505) on page (1:417624) does not match the previous page (1:417467) that the parent (1:416972), slot 8 expects for this page.
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 597577167, index ID 27. The high key value on page (1:127753) (level 0) is not less than the low key value in the parent (0:1), slot 0 of the next page (1:436964).
Server: Msg 8936, Level 16, State 1, Line 1
Table error: Object ID 597577167, index ID 27. B-tree chain linkage mismatch. (1:127754)->next = (1:436791), but (1:436791)->Prev = (1:436790).
Server: Msg 8935, Level 16, State 1, Line 1
Table error: Object ID 597577167, index ID 27. The previous link (1:436963) on page (1:436964) does not match the previous page (1:127753) that the parent (1:85406), slot 106 expects for this page.
Server: Msg 8936, Level 16, State 1, Line 1
Table error: Object ID 597577167, index ID 27. B-tree chain linkage mismatch. (1:127753)->next = (1:436964), but (1:436964)->Prev = (1:436963).
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:1760), slot 4, text ID 70246727680 is pointed to by page (1:273514), slot 4 and by page (1:263169), slot 1.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:2057), slot 84, text ID 153409421312 is pointed to by page (1:240034), slot 13 and by page (1:128065), slot 1.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:2172), slot 86, text ID 71545126912 is pointed to by page (1:286860), slot 10 and by page (1:308015), slot 17.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:6160), slot 48, text ID 148611661824 is pointed to by page (1:127824), slot 1 and by page (1:97144), slot 1.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:6328), slot 19, text ID 229398937600 is pointed to by page (1:127393), slot 0 and by page (1:310481), slot 15.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:8822), slot 59, text ID 132154130432 is pointed to by page (1:128397), slot 1 and by page (1:239829), slot 14.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:12815), slot 81, text ID 53393555456 is pointed to by page (1:241754), slot 16 and by page (1:128512), slot 0.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:16730), slot 87, text ID 97868775424 is pointed to by page (1:231817), slot 5 and by page (1:127992), slot 4.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:17759), slot 86, text ID 2315714560 is pointed to by page (1:217981), slot 11 and by page (1:127830), slot 4.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:26744), slot 8, text ID 4776329216 is pointed to by page (1:310908), slot 14 and by page (1:128396), slot 0.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:26744), slot 88, text ID 4781637632 is pointed to by page (1:128396), slot 1 and by page (1:217589), slot 1.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:28388), slot 88, text ID 108305776640 is pointed to by page (1:127996), slot 1 and by page (1:237547), slot 6.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:31464), slot 24, text ID 176867508224 is pointed to by page (1:128068), slot 0 and by page (1:256516), slot 2.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:31467), slot 15, text ID 127582076928 is pointed to by page (1:128068), slot 1 and by page (1:255302), slot 1.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:36278), slot 28, text ID 117782872064 is pointed to by page (1:126447), slot 2 and by page (1:235268), slot 9.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:43582), slot 44, text ID 251640938496 is pointed to by page (1:108119), slot 7 and by page (1:252074), slot 1.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:44314), slot 4, text ID 10331947008 is pointed to by page (1:286858), slot 8 and by page (1:105331), slot 1.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:45037), slot 52, text ID 132764663808 is pointed to by page (1:259424), slot 0 and by page (1:290973), slot 5.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:47759), slot 61, text ID 211872514048 is pointed to by page (1:127996), slot 5 and by page (1:294648), slot 6.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:55853), slot 51, text ID 251883880448 is pointed to by page (1:247655), slot 2 and by page (1:126371), slot 8.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:56802), slot 2, text ID 236761710592 is pointed to by page (1:310531), slot 3 and by page (1:128395), slot 0.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:57600), slot 69, text ID 249893486592 is pointed to by page (1:128544), slot 2 and by page (1:78576), slot 3.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:58994), slot 65, text ID 252161425408 is pointed to by page (1:267150), slot 1 and by page (1:116159), slot 0.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:60464), slot 49, text ID 166120128512 is pointed to by page (1:246003), slot 5 and by page (1:127392), slot 1.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:63176), slot 68, text ID 190558240768 is pointed to by page (1:128247), slot 3 and by page (1:278155), slot 8.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:64153), slot 44, text ID 183028940800 is pointed to by page (1:246096), slot 0 and by page (1:104120), slot 0.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:66227), slot 57, text ID 213345239040 is pointed to by page (1:311313), slot 12 and by page (1:128071), slot 2.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:68734), slot 32, text ID 17055547392 is pointed to by page (1:273514), slot 5 and by page (1:232186), slot 10.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:69921), slot 3, text ID 252471803904 is pointed to by page (1:243337), slot 1 and by page (1:120284), slot 4.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:69921), slot 36, text ID 252530786304 is pointed to by page (1:128070), slot 4 and by page (1:123815), slot 1.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:69925), slot 14, text ID 252677914624 is pointed to by page (1:285801), slot 6 and by page (1:126371), slot 4.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:70435), slot 84, text ID 17572626432 is pointed to by page (1:128245), slot 5 and by page (1:237531), slot 0.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:73290), slot 72, text ID 157604446208 is pointed to by page (1:128399), slot 4 and by page (1:253275), slot 6.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:73412), slot 44, text ID 252884549632 is pointed to by page (1:126217), slot 3 and by page (1:248826), slot 4.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:73412), slot 45, text ID 252885336064 is pointed to by page (1:126217), slot 4 and by page (1:131422), slot 1.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:73412), slot 65, text ID 252898705408 is pointed to by page (1:127392), slot 3 and by page (1:126371), slot 0.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:73412), slot 66, text ID 252900016128 is pointed to by page (1:127393), slot 1 and by page (1:126371), slot 6.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:73413), slot 11, text ID 252899229696 is pointed to by page (1:268887), slot 3 and by page (1:126371), slot 2.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:82724), slot 41, text ID 250440187904 is pointed to by page (1:268884), slot 1 and by page (1:125578), slot 10.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:82726), slot 41, text ID 250617135104 is pointed to by page (1:128070), slot 6 and by page (1:93581), slot 0.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:82727), slot 23, text ID 250536984576 is pointed to by page (1:241157), slot 1 and by page (1:122958), slot 2.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:91947), slot 44, text ID 136499429376 is pointed to by page (1:251952), slot 13 and by page (1:127831), slot 4.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:93297), slot 87, text ID 219683880960 is pointed to by page (1:127831), slot 2 and by page (1:307749), slot 6.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:100224), slot 14, text ID 251084603392 is pointed to by page (1:103097), slot 4 and by page (1:127395), slot 2.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:100592), slot 0, text ID 248579358720 is pointed to by page (1:283210), slot 3 and by page (1:313311), slot 12.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:100971), slot 86, text ID 164379951104 is pointed to by page (1:126447), slot 3 and by page (1:245986), slot 11.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:104784), slot 45, text ID 73371942912 is pointed to by page (1:301158), slot 8 and by page (1:127998), slot 0.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:113944), slot 40, text ID 183754752000 is pointed to by page (1:127392), slot 0 and by page (1:254587), slot 12.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:129608), slot 19, text ID 247127146496 is pointed to by page (1:312967), slot 13 and by page (1:234352), slot 0.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:129608), slot 62, text ID 247185997824 is pointed to by page (1:286463), slot 3 and by page (1:313312), slot 12.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:130151), slot 6, text ID 247374348288 is pointed to by page (1:269197), slot 6 and by page (1:101411), slot 1.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:143138), slot 76, text ID 233244852224 is pointed to by page (1:128392), slot 5 and by page (1:313352), slot 10.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:148306), slot 43, text ID 41496477696 is pointed to by page (1:291224), slot 7 and by page (1:128070), slot 1.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:150355), slot 15, text ID 226056470528 is pointed to by page (1:127999), slot 1 and by page (1:79561), slot 4.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:163849), slot 44, text ID 208979886080 is pointed to by page (1:127996), slot 3 and by page (1:303334), slot 1.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:167976), slot 42, text ID 215276191744 is pointed to by page (1:128241), slot 2 and by page (1:303316), slot 6.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:173613), slot 50, text ID 190233706496 is pointed to by page (1:70653), slot 1 and by page (1:226945), slot 0.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:196399), slot 67, text ID 57178390528 is pointed to by page (1:310908), slot 12 and by page (1:128396), slot 2.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:202131), slot 10, text ID 58982203392 is pointed to by page (1:125063), slot 1 and by page (1:127825), slot 2.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:204002), slot 87, text ID 181863710720 is pointed to by page (1:254770), slot 13 and by page (1:128399), slot 3.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:212002), slot 75, text ID 204838666240 is pointed to by page (1:127398), slot 0 and by page (1:288739), slot 4.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:223699), slot 1, text ID 243133972480 is pointed to by page (1:256195), slot 3 and by page (1:312159), slot 4.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:233650), slot 52, text ID 235844730880 is pointed to by page (1:310481), slot 14 and by page (1:260029), slot 0.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:236621), slot 38, text ID 211040141312 is pointed to by page (1:309183), slot 7 and by page (1:128240), slot 2.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:242372), slot 87, text ID 180270596096 is pointed to by page (1:256497), slot 3 and by page (1:128064), slot 3.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:253181), slot 85, text ID 227707453440 is pointed to by page (1:312868), slot 1 and by page (1:128245), slot 3.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:266611), slot 43, text ID 225814315008 is pointed to by page (1:279369), slot 10 and by page (1:308666), slot 16.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:357824), slot 81, text ID 178253660160 is pointed to by page (1:252644), slot 5 and by page (1:253835), slot 11.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:373278), slot 67, text ID 195948838912 is pointed to by page (1:127826), slot 1 and by page (1:309091), slot 7.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:413233), slot 14, text ID 206225408000 is pointed to by page (1:281667), slot 3 and by page (1:123289), slot 0.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:457340), slot 66, text ID 246325903360 is pointed to by page (1:127996), slot 2 and by page (1:126371), slot 7.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:126554) allocated to object ID 1525580473, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:126555) allocated to object ID 1525580473, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:126556) allocated to object ID 1525580473, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:126557) allocated to object ID 1525580473, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:126558) allocated to object ID 1525580473, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:126559) allocated to object ID 1525580473, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:127680) allocated to object ID 1525580473, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:127681) allocated to object ID 1525580473, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:127682) allocated to object ID 1525580473, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:127683) allocated to object ID 1525580473, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:127684) allocated to object ID 1525580473, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:127685) allocated to object ID 1525580473, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:127686) allocated to object ID 1525580473, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:127687) allocated to object ID 1525580473, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:127904) allocated to object ID 1525580473, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:127905) allocated to object ID 1525580473, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:127906) allocated to object ID 1525580473, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:127907) allocated to object ID 1525580473, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:127908) allocated to object ID 1525580473, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:127909) allocated to object ID 1525580473, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:127910) allocated to object ID 1525580473, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:127911) allocated to object ID 1525580473, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:127952) allocated to object ID 1525580473, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:127953) allocated to object ID 1525580473, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:127954) allocated to object ID 1525580473, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:127955) allocated to object ID 1525580473, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:127956) allocated to object ID 1525580473, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:127957) allocated to object ID 1525580473, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:127958) allocated to object ID 1525580473, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:127959) allocated to object ID 1525580473, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:128056) allocated to object ID 1525580473, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:128057) allocated to object ID 1525580473, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:128058) allocated to object ID 1525580473, index ID 0 was not seen. Page may be invalid or have incorrect obj
View 5 Replies
View Related
Sep 6, 2007
Hello all,
I have a problem on SQL 2000 Server Std (inc sP4)
OS: Windows 2000 Server
What can i do for errors?
DBCC CHECKDB ('GOLD_DB, REPAIR_ALLOW_DATA_LOSS)
DBCC results for 'GOLD_DB'.
DBCC results for 'sysobjects'.
...
CHECKDB found 0 allocation errors and 24 consistency errors in database 'GOLD_DB'.
CHECKDB fixed 0 allocation errors and 24 consistency errors in database 'GOLD_DB'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Greetings from istanbul, regards.
View 8 Replies
View Related
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
Feb 28, 2007
I’ve got a big problem with my Database,
Whenever I runs my query I’ve got error on the half way.
I’m using MSSQL 2000.
So I run DBCC CHECKDB and the follow errors result shown.
I don’t know how to solve that problem.
Plz help me plz help me
If that database crush I’m gonna be fu*ked up by my boss.
:...( plz
DBCC results for 'Table_1'.
Server: Msg 8928, Level 16, State 2, Line 1
Object ID 795149878, index ID 0: Page (1:352679) could not be processed. See other errors for details.
Server: Msg 8944, Level 16, State 1, Line 1
Table error: Object ID 795149878, index ID 0, page (1:352679), row 44. Test (!(hdr->r_tagA & (VERSION_MASK | RECTAG_RESV_A | RECTAG_RESV_B))) failed. Values are 157 and 193.
Server: Msg 8944, Level 16, State 1, Line 1
Table error: Object ID 795149878, index ID 0, page (1:352679), row 44. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 18754 and 3160.
There are 0 rows in 1 pages for object 'Total_Profit_Loss'.
Server: Msg 2511, Level 16, State 2, Line 1
Table error: Object ID 1211151360, Index ID 0. Keys out of order on page (1:161199), slots 25 and 26.
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 1211151360, Index ID 0. Keys out of order on page (1:173791), slots 4 and 5.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1211151360, index ID 0: Page (1:206443) could not be processed. See other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 1211151360, index ID 0, page (1:206443). Test (m_freeCnt == freeCnt) failed. Values are 660 and 692.
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 1211151360, Index ID 0. Keys out of order on page (1:217603), slots 18 and 19.
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 1211151360, Index ID 0. Keys out of order on page (1:266945), slots 26 and 27.
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 1211151360, Index ID 0. Keys out of order on page (1:268051), slots 28 and 29.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1211151360, index ID 0: Page (1:277634) could not be processed. See other errors for details.
DBCC results for 'Pin'.
Server: Msg 8939, Level 16, State 106, Line 1
Table error: Object ID 1211151360, index ID 0, page (1:277634). Test (m_freeCnt == freeCnt) failed. Values are 2168 and 2164.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1211151360, index ID 0: Page (1:299697) could not be processed. See other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 1211151360, index ID 0, page (1:299697). Test (m_freeCnt == freeCnt) failed. Values are 3435 and 3431.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1211151360, index ID 0: Page (1:302290) could not be processed. See other errors for details.
Server: Msg 8944, Level 16, State 1, Line 1
Table error: Object ID 1211151360, index ID 0, page (1:302290), row 12. Test (((UNALIGNED DataRecHdr*) m_pRec)->r_tagB == 0) failed. Values are 4 and 0.
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 1211151360, Index ID 0. Keys out of order on page (1:900223), slots 2 and 3.
There are 5940869 rows in 210312 pages for object 'Pin'.
CHECKDB found 0 allocation errors and 14 consistency errors in table 'Pin' (object ID 1211151360).
CHECKDB found 0 allocation errors and 23 consistency errors in database 'MY_SQL_DB'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (MY_SQL_DB ).
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
View 1 Replies
View Related
Jun 19, 2006
Paul writes "Hi,
We have run the following command...
DBCC CHECKDB ('db_name')
... and 12'622 consistency errors were found (all on the same index on the same table).
So next we ran...
DBCC CHECKTABLE ('table_name', REPAIR_ALLOW_DATA_LOSS)
... and this fixed SOME of the errors, but not all...
12586 consistency errors in table
Does anyone have any ideas?
Just to confirm this is SQL Server 2000.
I do have both of the results logs available if that would help.
Many Thanks,
Paul."
View 2 Replies
View Related
Jul 27, 2006
Hi,
Ran DBCC CHECKDB on my database and it's returning the following:
There are 460 rows in 13 pages for object 'KPW'.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1977058079, index ID 0: Page (1:1868079) could not be processed. See other errors for details.
Server: Msg 8944, Level 16, State 1, Line 1
Table error: Object ID 1977058079, index ID 0, page (1:1868079), row 76. Test (!(hdr->r_tagA & (VERSION_MASK | RECTAG_RESV_A | RECTAG_RESV_B))) failed. Values are 173 and 193.
Server: Msg 8944, Level 16, State 1, Line 1
Table error: Object ID 1977058079, index ID 0, page (1:1868079), row 76. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 16374 and 33.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1977058079. The text, ntext, or image node at page (1:1867931), slot 8, text ID 205274873856 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1977058079. The text, ntext, or image node at page (1:1867932), slot 0, text ID 205275004928 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1977058079. The text, ntext, or image node at page (1:1867932), slot 2, text ID 205275136000 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Suggestions on how to troubleshoot/fix?
Thanks!
View 19 Replies
View Related
Jun 3, 2008
I have a database that was handed to me which is getting the following errors:
DBCC CHECKDB ('DBName') returns:
Server: Msg 8939, Level 16, State 106, Line 1
Table error: Object ID 1, index ID 0, page (1:37). Test (m_freeCnt == freeCnt) failed. Values are 680 and 788.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (1:37) with latch type SH. sysobjects failed.
DBCC PAGE (DBName, 1, 37, 1) returns:
Server: Msg 8939, Level 16, State 20, Line 1
Table error: Object ID 99, index ID 0, page (1:2). Test (m_slots[0].GetOffset () == PAGEHEADSIZE) failed. Values are 662 and 96.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 99, index ID 0, page (1:2). Test (Align(m_slots[-1].GetOffset ()) == Align(m_slots[0].GetOffset () + sizeof(GAMHEADER) + sizeof(DataRecHdr))) failed. Values are 190 and 756.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC PAGE (DBName, 1, 2, 1) returns:
Server: Msg 8939, Level 16, State 20, Line 1
Table error: Object ID 99, index ID 0, page (1:2). Test (m_slots[0].GetOffset () == PAGEHEADSIZE) failed. Values are 662 and 96.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 99, index ID 0, page (1:2). Test (Align(m_slots[-1].GetOffset ()) == Align(m_slots[0].GetOffset () + sizeof(GAMHEADER) + sizeof(DataRecHdr))) failed. Values are 190 and 756.
Server: Msg 3624, Level 20, State 1, Line 1
Location: recbase.cpp:1374
Expression: m_nVars > 0
SPID: 51
Process ID: 2096
Connection Broken
And finally, DBCC CHECKTABLE (sysobjects) WITH NO_INFOMSGS, ALL_ERRORMSGS gives me:
Server: Msg 8939, Level 16, State 106, Line 1
Table error: Object ID 1, index ID 0, page (1:37). Test (m_freeCnt == freeCnt) failed. Values are 680 and 788.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (1:37) with latch type SH. sysobjects failed.
I've looked at the MDF with a hex editor and there's definitely data in there. I have the DB attached and in single user/emergency mode, but DBCC isn't having much luck. Help?
View 9 Replies
View Related
Dec 2, 2005
I actually ran this on a reporting copy of my DB (restored once a week). I would guess the errors are present in the main copy as well. I fear running the check during production hours as it takes 2.5 hours and the system (4 processor) is under a lot of load for almost the entire day and much of the night.
So I've got errors on the tables:
sessions ID(462624691)
map ID(510624862)
links ID(1790629422)
It looks like the repair with data loss is my only choice but I would definitely prefer to know which rows are messed up. I'm also wary of running the repair as it's probably going to take well over an hour on the huge sessions table. I don't know how it got in this corrupted state. I inherited a DB of this size (50GB) that's been known to be very sensitive to any admin or index fiddling due to the high load. After I get this repaired I feel I should run the CHECKDB in a maintenance plan but I'm not sure if this will cause slowdowns in itself if it runs for 2.5 hours. The DB backup takes over 2 hours leaving almost no spare time in the off peak time.
Any advice/suggestions? Thanks.
DBCC results for 'dbloc'.
DBCC results for 'sessions'.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 462624691, index ID 0: Page (1:9517861) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 462624691, index ID 0: Page (1:9659261) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 462624691, index ID 7: Page (1:5825743) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 462624691, index ID 7: Page (1:5890660) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 462624691, index ID 7: Page (1:5931145) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 462624691, index ID 7: Page (1:5950021) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 462624691, index ID 7: Page (1:5978420) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 462624691, index ID 7: Page (1:5988261) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 462624691, index ID 7: Page (1:6046306) could not be processed. See other errors for details.
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 510624862, Index ID 0. Keys out of order on page (1:11853027), slots 109 and 110.
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 510624862, Index ID 0. Keys out of order on page (1:11853027), slots 112 and 113.
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 510624862, Index ID 0. Keys out of order on page (1:11853027), slots 113 and 114.
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 510624862, Index ID 0. Keys out of order on page (1:11853027), slots 114 and 115.
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 510624862, Index ID 0. Keys out of order on page (1:11853027), slots 117 and 118.
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 510624862, Index ID 0. Keys out of order on page (1:11853027), slots 118 and 119.
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 510624862, Index ID 0. Keys out of order on page (1:11853027), slots 121 and 122.
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 510624862, Index ID 0. Keys out of order on page (1:11853027), slots 122 and 123.
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 510624862, Index ID 0. Keys out of order on page (1:11853027), slots 124 and 125.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 510624862, index ID 0: Page (1:11858027) could not be processed. See other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 510624862, index ID 0, page (1:11858027). Test (IS_ON (BUF_IOERR, bp->bstat) &&bp->berrcode) failed. Values are 2057 and -1.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 510624862, index ID 0: Page (1:11865547) could not be processed. See other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 510624862, index ID 0, page (1:11865547). Test (IS_ON (BUF_IOERR, bp->bstat) &&bp->berrcode) failed. Values are 2057 and -1.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 510624862, index ID 2: Page (1:11889147) could not be processed. See other errors for details.
DBCC results for 'sessions'.
There are 153364096 rows in 3102681 pages for object 'sessions'.
CHECKDB found 0 allocation errors and 9 consistency errors in table 'sessions' (object ID 462624691).
DBCC results for 'map'.
Server: Msg 8939, Level 16, State 98, Line 1
Table error: Object ID 510624862, index ID 2, page (1:11889147). Test (IS_ON (BUF_IOERR, bp->bstat) &&bp->berrcode) failed. Values are 2057 and -1.
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 510624862, Index ID 3. Keys out of order on page (1:11931268), slots 206 and 207.
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 510624862, Index ID 3. Keys out of order on page (1:11931268), slots 209 and 210.
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 510624862, Index ID 3. Keys out of order on page (1:11931268), slots 210 and 211.
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 510624862, Index ID 3. Keys out of order on page (1:11931268), slots 230 and 231.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 510624862, index ID 11: Page (1:11988308) could not be processed. See other errors for details.
Server: Msg 8944, Level 16, State 1, Line 1
Table error: Object ID 510624862, index ID 11, page (1:11988308), row 194. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 7251 and 18.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 510624862, index ID 11: Page (1:12003992) could not be processed. See other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 510624862, index ID 11, page (1:12003992). Test (IS_ON (BUF_IOERR, bp->bstat) &&bp->berrcode) failed. Values are 2057 and -1.
There are 15576829 rows in 65455 pages for object 'map'.
CHECKDB found 0 allocation errors and 23 consistency errors in table 'map' (object ID 510624862).
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1790629422, index ID 16: Page (1:11471717) could not be processed. See other errors for details.
Server: Msg 8944, Level 16, State 1, Line 1
Table error: Object ID 1790629422, index ID 16, page (1:11471717), row 88. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 3500 and 28.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1790629422, index ID 16: Page (1:11474112) could not be processed. See other errors for details.
Server: Msg 8944, Level 16, State 1, Line 1
Table error: Object ID 1790629422, index ID 16, page (1:11474112), row 108. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 745 and 20.
DBCC results for 'links'.
There are 9919777 rows in 124284 pages for object 'links'.
CHECKDB found 0 allocation errors and 4 consistency errors in table 'links' (object ID 1790629422).
CHECKDB found 0 allocation errors and 36 consistency errors in database 'dbloc'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (dbloc ).
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
View 2 Replies
View Related
Feb 4, 2006
Hi,
I am running SQL Server 2000 with Service Pack 4. We recently had a rather nasty corruption problem over several of our databases on our server. It primarily affected indexes and page allocation tables. As of yet, we have yet to identify the cause of this problem. We ran hardware diagnostics and no problems were returned, and nothing aside from the errors that alerted us to the issue in the first place were found in the event logs or SQL error logs.
DBCC CHECKDB was ran several times (we ran it on all DBs on the server just to be safe, several came up corrupted) and used that to repair the data, but very quickly new corruptions popped up.
However, this is not the extent of my bewilderment. Due to the need to get our server back online, a couple co-workers decided to detatch the databases and reinstall the SQL server, then reattatch the databases and try and repair them. I am not sure why this would have mattered but it seems to have prevented any new corruptions.
Anyway, while I was repairing the problem databases to bring them back online, one of them has been giving me a particular problem. Several indexes were pretty thoroughly trashed, giving over 1000 consistency errors. There were also around 25 or so allocation errors. I rebuilt all of the indexes to remove the consistency errors, however the allocation errors still remain and CHECKDB will not remove them. Here are the results of my most recent checkdb repair attempt:
Server: Msg 8905, Level 16, State 1, Line 1
Extent (1:886000) in database ID 37 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
Server: Msg 8905, Level 16, State 1, Line 1
Extent (1:886112) in database ID 37 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
Server: Msg 8905, Level 16, State 1, Line 1
Extent (1:886224) in database ID 37 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
Server: Msg 8905, Level 16, State 1, Line 1
Extent (1:886424) in database ID 37 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
Server: Msg 8905, Level 16, State 1, Line 1
Extent (1:886520) in database ID 37 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
Server: Msg 8905, Level 16, State 1, Line 1
Extent (1:886656) in database ID 37 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
Server: Msg 8905, Level 16, State 1, Line 1
Extent (1:886736) in database ID 37 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
Server: Msg 8905, Level 16, State 1, Line 1
Extent (1:886936) in database ID 37 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
Server: Msg 8905, Level 16, State 1, Line 1
Extent (1:887024) in database ID 37 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
Server: Msg 8905, Level 16, State 1, Line 1
Extent (1:887176) in database ID 37 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
Server: Msg 8905, Level 16, State 1, Line 1
Extent (1:887344) in database ID 37 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
Server: Msg 8905, Level 16, State 1, Line 1
Extent (1:887464) in database ID 37 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
Server: Msg 8905, Level 16, State 1, Line 1
Extent (1:887624) in database ID 37 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
Server: Msg 8905, Level 16, State 1, Line 1
Extent (1:887816) in database ID 37 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
Server: Msg 8905, Level 16, State 1, Line 1
Extent (1:887920) in database ID 37 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
Server: Msg 8905, Level 16, State 1, Line 1
Extent (1:888096) in database ID 37 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
Server: Msg 8905, Level 16, State 1, Line 1
Extent (1:888248) in database ID 37 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
Server: Msg 8905, Level 16, State 1, Line 1
Extent (1:888352) in database ID 37 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
Server: Msg 8905, Level 16, State 1, Line 1
Extent (1:888584) in database ID 37 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
Could not repair this error.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Server: Msg 8905, Level 16, State 1, Line 1
Extent (1:888704) in database ID 37 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
Server: Msg 8905, Level 16, State 1, Line 1
Extent (1:888840) in database ID 37 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
Server: Msg 8905, Level 16, State 1, Line 1
Extent (1:889024) in database ID 37 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
Server: Msg 8905, Level 16, State 1, Line 1
Extent (1:889168) in database ID 37 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
Server: Msg 8905, Level 16, State 1, Line 1
Extent (1:889328) in database ID 37 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
CHECKDB found 24 allocation errors and 0 consistency errors not associated with any single object.
CHECKDB found 24 allocation errors and 0 consistency errors in database 'PRODUCTION_CATEGORIZER'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (PRODUCTION_CATEGORIZER repair_allow_data_loss).
As you can see, it is telling me that the errors cannot be repaired until other errors are corrected first, but there are no other errors! I cannot figure it out. The rest of our databases on the server are now clean, this is the only one that is not working. Does anyone have any suggestions before we restore to the last backup?
View 7 Replies
View Related
Oct 12, 2007
I've seen a lot of approaches to this, but I wanted to check here first before trying anything. Unfortunately, I just arrived and looking over the database, realized their backups have been failing for quite sometime. The application using the database is running fine so far, but backing it up freezes. I run DBCC CHECKDB (MyDB) WITH NO_INFOMSGS, ALL_ERRORMSGS and get:
Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 844424953200640 (type Unknown), page ID (1:26483) contains an incorrect page ID in its page header. The PageId in the page header = (0:0).
Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 2533274801405952 (type Unknown), page ID (1:24589) contains an incorrect page ID in its page header. The PageId in the page header = (0:-1694496760).
Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 2533274811367424 (type Unknown), page ID (1:24301) contains an incorrect page ID in its page header. The PageId in the page header = (0:-1694496747).
Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 2533279088508928 (type Unknown), page ID (1:24334) contains an incorrect page ID in its page header. The PageId in the page header = (0:0).
CHECKDB found 0 allocation errors and 4 consistency errors not associated with any single object.
Msg 8928, Level 16, State 1, Line 1
Object ID 1093578934, index ID 1, partition ID 353143765729280, alloc unit ID 71668789018624 (type In-row data): Page (1:22417) could not be processed. See other errors for details.
Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 1093578934, index ID 1, partition ID 353143765729280, alloc unit ID 71668789018624 (type In-row data). Page (1:521649) is missing a reference from previous page (1:22417). Possible chain linkage problem.
Msg 8939, Level 16, State 98, Line 1
Table error: Object ID 1093578934, index ID 1, partition ID 353143765729280, alloc unit ID 353143765729280 (type In-row data), page (1:22417). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 29362185 and -1.
Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 1093578934, index ID 1, partition ID 353143765729280, alloc unit ID 353143765729280 (type In-row data). Page (1:22417) was not seen in the scan although its parent (1:479) and previous (1:715544) refer to it. Check any previous errors.
CHECKDB found 0 allocation errors and 4 consistency errors in table 'WebGroups' (object ID 1093578934).
Msg 8929, Level 16, State 1, Line 1
Object ID 1993058136, index ID 1, partition ID 412092034711552, alloc unit ID 130617058000896 (type In-row data): Errors found in off-row data with ID 1606680576 owned by data record identified by RID = (1:1620895:7)
Msg 8929, Level 16, State 1, Line 1
Object ID 1993058136, index ID 1, partition ID 412092034711552, alloc unit ID 130617058000896 (type In-row data): Errors found in off-row data with ID 1606811648 owned by data record identified by RID = (1:1620895:8)
Msg 8929, Level 16, State 1, Line 1
Object ID 1993058136, index ID 1, partition ID 412092034711552, alloc unit ID 130617058000896 (type In-row data): Errors found in off-row data with ID 1607073792 owned by data record identified by RID = (1:1620895:10)
Msg 8929, Level 16, State 1, Line 1
Object ID 1993058136, index ID 1, partition ID 412092034711552, alloc unit ID 130617058000896 (type In-row data): Errors found in off-row data with ID 1607204864 owned by data record identified by RID = (1:1620895:11)
Msg 8929, Level 16, State 1, Line 1
Object ID 1993058136, index ID 1, partition ID 412092034711552, alloc unit ID 130617058000896 (type In-row data): Errors found in off-row data with ID 1608908800 owned by data record identified by RID = (1:1620896:10)
Msg 8928, Level 16, State 1, Line 1
Object ID 1993058136, index ID 1, partition ID 412092034711552, alloc unit ID 71906736119218176 (type LOB data): Page (1:24301) could not be processed. See other errors for details.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 1993058136, index ID 1, partition ID 412092034711552, alloc unit ID 71906736119218176 (type LOB data). The off-row data node at page (1:24301), slot 0, text ID 1606680576 is referenced by page (1:24298), slot 0, but was not seen in the scan.
Msg 8928, Level 16, State 1, Line 1
Object ID 1993058136, index ID 1, partition ID 412092034711552, alloc unit ID 71906736119218176 (type LOB data): Page (1:24334) could not be processed. See other errors for details.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 1993058136, index ID 1, partition ID 412092034711552, alloc unit ID 71906736119218176 (type LOB data). The off-row data node at page (1:24334), slot 0, text ID 1606811648 is referenced by page (1:24331), slot 0, but was not seen in the scan.
Msg 8928, Level 16, State 1, Line 1
Object ID 1993058136, index ID 1, partition ID 412092034711552, alloc unit ID 71906736119218176 (type LOB data): Page (1:24462) could not be processed. See other errors for details.
Msg 8939, Level 16, State 98, Line 1
Table error: Object ID 1993058136, index ID 1, partition ID 412092034711552, alloc unit ID 71906736119218176 (type LOB data), page (1:24462). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 29362185 and -1.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 1993058136, index ID 1, partition ID 412092034711552, alloc unit ID 71906736119218176 (type LOB data). The off-row data node at page (1:24462), slot 0, text ID 1607073792 is referenced by page (1:24429), slot 0, but was not seen in the scan.
Msg 8928, Level 16, State 1, Line 1
Object ID 1993058136, index ID 1, partition ID 412092034711552, alloc unit ID 71906736119218176 (type LOB data): Page (1:24589) could not be processed. See other errors for details.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 1993058136, index ID 1, partition ID 412092034711552, alloc unit ID 71906736119218176 (type LOB data). The off-row data node at page (1:24589), slot 0, text ID 1607204864 is referenced by page (1:24591), slot 0, but was not seen in the scan.
Msg 8928, Level 16, State 1, Line 1
Object ID 1993058136, index ID 1, partition ID 412092034711552, alloc unit ID 71906736119218176 (type LOB data): Page (1:26483) could not be processed. See other errors for details.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 1993058136, index ID 1, partition ID 412092034711552, alloc unit ID 71906736119218176 (type LOB data). The off-row data node at page (1:26483), slot 0, text ID 1608908800 is referenced by page (1:26470), slot 0, but was not seen in the scan.
CHECKDB found 0 allocation errors and 16 consistency errors in table 'Docs' (object ID 1993058136).
CHECKDB found 0 allocation errors and 24 consistency errors in database 'MyDB'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (MyDB).
View 5 Replies
View Related
Jan 24, 2008
SQL 2005
I ran the following:
DBCC CHECKDB (€˜DATABASENAME€™)
Errors are produced
DBCC CHECKDB ('DATABASENAME')
DBCC results for 'AllDocStreams'.
Msg 8914, Level 16, State 1, Line 1
Incorrect PFS free space information for page (1:26839) in object ID 181575685, index ID 1, partition ID 293374720802816, alloc unit ID 71788018805309440 (type LOB data). Expected value 0_PCT_FULL, actual value 100_PCT_FULL.
I wanted to view the PAGE by doing
dbcc traceon(3604)
DBCC PAGE (1,26839,1)
(But keeps telling me there is no page)
So i tried
DBCC IND('TEST','AllDocStreams',1)
Found the PagePID of 26839 then i found IAMFID so i tried
DBCC PAGE (1,1577,3)
still no page
I was trying to find the PCT FULL on the page? but can't find the page its talking about.
I can do a REPAIR_WITH_DATA_LOSS but i wanted to figure out what it is actually repairing and what the message is really telling me
Thanks
View 4 Replies
View Related
Feb 10, 2004
Recently, I've started to get DBCC Checkdb errors against a few databases - seems to be since applying sp3a.
The error (2537) affects certain tables that contain SQL_Variant fields. I just completed an exercise to run DBCC CHECKDB ('dbname', REPAIR_ALLOW_DATA_LOSS) against a copy of the offending table - then comparing the original table and the repaired table to isolate the rows that throw up the consistency errors. What I found was that all the rows trapped by DBCC CHECKDB for error 2537 contain real numbers in the SQL_Variant field. All other rows with text or integer contents in the SQL_Variant field do not throw up errors.
I tried a MS hotfix for error 2537 but it didn't fix the problem. Any ideas?
Clive
View 6 Replies
View Related
Jan 30, 2007
Hi all
I have a database that is being restored to another instance of SQL server 2000 sp4 by attatching the mdf and ldf files. I then run EXEC sp_change_users_login to sync the users. When I try to run some delete commands on the new restored database I get 'Fatal error 8908'
I then run a DBCC CHECKDB on the database and told to run it again with REPAIR_ALLOW_DATA_LOSS
I have noticed that when I create a new databse and restore a .bak over this the delete commands work.
Am I correct in thinking that I can get rid of the corruption on the original database by creating a new database then restoring a valid .bak backup on this new database.
View 3 Replies
View Related
