Does any one know how to resolve DBCC errors 9000 to 9999? The BOL does not give any explaination as to how to handle such errors. Microsoft search engine also does not offer any help on these error messags.
Thanks.
Following the below topic:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=53271
I followed the advice of Paul Randal, but Im stumped as I am not able to determin what the corruption issues are. This is SQL 2000 and the database is a Solomon database that was recently upgraded to 6.5. the error I get when running the DBCC checkdb is as follows:
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (1:18645) with latch type SH. sysindexes failed.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
When I run select * from sysindexes, I get:
Server: Msg 3624, Level 20, State 1, Line 1
Location: blobman.cpp:1780
Expression: sourceLength == sizeof (TextPointer)
SPID: 53
Process ID: 256
Connection Broken
When I run dbcc page (dbname, 1, 18645, 3)
dbcc traceon(3604), It finishes with what appears to be no errors log is as follows:
PAGE: (1:18645)
---------------
BUFFER:
-------
BUF @0x0144C880
---------------
bpage = 0x681B4000 bhash = 0x00000000 bpageno = (1:18645)
bdbid = 12 breferences = 1 bstat = 0x9
bspin = 0 bnext = 0x00000000
PAGE HEADER:
------------
Page @0x681B4000
----------------
m_pageId = (1:18645) m_headerVersion = 1 m_type = 1
m_typeFlagBits = 0x0 m_level = 0 m_flagBits = 0x2
m_objId = 2 m_indexId = 0 m_prevPage = (1:505)
m_nextPage = (1:213) pminlen = 82 m_slotCnt = 16
m_freeCnt = 3988 m_freeData = 5796 m_reservedCnt = 0
m_lsn = (42700:4549:10) m_xactReserved = 0 m_xdesId = (0:2539719)
m_ghostRecCnt = 0 m_tornBits = 0
Allocation Status
-----------------
GAM (1:2) = ALLOCATED SGAM (1:3) = NOT ALLOCATED
PFS (1:16176) = 0x40 ALLOCATED 0_PCT_FULL DIFF (1:6) = CHANGED
ML (1:7) = NOT MIN_LOGGED
Slot 0 Offset 0xf8c
-------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B4F8C: 00520030 013f142a 00004012 00000000 0.R.*.?..@......
681B4F9C: 00010000 00000000 02600000 00010001 ..........`.....
681B4FAC: 00000000 00000000 00000000 00000000 ................
681B4FBC: 00000000 00000000 027a0000 00000022 ..........z."...
681B4FCC: 00000000 00000000 00000000 00000000 ................
681B4FDC: 001b0000 00000000 00800003 80a60096 ................
681B4FEC: 00af03af 0000000a 3400d008 00000000 ...........4....
681B4FFC: 0001000a 00000000 00010016 00000000 ................
681B500C: 006d0073 006e0049 00420076 00740061 s.m.I.n.v.B.a.t.
681B501C: 00680063 00000030 002a869d 00570000 c.h.0.....*...W.
681B502C: 00010000 0007 ......
id = 20911146
status = 16402
first = 0
indid = 1
root = 0
minlen = 608
keycnt = 1
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 634
maxirow = 34
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0
keys
--------------------------------
681B4FEC: 00af03af 0000000a 3400d008 00000000 ...........4....
681B4FFC: 0001000a 00000000 00010016 00000000 ................
name = smInvBatch0
statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182647062528 RowId = (1:87:7)
Slot 1 Offset 0x12c4
--------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B52C4: 00520030 013f142a 00000000 00000000 0.R.*.?.........
681B52D4: 00020000 00000000 00150000 00010003 ................
681B52E4: 00000000 00000000 00000000 00000000 ................
681B52F4: 00000000 00000000 00260000 0000002c ..........&.,...
681B5304: 00000000 00000000 00000000 00000000 ................
681B5314: 001b0000 00000000 00c00003 80e600d6 ................
681B5324: 00af03af 0000000a 3400d008 00000000 ...........4....
681B5334: 00010016 00000000 00010072 00000000 ........r.......
681B5344: 00af03af 0000000a 3400d008 00000000 ...........4....
681B5354: 000b000a 00000000 000b0016 00000000 ................
681B5364: 00af03af 0000000a 3400d008 00000000 ...........4....
681B5374: 000b000a 00000000 00010016 00030000 ................
681B5384: 006d0073 006e0049 00420076 00740061 s.m.I.n.v.B.a.t.
681B5394: 00680063 00000031 002a869f 00570000 c.h.1.....*...W.
681B53A4: 00010000 0008 ......
id = 20911146
status = 0
first = 0
indid = 2
root = 0
minlen = 21
keycnt = 3
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 38
maxirow = 44
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0
keys
--------------------------------
681B5324: 00af03af 0000000a 3400d008 00000000 ...........4....
681B5334: 00010016 00000000 00010072 00000000 ........r.......
681B5344: 00af03af 0000000a 3400d008 00000000 ...........4....
681B5354: 000b000a 00000000 000b0016 00000000 ................
681B5364: 00af03af 0000000a 3400d008 00000000 ...........4....
681B5374: 000b000a 00000000 00010016 00030000 ................
name = smInvBatch1
statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182647193600 RowId = (1:87:8)
Slot 2 Offset 0x1440
--------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B5440: 00520030 01584911 00004012 000000c6 0.R..IX..@......
681B5450: 00010001 00000095 09a20001 00010001 ................
681B5460: 00000001 00000005 00000005 00000000 ................
681B5470: 00000000 00000003 09ba0000 0000001a ................
681B5480: 00000000 00000096 00000001 00000000 ................
681B5490: 001b0000 00000000 00800003 80a60096 ................
681B54A0: 00340134 00050002 00000000 00000000 4.4.............
681B54B0: 00010020 00000000 000102c1 00000000 ...............
681B54C0: 00700052 00520074 006e0075 00690074 R.p.t.R.u.n.t.i.
681B54D0: 0065006d 00000030 002a87a9 03a00000 m.e.0.....*.....
681B54E0: 00010000 0019 ......
id = 22563089
status = 16402
first = 0
indid = 1
root = 0
minlen = 2466
keycnt = 1
groupid = 1
dpages = 1
reserved = 5
used = 5
rowcnt = 0
rowmodctr = 3
reserved3 = 0
reserved4 = 0
xmaxlen = 2490
maxirow = 26
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0
keys
--------------------------------
681B54A0: 00340134 00050002 00000000 00000000 4.4.............
681B54B0: 00010020 00000000 000102c1 00000000 ...............
name = RptRuntime0
statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182664626176 RowId = (1:928:25)
Slot 3 Offset 0x15bc
--------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B55BC: 00520030 01584911 00000000 000000e6 0.R..IX.........
681B55CC: 00020001 000000e6 00470001 00010003 ..........G.....
681B55DC: 00000001 00000002 00000002 00000000 ................
681B55EC: 00000000 00000000 00580000 0000005e ..........X.^...
681B55FC: 00000000 00000161 00000001 00000000 ....a...........
681B560C: 001b0000 00000000 00c00003 80e600d6 ................
681B561C: 00af03af 00000015 3400d008 00000000 ...........4....
681B562C: 00010008 00000000 0001004b 00000000 ........K.......
681B563C: 00af03af 0000002f 3400d008 00000000 ..../......4....
681B564C: 0016003f 00000000 0016096b 00000000 ?.......k.......
681B565C: 00340134 00050002 00000000 00000000 4.4.............
681B566C: 00450020 00000000 000102c1 00010000 .E.............
681B567C: 00700052 00520074 006e0075 00690074 R.p.t.R.u.n.t.i.
681B568C: 0065006d 00000031 002a87ab 3eb70000 m.e.1.....*....>
681B569C: 00010000 0004 ......
id = 22563089
status = 0
first = 0
indid = 2
root = 0
minlen = 71
keycnt = 3
groupid = 1
dpages = 1
reserved = 2
used = 2
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 88
maxirow = 94
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0
keys
--------------------------------
681B561C: 00af03af 00000015 3400d008 00000000 ...........4....
681B562C: 00010008 00000000 0001004b 00000000 ........K.......
681B563C: 00af03af 0000002f 3400d008 00000000 ..../......4....
681B564C: 0016003f 00000000 0016096b 00000000 ?.......k.......
681B565C: 00340134 00050002 00000000 00000000 4.4.............
681B566C: 00450020 00000000 000102c1 00010000 .E.............
name = RptRuntime1
statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182664757248 RowId = (1:16055:4)
Slot 4 Offset 0xc04
-------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B4C04: 00520030 0175b502 00004012 00000000 0.R...u..@......
681B4C14: 00010000 00000000 040c0000 00010001 ................
681B4C24: 00000000 00000000 00000000 00000000 ................
681B4C34: 00000000 00000000 04270000 00000022 ..........'."...
681B4C44: 00000000 00000000 00000000 00000000 ................
681B4C54: 001b0000 00000000 00800003 80a60096 ................
681B4C64: 00af03af 0000000a 3400d008 00000000 ...........4....
681B4C74: 0001004e 00000000 000103e6 00000000 N...............
681B4C84: 006f0057 006b0072 00650043 0074006e W.o.r.k.C.e.n.t.
681B4C94: 00720065 00000030 002a84b7 55880000 e.r.0.....*....U
681B4CA4: 00010000 0007 ......
id = 24491266
status = 16402
first = 0
indid = 1
root = 0
minlen = 1036
keycnt = 1
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 1063
maxirow = 34
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0
keys
--------------------------------
681B4C64: 00af03af 0000000a 3400d008 00000000 ...........4....
681B4C74: 0001004e 00000000 000103e6 00000000 N...............
name = WorkCenter0
statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182615212032 RowId = (1:21896:7)
Slot 5 Offset 0xb64
-------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B4B64: 00520030 01ab548a 00004012 00000000 0.R..T...@......
681B4B74: 00010000 00000000 038e0000 00010001 ................
681B4B84: 00000000 00000000 00000000 00000000 ................
681B4B94: 00000000 00000000 03b00000 0000001a ................
681B4BA4: 00000000 00000000 00000000 00000000 ................
681B4BB4: 001b0000 00000000 00800003 80a00090 ................
681B4BC4: 00af03af 00000002 3400d008 00000000 ...........4....
681B4BD4: 0001007b 00000000 000102bb 00000000 {...............
681B4BE4: 004f0053 00650053 00750074 00300070 S.O.S.e.t.u.p.0.
681B4BF4: 84010000 0000002a 00000f23 00070001 ....*...#.......
id = 28005514
status = 16402
first = 0
indid = 1
root = 0
minlen = 910
keycnt = 1
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 944
maxirow = 26
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0
keys
--------------------------------
681B4BC4: 00af03af 00000002 3400d008 00000000 ...........4....
681B4BD4: 0001007b 00000000 000102bb 00000000 {...............
name = SOSetup0
statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182603284480 RowId = (1:3875:7)
Slot 6 Offset 0x58c
-------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B458C: 00520030 01c4f563 00004012 00000000 0.R.c....@......
681B459C: 00010000 00000000 04c70000 00010002 ................
681B45AC: 00000000 00000000 00000000 00000000 ................
681B45BC: 00000000 00000000 04e80000 00000027 ............'...
681B45CC: 00000000 00000000 00000000 00000000 ................
681B45DC: 001b0000 00000000 00a00003 80c400b4 ................
681B45EC: 00af03af 0000000a 3400d008 00000000 ...........4....
681B45FC: 00010034 00000000 0001016e 00000000 4.......n.......
681B460C: 00af03af 00000005 3400d008 00000000 ...........4....
681B461C: 000b002a 00000000 000b0135 00000000 *.......5.......
681B462C: 00750050 004f0072 00640072 00650044 P.u.r.O.r.d.D.e.
681B463C: 00300074 82fd0000 0000002a 0000068a t.0.....*.......
681B464C: 00490001 ..I.
id = 29685091
status = 16402
first = 0
indid = 1
root = 0
minlen = 1223
keycnt = 2
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 1256
maxirow = 39
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0
keys
--------------------------------
681B45EC: 00af03af 0000000a 3400d008 00000000 ...........4....
681B45FC: 00010034 00000000 0001016e 00000000 4.......n.......
681B460C: 00af03af 00000005 3400d008 00000000 ...........4....
681B461C: 000b002a 00000000 000b0135 00000000 *.......5.......
name = PurOrdDet0
statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182586245120 RowId = (1:1674:73)
Slot 7 Offset 0x650
-------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B4650: 00520030 01c4f563 00000000 00000000 0.R.c...........
681B4660: 00020000 00000000 002e0000 00010003 ................
681B4670: 00000000 00000000 00000000 00000000 ................
681B4680: 00000000 00000000 003f0000 00000045 ..........?.E...
681B4690: 00000000 00000000 00000000 00000000 ................
681B46A0: 001b0000 00000000 00c00003 80e400d4 ................
681B46B0: 00af03af 0000001e 3400d008 00000000 ...........4....
681B46C0: 00010024 00000000 00010109 00000000 $...............
681B46D0: 00af03af 0000000a 3400d008 00000000 ...........4....
681B46E0: 001f0034 00000000 0001016e 00010000 4.......n.......
681B46F0: 00af03af 00000005 3400d008 00000000 ...........4....
681B4700: 0029002a 00000000 000b0135 00010000 *.).....5.......
681B4710: 00750050 004f0072 00640072 00650044 P.u.r.O.r.d.D.e.
681B4720: 00310074 83040000 0000002a 0000068a t.1.....*.......
681B4730: 004a0001 ..J.
id = 29685091
status = 0
first = 0
indid = 2
root = 0
minlen = 46
keycnt = 3
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 63
maxirow = 69
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0
keys
--------------------------------
681B46B0: 00af03af 0000001e 3400d008 00000000 ...........4....
681B46C0: 00010024 00000000 00010109 00000000 $...............
681B46D0: 00af03af 0000000a 3400d008 00000000 ...........4....
681B46E0: 001f0034 00000000 0001016e 00010000 4.......n.......
681B46F0: 00af03af 00000005 3400d008 00000000 ...........4....
681B4700: 0029002a 00000000 000b0135 00010000 *.).....5.......
name = PurOrdDet1
statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182586703872 RowId = (1:1674:74)
Slot 8 Offset 0x734
-------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B4734: 00520030 01c4f563 00000000 00000000 0.R.c...........
681B4744: 00030000 00000000 00340000 00010004 ..........4.....
681B4754: 00000000 00000000 00000000 00000000 ................
681B4764: 00000000 00000000 00450000 0000004b ..........E.K...
681B4774: 00000000 00000000 00000000 00000000 ................
681B4784: 001b0000 00000000 00e00003 810400f4 ................
681B4794: 00af03af 00000006 3400d008 00000000 ...........4....
681B47A4: 00010044 00000000 000101ea 00000000 D...............
681B47B4: 00af03af 0000001e 3400d008 00000000 ...........4....
681B47C4: 00070024 00000000 00070109 00000000 $...............
681B47D4: 00af03af 0000000a 3400d008 00000000 ...........4....
681B47E4: 00250034 00000000 0001016e 00010000 4.%.....n.......
681B47F4: 00af03af 00000005 3400d008 00000000 ...........4....
681B4804: 002f002a 00000000 000b0135 00010000 *./.....5.......
681B4814: 00750050 004f0072 00640072 00650044 P.u.r.O.r.d.D.e.
681B4824: 00320074 83050000 0000002a 0000068a t.2.....*.......
681B4834: 004b0001 ..K.
id = 29685091
status = 0
first = 0
indid = 3
root = 0
minlen = 52
keycnt = 4
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 69
maxirow = 75
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0
keys
--------------------------------
681B4794: 00af03af 00000006 3400d008 00000000 ...........4....
681B47A4: 00010044 00000000 000101ea 00000000 D...............
681B47B4: 00af03af 0000001e 3400d008 00000000 ...........4....
681B47C4: 00070024 00000000 00070109 00000000 $...............
681B47D4: 00af03af 0000000a 3400d008 00000000 ...........4....
681B47E4: 00250034 00000000 0001016e 00010000 4.%.....n.......
681B47F4: 00af03af 00000005 3400d008 00000000 ...........4....
681B4804: 002f002a 00000000 000b0135 00010000 *./.....5.......
name = PurOrdDet2
statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182586769408 RowId = (1:1674:75)
Slot 9 Offset 0x838
-------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B4838: 00520030 01c4f563 00000000 00000000 0.R.c...........
681B4848: 00040000 00000000 00120000 00010005 ................
681B4858: 00000000 00000000 00000000 00000000 ................
681B4868: 00000000 00000000 00230000 00000029 ..........#.)...
681B4878: 00000000 00000000 00000000 00000000 ................
681B4888: 001b0000 00000000 01000003 81240114 ..............$.
681B4898: 00af03af 0000000a 3400d008 00000000 ...........4....
681B48A8: 00010034 00000000 0001016e 00000000 4.......n.......
681B48B8: 00af03af 00000005 3400d008 00000000 ...........4....
681B48C8: 000b002a 00000000 000b0135 00000000 *.......5.......
681B48D8: 00340134 00050002 00000000 00000000 4.4.............
681B48E8: 00100029 00000000 00100133 00000000 ).......3.......
681B48F8: 00af03af 0000000a 3400d008 00000000 ...........4....
681B4908: 00010034 00000000 0001016e 00030000 4.......n.......
681B4918: 00af03af 00000005 3400d008 00000000 ...........4....
681B4928: 000b002a 00000000 000b0135 00030000 *.......5.......
681B4938: 00750050 004f0072 00640072 00650044 P.u.r.O.r.d.D.e.
681B4948: 00330074 83060000 0000002a 0000068a t.3.....*.......
681B4958: 004c0001 ..L.
id = 29685091
status = 0
first = 0
indid = 4
root = 0
minlen = 18
keycnt = 5
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 35
maxirow = 41
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0
keys
--------------------------------
681B4898: 00af03af 0000000a 3400d008 00000000 ...........4....
681B48A8: 00010034 00000000 0001016e 00000000 4.......n.......
681B48B8: 00af03af 00000005 3400d008 00000000 ...........4....
681B48C8: 000b002a 00000000 000b0135 00000000 *.......5.......
681B48D8: 00340134 00050002 00000000 00000000 4.4.............
681B48E8: 00100029 00000000 00100133 00000000 ).......3.......
681B48F8: 00af03af 0000000a 3400d008 00000000 ...........4....
681B4908: 00010034 00000000 0001016e 00030000 4.......n.......
681B4918: 00af03af 00000005 3400d008 00000000 ...........4....
681B4928: 000b002a 00000000 000b0135 00030000 *.......5.......
name = PurOrdDet3
statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182586834944 RowId = (1:1674:76)
Slot 10 Offset 0x95c
--------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B495C: 00520030 01c4f563 00000000 00000000 0.R.c...........
681B496C: 00050000 00000000 003a0000 00010005 ..........:.....
681B497C: 00000000 00000000 00000000 00000000 ................
681B498C: 00000000 00000000 004b0000 00000051 ..........K.Q...
681B499C: 00000000 00000000 00000000 00000000 ................
681B49AC: 001b0000 00000000 01000003 81240114 ..............$.
681B49BC: 00af03af 0000001e 3400d008 00000000 ...........4....
681B49CC: 00010024 00000000 00010109 00000000 $...............
681B49DC: 00af03af 0000000a 3400d008 00000000 ...........4....
681B49EC: 001f005e 00000000 001f032b 00000000 ^.......+.......
681B49FC: 00340134 00050002 00000000 00000000 4.4.............
681B4A0C: 0029002f 00000000 00290154 00000000 /.).....T.).....
681B4A1C: 00af03af 0000000a 3400d008 00000000 ...........4....
681B4A2C: 002b0034 00000000 0001016e 00010000 4.+.....n.......
681B4A3C: 00af03af 00000005 3400d008 00000000 ...........4....
681B4A4C: 0035002a 00000000 000b0135 00010000 *.5.....5.......
681B4A5C: 00750050 004f0072 00640072 00650044 P.u.r.O.r.d.D.e.
681B4A6C: 00340074 83070000 0000002a 0000068a t.4.....*.......
681B4A7C: 004d0001 ..M.
id = 29685091
status = 0
first = 0
indid = 5
root = 0
minlen = 58
keycnt = 5
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 75
maxirow = 81
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0
keys
--------------------------------
681B49BC: 00af03af 0000001e 3400d008 00000000 ...........4....
681B49CC: 00010024 00000000 00010109 00000000 $...............
681B49DC: 00af03af 0000000a 3400d008 00000000 ...........4....
681B49EC: 001f005e 00000000 001f032b 00000000 ^.......+.......
681B49FC: 00340134 00050002 00000000 00000000 4.4.............
681B4A0C: 0029002f 00000000 00290154 00000000 /.).....T.).....
681B4A1C: 00af03af 0000000a 3400d008 00000000 ...........4....
681B4A2C: 002b0034 00000000 0001016e 00010000 4.+.....n.......
681B4A3C: 00af03af 00000005 3400d008 00000000 ...........4....
681B4A4C: 0035002a 00000000 000b0135 00010000 *.5.....5.......
name = PurOrdDet4
statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182586900480 RowId = (1:1674:77)
Slot 11 Offset 0xa80
--------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B4A80: 00520030 01c4f563 00000000 00000000 0.R.c...........
681B4A90: 00060000 00000000 00200000 00010003 .......... .....
681B4AA0: 00000000 00000000 00000000 00000000 ................
681B4AB0: 00000000 00000000 00310000 00000037 ..........1.7...
681B4AC0: 00000000 00000000 00000000 00000000 ................
681B4AD0: 001b0000 00000000 00c00003 80e400d4 ................
681B4AE0: 00af03af 00000010 3400d008 00000000 ...........4....
681B4AF0: 00010036 00000000 0001017a 00000000 6.......z.......
681B4B00: 00af03af 0000000a 3400d008 00000000 ...........4....
681B4B10: 00110034 00000000 0001016e 00010000 4.......n.......
681B4B20: 00af03af 00000005 3400d008 00000000 ...........4....
681B4B30: 001b002a 00000000 000b0135 00010000 *.......5.......
681B4B40: 00750050 004f0072 00640072 00650044 P.u.r.O.r.d.D.e.
681B4B50: 00350074 83080000 0000002a 0000068a t.5.....*.......
681B4B60: 004e0001 ..N.
id = 29685091
status = 0
first = 0
indid = 6
root = 0
minlen = 32
keycnt = 3
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 49
maxirow = 55
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0
keys
--------------------------------
681B4AE0: 00af03af 00000010 3400d008 00000000 ...........4....
681B4AF0: 00010036 00000000 0001017a 00000000 6.......z.......
681B4B00: 00af03af 0000000a 3400d008 00000000 ...........4....
681B4B10: 00110034 00000000 0001016e 00010000 4.......n.......
681B4B20: 00af03af 00000005 3400d008 00000000 ...........4....
681B4B30: 001b002a 00000000 000b0135 00010000 *.......5.......
name = PurOrdDet5
statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182586966016 RowId = (1:1674:78)
Slot 12 Offset 0xcac
--------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B4CAC: 00520030 01c4f563 00000000 00000000 0.R.c...........
681B4CBC: 00070000 00000000 00110000 00010003 ................
681B4CCC: 00000000 00000000 00000000 00000000 ................
681B4CDC: 00000000 00000000 00220000 00000028 ..........".(...
681B4CEC: 00000000 00000000 00000000 00000000 ................
681B4CFC: 001b0000 00000000 00c00003 80ee00de ................
681B4D0C: 00af03af 00000001 3400d008 00000000 ...........4....
681B4D1C: 00010033 00000000 0001016d 00000000 3.......m.......
681B4D2C: 00af03af 0000000a 3400d008 00000000 ...........4....
681B4D3C: 00020034 00000000 0001016e 00010000 4.......n.......
681B4D4C: 00af03af 00000005 3400d008 00000000 ...........4....
681B4D5C: 000c002a 00000000 000b0135 00010000 *.......5.......
681B4D6C: 00750070 006f0072 00640072 00650064 p.u.r.o.r.d.d.e.
681B4D7C: 005f0074 00740073 00610072 0000006e t._.s.t.r.a.n...
681B4D8C: 002a84c7 78450000 00010000 001d ..*...Ex......
id = 29685091
status = 0
first = 0
indid = 7
root = 0
minlen = 17
keycnt = 3
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 34
maxirow = 40
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0
keys
--------------------------------
681B4D0C: 00af03af 00000001 3400d008 00000000 ...........4....
681B4D1C: 00010033 00000000 0001016d 00000000 3.......m.......
681B4D2C: 00af03af 0000000a 3400d008 00000000 ...........4....
681B4D3C: 00020034 00000000 0001016e 00010000 4.......n.......
681B4D4C: 00af03af 00000005 3400d008 00000000 ...........4....
681B4D5C: 000c002a 00000000 000b0135 00010000 *.......5.......
name = purorddet_stran
statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182616260608 RowId = (1:30789:29)
Slot 13 Offset 0xd4
-------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B40D4: 00520030 01d345b0 00004012 00000000 0.R..E...@......
681B40E4: 00010000 00000000 019b0000 00010006 ................
681B40F4: 00000000 00000000 00000000 00000000 ................
681B4104: 00000000 00000000 01b00000 0000007b ............{...
681B4114: 00000000 00000000 00000000 00000000 ................
681B4124: 001b0000 00000000 01200003 81460136 .......... .6.F.
681B4134: 00af03af 0000001e 3400d008 00000000 ...........4....
681B4144: 00010008 00000000 00010041 00000000 ........A.......
681B4154: 00af03af 00000004 3400d008 00000000 ...........4....
681B4164: 001f0007 00000000 001f003d 00000000 ........=.......
681B4174: 00af03af 0000001e 3400d008 00000000 ...........4....
681B4184: 00230010 00000000 00230084 00000000 ..#.......#.....
681B4194: 00af03af 00000001 3400d008 00000000 ...........4....
681B41A4: 00410006 00000000 0041003c 00000000 ..A.....<.A.....
681B41B4: 00af03af 00000004 3400d008 00000000 ...........4....
681B41C4: 00420004 00000000 0042001a 00000000 ..B.......B.....
681B41D4: 00af03af 0000001e 3400d008 00000000 ...........4....
681B41E4: 00460005 00000000 0046001e 00000000 ..F.......F.....
681B41F4: 0070004f 00440074 00700065 00780045 O.p.t.D.e.p.E.x.
681B4204: 006c0063 00000030 002a8221 4d150000 c.l.0...!.*....M
681B4214: 00010000 003f ....?.
id = 30623152
status = 16402
first = 0
indid = 1
root = 0
minlen = 411
keycnt = 6
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 432
maxirow = 123
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0
keys
--------------------------------
681B4134: 00af03af 0000001e 3400d008 00000000 ...........4....
681B4144: 00010008 00000000 00010041 00000000 ........A.......
681B4154: 00af03af 00000004 3400d008 00000000 ...........4....
681B4164: 001f0007 00000000 001f003d 00000000 ........=.......
681B4174: 00af03af 0000001e 3400d008 00000000 ...........4....
681B4184: 00230010 00000000 00230084 00000000 ..#.......#.....
681B4194: 00af03af 00000001 3400d008 00000000 ...........4....
681B41A4: 00410006 00000000 0041003c 00000000 ..A.....<.A.....
681B41B4: 00af03af 00000004 3400d008 00000000 ...........4....
681B41C4: 00420004 00000000 0042001a 00000000 ..B.......B.....
681B41D4: 00af03af 0000001e 3400d008 00000000 ...........4....
681B41E4: 00460005 00000000 0046001e 00000000 ..F.......F.....
name = OptDepExcl0
statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182571827200 RowId = (1:19733:63)
Slot 14 Offset 0x21c
--------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B421C: 00520030 01d345b0 00000000 00000000 0.R..E..........
681B422C: 00020000 00000000 00640000 00010008 ..........d.....
681B423C: 00000000 00000000 00000000 00000000 ................
681B424C: 00000000 00000000 00750000 0000007b ..........u.{...
681B425C: 00000000 00000000 00000000 00000000 ................
681B426C: 001b0000 00000000 01600003 81860176 ..........`.v...
681B427C: 00af03af 0000001e 3400d008 00000000 ...........4....
681B428C: 00010005 00000000 0001001e 00000000 ................
681B429C: 00af03af 00000004 3400d008 00000000 ...........4....
681B42AC: 001f0004 00000000 001f001a 00000000 ................
681B42BC: 00af03af 0000001e 3400d008 00000000 ...........4....
681B42CC: 00230008 00000000 00010041 00010000 ..#.....A.......
681B42DC: 00af03af 00000004 3400d008 00000000 ...........4....
681B42EC: 00410007 00000000 001f003d 00010000 ..A.....=.......
681B42FC: 00af03af 0000001e 3400d008 00000000 ...........4....
681B430C: 00450010 00000000 00230084 00010000 ..E.......#.....
681B431C: 00af03af 00000001 3400d008 00000000 ...........4....
681B432C: 00630006 00000000 0041003c 00010000 ..c.....<.A.....
681B433C: 00af03af 00000004 3400d008 00000000 ...........4....
681B434C: 001f0004 00000000 0042001a 00030000 ..........B.....
681B435C: 00af03af 0000001e 3400d008 00000000 ...........4....
681B436C: 00010005 00000000 0046001e 00030000 ..........F.....
681B437C: 0070004f 00440074 00700065 00780045 O.p.t.D.e.p.E.x.
681B438C: 006c0063 00000031 002a8224 4d150000 c.l.1...$.*....M
681B439C: 00010000 0040 ....@.
id = 30623152
status = 0
first = 0
indid = 2
root = 0
minlen = 100
keycnt = 8
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 117
maxirow = 123
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0
keys
--------------------------------
681B427C: 00af03af 0000001e 3400d008 00000000 ...........4....
681B428C: 00010005 00000000 0001001e 00000000 ................
681B429C: 00af03af 00000004 3400d008 00000000 ...........4....
681B42AC: 001f0004 00000000 001f001a 00000000 ................
681B42BC: 00af03af 0000001e 3400d008 00000000 ...........4....
681B42CC: 00230008 00000000 00010041 00010000 ..#.....A.......
681B42DC: 00af03af 00000004 3400d008 00000000 ...........4....
681B42EC: 00410007 00000000 001f003d 00010000 ..A.....=.......
681B42FC: 00af03af 0000001e 3400d008 00000000 ...........4....
681B430C: 00450010 00000000 00230084 00010000 ..E.......#.....
681B431C: 00af03af 00000001 3400d008 00000000 ...........4....
681B432C: 00630006 00000000 0041003c 00010000 ..c.....<.A.....
681B433C: 00af03af 00000004 3400d008 00000000 ...........4....
681B434C: 001f0004 00000000 0042001a 00030000 ..........B.....
681B435C: 00af03af 0000001e 3400d008 00000000 ...........4....
681B436C: 00010005 00000000 0046001e 00030000 ..........F.....
name = OptDepExcl1
statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182572023808 RowId = (1:19733:64)
Slot 15 Offset 0x3a4
--------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B43A4: 00520030 01d345b0 00000000 00000000 0.R..E..........
681B43B4: 00030000 00000000 00660000 0001000b ..........f.....
681B43C4: 00000000 00000000 00000000 00000000 ................
681B43D4: 00000000 00000000 00770000 0000007d ..........w.}...
681B43E4: 00000000 00000000 00000000 00000000 ................
681B43F4: 001b0000 00000000 01c00003 81e601d6 ................
681B4404: 00af03af 0000001e 3400d008 00000000 ...........4....
681B4414: 00010008 00000000 00010041 00000000 ........A.......
681B4424: 00af03af 00000004 3400d008 00000000 ...........4....
681B4434: 001f0007 00000000 001f003d 00000000 ........=.......
681B4444: 00af03af 0000001e 3400d008 00000000 ...........4....
681B4454: 00230010 00000000 00230084 00000000 ..#.......#.....
681B4464: 00af03af 00000001 3400d008 00000000 ...........4....
681B4474: 00410006 00000000 0041003c 00000000 ..A.....<.A.....
681B4484: 00340134 00050002 00000000 00000000 4.4.............
681B4494: 0042000a 00000000 00420063 00000000 ..B.....c.B.....
681B44A4: 00af03af 0000001e 3400d008 00000000 ...........4....
681B44B4: 00010008 00000000 00010041 00030000 ........A.......
681B44C4: 00af03af 00000004 3400d008 00000000 ...........4....
681B44D4: 001f0007 00000000 001f003d 00030000 ........=.......
681B44E4: 00af03af 0000001e 3400d008 00000000 ...........4....
681B44F4: 00230010 00000000 00230084 00030000 ..#.......#.....
681B4504: 00af03af 00000001 3400d008 00000000 ...........4....
681B4514: 00410006 00000000 0041003c 00030000 ..A.....<.A.....
681B4524: 00af03af 00000004 3400d008 00000000 ...........4....
681B4534: 00440004 00000000 0042001a 00010000 ..D.......B.....
681B4544: 00af03af 0000001e 3400d008 00000000 ...........4....
681B4554: 00480005 00000000 0046001e 00010000 ..H.......F.....
681B4564: 0070004f 00440074 00700065 00780045 O.p.t.D.e.p.E.x.
681B4574: 006c0063 00000032 002a8225 4d150000 c.l.2...%.*....M
681B4584: 00010000 0041 ....A.
id = 30623152
status = 0
first = 0
indid = 3
root = 0
minlen = 102
keycnt = 11
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 119
maxirow = 125
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0
keys
--------------------------------
681B4404: 00af03af 0000001e 3400d008 00000000 ...........4....
681B4414: 00010008 00000000 00010041 00000000 ........A.......
681B4424: 00af03af 00000004 3400d008 00000000 ...........4....
681B4434: 001f0007 00000000 001f003d 00000000 ........=.......
681B4444: 00af03af 0000001e 3400d008 00000000 ...........4....
681B4454: 00230010 00000000 00230084 00000000 ..#.......#.....
681B4464: 00af03af 00000001 3400d008 00000000 ...........4....
681B4474: 00410006 00000000 0041003c 00000000 ..A.....<.A.....
681B4484: 00340134 00050002 00000000 00000000 4.4.............
681B4494: 0042000a 00000000 00420063 00000000 ..B.....c.B.....
681B44A4: 00af03af 0000001e 3400d008 00000000 ...........4....
681B44B4: 00010008 00000000 00010041 00030000 ........A.......
681B44C4: 00af03af 00000004 3400d008 00000000 ...........4....
681B44D4: 001f0007 00000000 001f003d 00030000 ........=.......
681B44E4: 00af03af 0000001e 3400d008 00000000 ...........4....
681B44F4: 00230010 00000000 00230084 00030000 ..#.......#.....
681B4504: 00af03af 00000001 3400d008 00000000 ...........4....
681B4514: 00410006 00000000 0041003c 00030000 ..A.....<.A.....
681B4524: 00af03af 00000004 3400d008 00000000 ...........4....
681B4534: 00440004 00000000 0042001a 00010000 ..D.......B.....
681B4544: 00af03af 0000001e 3400d008 00000000 ...........4....
681B4554: 00480005 00000000 0046001e 00010000 ..H.......F.....
name = OptDepExcl2
statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182572089344 RowId = (1:19733:65)
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Now, the bad news. I am a bit of a novice and have picked this up from someone who left my company. It appears the latch error has been around for some time and only reared up when I instituted a new back up system that runs a dbcc check befor backing up. I don't think I have any clean backups.
Any help would be greatly appreciated.
Alex Mauer
I have a customer who has reported some database corruption. The output of
DBCC CHECKDB ('CheckDB') is as follows:
Server: Msg 8935, Level 16, State 1, Line 1
Table error: Object ID 1685581043, index ID 1. The previous link (1:76577)
on page (1:76578) does not match the previous page (1:253212) that the parent
(1:64277), slot 165 expects for this page.
Server: Msg 8936, Level 16, State 1, Line 1
Table error: Object ID 1685581043, index ID 1. B-tree chain linkage
mismatch. (1:253212)->next = (1:76578), but (1:76578)->Prev = (1:76577).
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 1685581043, index ID 1. The high key value on page
(1:253212) (level 0) is not less than the low key value in the parent (0:1),
slot 0 of the next page (1:76578).
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 1685581043, index ID 1. Page (1:253212) is missing a
reference from previous page (1:76577). Possible chain linkage problem.
CHECKDB found 0 allocation errors and 4 consistency errors in table
'Student' (object ID 1685581043).
CHECKDB found 0 allocation errors and 4 consistency errors in database
'CheckDB'.
repair_rebuild is the minimum repair level for the errors found by DBCC
CHECKDB (LincsDB ).
(1 row(s) affected)
Attempting a DBCC CHECKDB ('CheckDB', REPAIR_REBUILD) yields the following
results:
Server: Msg 1505, Level 16, State 1, Line 1
CREATE UNIQUE INDEX terminated because a duplicate key was found for index
ID 2. Most significant primary key is '312037'.
Server: Msg 8935, Level 16, State 1, Line 1
Table error: Object ID 1685581043, index ID 1. The previous link (1:76577)
on page (1:76578) does not match the previous page (1:253212) that the parent
(1:64277), slot 165 expects for this page.
Server: Msg 8936, Level 16, State 1, Line 1
Table error: Object ID 1685581043, index ID 1. B-tree chain linkage
mismatch. (1:253212)->next = (1:76578), but (1:76578)->Prev = (1:76577).
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 1685581043, index ID 1. The high key value on page
(1:253212) (level 0) is not less than the low key value in the parent (0:1),
slot 0 of the next page (1:76578).
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 1685581043, index ID 1. Page (1:253212) is missing a
reference from previous page (1:76577). Possible chain linkage problem.
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.
CHECKDB found 0 allocation errors and 4 consistency errors in table
'Student' (object ID 1685581043).
CHECKDB found 0 allocation errors and 4 consistency errors in database
'LincsDB'.
repair_rebuild is the minimum repair level for the errors found by DBCC
CHECKDB (LincsDB repair_rebuild).
The statement has been terminated.
(1 row(s) affected)
I can resolve the issue by dropping and recreating index id: 2 but this
involves dropping and re-creating a lot or related constraints (this is a
primary key).
Can anyone give me any pointers as to why this corruption may have occurred
or more information about the kind of corruption? I have not seen this on any
other customer databases so I don't think it is an application error? Also,
any suggestions on a better (simpler) way to correct this problem?
Unfortunatley, the customers last viable backup is a couple of weeks out of
date and they are reluctant to restore and re-enter all the new data again.
Any help greatly appreciated,
Dave.
DBCC results for 'DocCollections'.
DBCC results for 'sysobjects'.
There are 116 rows in 4 pages for object 'sysobjects'.
DBCC results for 'sysindexes'.
There are 148 rows in 7 pages for object 'sysindexes'.
DBCC results for 'syscolumns'.
There are 666 rows in 12 pages for object 'syscolumns'.
DBCC results for 'systypes'.
There are 26 rows in 1 pages for object 'systypes'.
DBCC results for 'syscomments'.
There are 157 rows in 15 pages for object 'syscomments'.
DBCC results for 'sysfiles1'.
There are 2 rows in 1 pages for object 'sysfiles1'.
DBCC results for 'syspermissions'.
There are 104 rows in 1 pages for object 'syspermissions'.
DBCC results for 'sysusers'.
There are 108 rows in 2 pages for object 'sysusers'.
DBCC results for 'sysproperties'.
There are 1702 rows in 26 pages for object 'sysproperties'.
DBCC results for 'sysdepends'.
There are 474 rows in 3 pages for object 'sysdepends'.
DBCC results for 'sysreferences'.
There are 2 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 'tblCommentsArchive'.
There are 64678 rows in 395 pages for object 'tblCommentsArchive'.
DBCC results for 'tblLoanConditionsDeleted'.
There are 0 rows in 0 pages for object 'tblLoanConditionsDeleted'.
DBCC results for 'dtproperties'.
There are 7 rows in 1 pages for object 'dtproperties'.
DBCC results for 'LoanInfoFix'.
There are 52421 rows in 166 pages for object 'LoanInfoFix'.
DBCC results for 'tblLoanConditionsFIX'.
There are 392167 rows in 2099 pages for object 'tblLoanConditionsFIX'.
DBCC results for 'tblLoanConditions'.
There are 743281 rows in 6004 pages for object 'tblLoanConditions'.
DBCC results for 'Conditions'.
There are 144 rows in 2 pages for object 'Conditions'.
DBCC results for 'REGIONS'.
There are 51 rows in 1 pages for object 'REGIONS'.
DBCC results for 'RegionsPhil'.
There are 53 rows in 1 pages for object 'RegionsPhil'.
DBCC results for 'DLQ'.
There are 13569 rows in 34 pages for object 'DLQ'.
DBCC results for 'CountyList'.
Server: Msg 2511, Level 16, State 2, Line 1
Table error: Object ID 2073058421, Index ID 0. Keys out of order on page (1:10386), slots 17 and 18.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 2073058421, index ID 1. Page (1:759) is missing a reference from previous page (1:10386). Possible chain linkage problem.
Server: Msg 8935, Level 16, State 1, Line 1
Table error: Object ID 2073058421, index ID 1. The previous link (1:10386) on page (1:10387) does not match the previous page (1:759) that the parent (1:10326), slot 81 expects for this page.
Server: Msg 8936, Level 16, State 1, Line 1
Table error: Object ID 2073058421, index ID 1. B-tree chain linkage mismatch. (1:759)->next = (1:10387), but (1:10387)->Prev = (1:10386).
There are 3022 rows in 13 pages for object 'CountyList'.
DBCC results for 'ContactPreference'.
There are 4 rows in 1 pages for object 'ContactPreference'.
DBCC results for 'Broker'.
There are 21614 rows in 334 pages for object 'Broker'.
DBCC results for 'Conversion Errors'.
There are 2 rows in 1 pages for object 'Conversion Errors'.
DBCC results for 'LoanInfo'.
There are 271755 rows in 8970 pages for object 'LoanInfo'.
CHECKDB found 0 allocation errors and 4 consistency errors in table 'LoanInfo' (object ID 2073058421).
DBCC results for 'SettlementAgent'.
There are 285013 rows in 4143 pages for object 'SettlementAgent'.
DBCC results for 'statelist'.
There are 51 rows in 1 pages for object 'statelist'.
CHECKDB found 0 allocation errors and 4 consistency errors in database 'DocCollections'.
repair_rebuild is the minimum repair level for the errors found by DBCC CHECKDB (DocCollections ).
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
I'm running MS SQL 2000 sp3 under 2000 server sp4. I lost a hard drive in a RAID5 and afterwords my weekly maintenance (rebuild and check links) errored five days later. I'm on a weekly backup cycle and running Great Pains Dynamics 6.0. Can't go back now.
Here's what dbcc checkdb found on my 5 gig db.
DBCC results for 'UPR41400'.
There are 5 rows in 1 pages for object 'UPR41400'.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 171147655, index ID 0: Page (1:192881) could not be processed. See other errors for details.
Server: Msg 8944, Level 16, State 1, Line 1
Table error: Object ID 171147655, index ID 0, page (1:192881), row 56. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 4203 and 111.
I'm keeping a warm backup server up to date so I can run whatever you suggest on it without harming my production db further. I'm monitoring the db daily and after seeing some other posts, I realize i'm very lucky this is the only error. At the end of the messages it informs me that 'repair_with_allow_data_loss' is my first option. The strange thing is I can return all rows on the table without error. It's a tax table.
Do I have any other options?
Thanks
Hi there:
My database has DBCC errors and I am trying to find out the ways to solve it. Any help from you will be highly apprecitated. The error says:
Table Corrupt: Object ID 909325622, index ID 6, page ID (1:864966). The PageId in the page header = (12336:1599554370).Server: Msg 2535, Level 16, State 1, Line 1
Table Corrupt: Page (1:864987) is allocated to object ID 61243273, index ID 3, not to object ID 909390389, index ID 19712 found in page header.
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.
Thanking you,
Eva
Hi, I'm new to SQL 6.5 and am having trouble with a scheduled backup. The job runs three dbccs: checkdb, checkcatalog and newalloc before running the backup (if clean). However the newalloc gives errors and thus my backup does not run - how do I fix this or can I ignore it?
The error reads:
Processed 85 entries in the Sysindexes for dbid 7.
Found 18 bad entries in the Sysindexes.
DBCC execution completed. If DBCC printed error messages, see your System Administrator.
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?
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]
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
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).
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
Hi,When I use dbcc shrinkfile to shrink LOG file, following error occurs:DBCC SHRINKFILE(2)---------------------------------------------------------------------------------------Cannot shrink log file 2 (myDB_log) because all logical log files are inuse.(1 row(s) affected)I have only one transaction log file in my Database, who can tell me what'tthe matter?If my current log file is in use, how can I find who is using it and stopusing then do the shrink operation?Thanks.Scarab
View 5 Replies View Related
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
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
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.
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
I'm in the process of trying to cutover SLQ 2000 database activity to a newer used server running Windows 2003. All the latest Win & SQL Service Packs through late Feb 2007 have been installed. The server has a Promise Fast Track S150 TX2plus SCSI raid with 2 80 gb drives. I have been using at as database development system for 3 months without any issues.
This morning I restored the latest full backup and 2 intervening transaction log backups. I am the only user on the system today. I ran DBDCC CHECKDB WITH TABLERESULTS 5 times over a 45 minute period and received 5 different results!
Run 1 - No Error
Run 2 - Following Errors:
2511162Table error: Object ID 754101727, Index ID 0. Keys out of order on page (1:631938), slots 40 and 41.repair_rebuild
8990101CHECKDB found 0 allocation errors and 1 consistency errors in table 'DatabaseEventLog' (object ID 754101727).
8928161Object ID 1218103380, index ID 255: Page (1:373888) could not be processed. See other errors for details.repair_allow_data_loss
8990101CHECKDB found 0 allocation errors and 1 consistency errors in table 'WeatherTransaction' (object ID 1218103380).
Run 3 - Following Errors:
2511162Table error: Object ID 754101727, Index ID 0. Keys out of order on page (1:631938), slots 40 and 41.repair_rebuild
8990101CHECKDB found 0 allocation errors and 1 consistency errors in table 'DatabaseEventLog' (object ID 754101727).
8928161Object ID 1218103380, index ID 255: Page (1:373888) could not be processed. See other errors for details.repair_allow_data_loss
8990101CHECKDB found 0 allocation errors and 1 consistency errors in table 'WeatherTransaction' (object ID 1218103380).
Run 4 - Following Errors:
2511162Table error: Object ID 754101727, Index ID 0. Keys out of order on page (1:631938), slots 40 and 41.repair_rebuild
8990101CHECKDB found 0 allocation errors and 1 consistency errors in table 'DatabaseEventLog' (object ID 754101727).
8928161Object ID 1218103380, index ID 255: Page (1:373888) could not be processed. See other errors for details.repair_allow_data_loss
894116102Table error: Object ID 1218103380, index ID 255, page (1:373888). Test (sorted [i].offset >= PAGEHEADSIZE) failed. Slot 8, offset 0x2 is invalid.repair_allow_data_loss
894216101Table error: Object ID 1218103380, index ID 255, page (1:373888). Test (sorted[i].offset >= max) failed. Slot 0, offset 0x8 overlaps with the prior row.repair_allow_data_loss
8990101CHECKDB found 0 allocation errors and 3 consistency errors in table 'WeatherTransaction' (object ID 1218103380).
Run 5 - No Error!
I ran several of the obligatory CHKDSK and had no errors:
c:>chkdsk
The type of the file system is NTFS.
WARNING! F parameter not specified.
Running CHKDSK in read-only mode.
CHKDSK is verifying files (stage 1 of 3)...
File verification completed.
CHKDSK is verifying indexes (stage 2 of 3)...
Index verification completed.
CHKDSK is verifying security descriptors (stage 3 of 3)...
Security descriptor verification completed.
78116030 KB total disk space.
45291176 KB in 33231 files.
10496 KB in 3135 indexes.
0 KB in bad sectors.
121086 KB in use by the system.
65536 KB occupied by the log file.
32693272 KB available on disk.
4096 bytes in each allocation unit.
19529007 total allocation units on disk.
8173318 allocation units available on disk.
Are these DBDCC CHECKDB WTIH TABLERESULTS differences normal or is this a bug or hardware issue? Any advice you can offer would be appreciated.
Thanks! Brad
Hey all -We are running SQL 2000 with ALL available service packs, etc.applied. We just built a brand new database server, which has dual2Ghz XEONs, 2GB memory, and the following disk configuration:RAID 1 array (2 disks) Operating System Windows Server 2003RAID 1 array (2 disks) Database LogsRAID 10 array (4 disks) Database DataDisks are SATA, with a 3Ware hardware RAID controller. The machineSCREAMS.We run 5 databases on this machine. 2 of these are fairly large (byour standards, anyway). The second largest database (and the busiestand most important) is consistently generating consistency errors thatbring many important queries down. These are almost ALWAYS in theform of index corruption on one single table. The corruption does notnormally occur on other tables, although it DOES happen once in awhile - rarely - on one of the other tables), nor does it EVER occuron any other databases on the server.The corruption seems to happen right in the neighborhood of midnightALMOST every day, give or take a few minutes, but does not seemdirectly associated with any of our MANY scheduled database cleanuptasks (believe me, we've tried desperately to find an associationusing SQL profiler). At midnight, our database traffic is fairly low,so it does not seem associated with a high traffic level.We are using the FULL recovery model, with log backups every 15minutes, and full backups daily at 12:15am. However, the corruptionhappens consistently BEFORE 12:15, like between 11:50pm and 12:10am.The most frustrating thing is, the database can go WEEKS without anycorruption at all, and then it'll go 4 or 5 days in a row with thisstrange corruption stuff.************************************************** ***********************Typical query errors when the corruption exists include:************************************************** ***********************SQL Server Assertion: File:<p:sqltdbmsstorengdrsinclude
ecord.inl>, line=1447Failed Assertion = 'm_SizeRec > 0 && m_SizeRec <= MAXDATAROW'.SQL Server Assertion: File: <recbase.cpp>, line=1378Failed Assertion = 'm_offBeginVar < m_SizeRec'.Server: Msg 3624, Level 20, State 1, Line 7Location: recbase.cpp:1374Expression: m_nVars > 0Connection Broken************************************************** ***********************Most of the responses to this type of issue (failed assertions) on thenewgroups appear to point to hardware failures. However, this isbrand new hardware, AND, it seems to us that if this was a hardwareissue, other databases, tables, and indexes would be affectedrandomly. Isn't that a valid assumption (that if it was hardware,particularly the RAID controller, the corruption would not be in sucha predictable place)? What if we moved the physical database files toanother location on the disk? Would/could that help?If anyone could offer some suggestions as to what may be causing thiscorruption, we would be eternally grateful. It is getting to be areal pain in the A*** to run DBCC CHECKDB with REPAIR_ALLOW_DATA_LOSSevery day or two (it always seems to solve the problem without dataloss, but still...).Again, thanks in advance for your response.Sincerely,Morgan LeppinkJoin Bytes!
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
Hi There
This is on Sql Server 2000, SP3.
When i run DBCC CHECKDB i get the following errors:
============================================================================================
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 2, index ID 255: Page (1:76914) could not be processed. See other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 2, index ID 255, page (1:76914). Test (IS_ON (BUF_IOERR, bp->bstat) && bp->berrcode) failed. Values are 2057 and -1.
CHECKDB found 0 allocation errors and 2 consistency errors in table 'sysindexes' (object ID 2).
CHECKDB found 0 allocation errors and 2 consistency errors in database 'OLTP3PRO'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (OLTP3PRO ).
============================================================================================
The database is not suspect and everything seems to be working fine, so after hours i run the follwing:
DBCC CHECKDB('OLTP3PRO', REPAIR_ALLOW_DATA_LOSS)
But i get the same errors?
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 2, index ID 255: Page (1:76914) could not be processed. See other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 2, index ID 255, page (1:76914). Test (IS_ON (BUF_IOERR, bp->bstat) && bp->berrcode) failed. Values are 2057 and -1.
Table error, The text, ntext or image node at page (1:76914), slot 0, text ID 2129023023802 is referenced by page (1:3859) but was not seen in the scan.
The repair level on the DBCC statement caused this repair to be bypassed.
CHECKDB found 4 found 4 consistancy errors.
So it seems CHECKDB with repair does not help ? How do i fix this ?
Thanx
Hi,
we''re currently performing a dry run of migrating some large (100GB+) SQL Server 2000 databases from a SQL 2000 cluster onto a new 2005 mirrorred database pair. The new configuration has completely separate database servers and a new dedicated SAN.
Upon restoring our largest database we are seeing the following errors recorded in the log after setting up mirroring and then trying to run DBCC CHECKDB:
"Unable to read and latch page (1:1323852) with latch type SH. 21(The device is not ready.) failed."
We are currently investigating the SAN hardware logs to determine if this might be a physical issue as it would seem to indicate, however has anyone any experience of this or insight into what may cause this error?
Thanks in advance!
Hi everybody,
I have a very strange problem. I have installed MS WS2003 SP2 and MS SQL 9.0.3054 SP2.
I have database dbTraceIT with data file on D drive and log file on E drive. If I run T-SQL command:
use dbTraceIT
go
dbcc checkdb
or Integration Services Package (task: Check Database Integrity Task, developed with MS VS)
this comand/or task has generated the hard disk errors on D drive. The chkdsk tool reports errors when hdd index verification has been completed. After hdd errors€™ repairing, if I run checkdb T-sql command the situation is repeated again.
Question: is it a bug or something different? Do you have similar disk error if you use e.g. Integration Service Packages (for instance index rebuild or whatever)?
Regards,
Dariusz
PS
Steps to reproduce
Find any DB on your MS SQL. Run chkdsk command on hard drive where DB€™s data file is stored. Verify that everything is OK.
Run t-sql command
use dbTraceIT
go
dbcc checkdb
3. Run chkdsk again. It should show hdd errors.
Hi,
I have a doubt.....
I have a text field that is 255 bytes in lenght and I want the contents of this full field to be split.....on various gouds which may be ',' or and or 'And' etc
This field stores all the skills...
So i have created a search module ....but this search is taking awfully long as u know text field searches are tedious...
Can u please suggest a way I could parse/split the text field to enable faster search....
Newbie
Hi
I am setting up a site in win XP professional and I am getting problem connecting to a local sql server 2000 installation (developer version)
The problem is that if i specify objects in my select query without an owner name, it can't recognize the object. I need to be able to do this.
Any one know how to fix this? is this a sql server setting??
Thank you.
James
is it possible to restore only from .mdf file in sql 200. if so how?
Thanks in advance
I have a scenario like this.......update esan set tes_address_city = 'TEST1' --at some timeupdate esan set tes_address_city = 'TEST12' --at some timeupdate esan set tes_address_city = 'TEST123' --at some timebackup database TESTWMS to disk = 'D: empRecoveryTestTESTWMS.db'backup log TESTWMS to disk = 'D: empRecoveryTestTESTWMS01.log'I take these backups at the end of day....Now i want to recover till the second update ie 'TEST12'...Assumptions to be made:-I dont know the timing of the updates.I am allowed to take back only once.We can also assume to have a backup of the previous day also.Is this possible and how can i do it.......Please help me ...and urgent also.......Thanks in advanceRVG
View 1 Replies View RelatedI am not a DBA but have responsibility for a particular MSSQL 2008 R2 file server running a particular application.how to solve a database consistency check problem.The database fails dbcc checkdb with multiple 8903 errors. Unfortunately this was not discovered until well after any good backups were deleted. The good news is that the DB otherwise seems fine. We have experienced zero problems with the DB or the applications. Running the checkdb with the "repair_allow_data_loss" option does not fix the problem.
However, I would still like to fix the problem. Using a popular SQL recovery product I am able to recover the database.The original, vendor designed and supplied DB, has 2 file groups, and three files (MDF, NDF, LDF). The output of the recovery process produces 1 file group and 2 files (MDF and LDF). Vendor says they cannot support me since the recovered DB is 'non-standard' according to their design.
I am able to set up a new, blank version of the vendors database on another dev system with the proper file and filegroup structure. How can I get the data moved/copied from the recovered (MDF/LDF) database into the dev database (MDF, NDF, LDF). I've tried the import/export function but it fails (I can rerun and give details if necessary).
I am looking for the best way to get notifications if DBCC CHECKDB indicates an error on a database it checks. So lets say I create a maintenance plan that runs CHECKDB at 2AM for all user databases. What is the best method to get notifications that the command reported issues on one of the databases?
View 7 Replies View RelatedHi ...
There is a strange problem on my tables . When i execute a simple query from Query Analyzer, say select * from ' table name' , then i can edit or enter text in my result in one of the columns.
But the same table if i try to open through the Enterprise problem , i.e selecting the table , right click and select open table and then if i select return all rows , it does not allow me to enter text in a specific coloumn .
But the same is possible if i execute a query and try to enter text in the results which is displayed in grid from the Query Analyser .
Could anybody help me to know what could be the problem and how can i enter a text it ?
Many Thanks !!
Hi Friends ,
I need your help and advice on copying databases from SQL Server 6.5 to SQL Server 7.0 and SQL 2000 . How can i do it ? Can it be done through Enterprise manager or is there a script available on any site or if someone can provide me .
I want to copy all the objects, indexes and logins with Passwords from SQL 6.5 to SQL 7.0 and SQL 2000 .
Since i am not well versed with database transfer activities , Can somebody help me please !!
Many thanks and best Regards,
Sneha
I am trying to do mearge replication with in our organisation. One server is located at server room(version 7.0) and it runs on NT server. Another server(desktop edition (version 7.0)) is at my desktop runs on NT Workstation. I am creating mearge replication from my machine making server room machine as Publisher and distributor and my desktop server as subscriber. But after creating replication when i view mearge agent job status it says that connection to my machine is failed. And because of this my replication is not working.
on both the servers "SQL Server Agent" service is running and i am also logging into both the servers with the same login with sa server role
I am getting following error in the "error details merge agent" dialog box
catagory -------------source -------------------------Number
Agent-------- "subscription server name" --------------20084
Data Source ---"subscription server name"-------------- 6
please help me if any one has solution
thanks in advance
Minesh
HI,
We have one publisher and 100 subscribers. And Subscribers again act as re-publisher for 3-4 win CE (Handheld) based device subscribers. Now. We have already done the setup and it is working fine.
Now due to some change in horizontal filters set in the publisher, we have change in publication. NOw whenever I make any change in publication, it says all subscribers will be marked for reinitialization and snapshot agent will run and new schema will be applied whenever next time merge agent runs.
But whenever I run the merge agent, the snapshot agent fails saying invalid column ... . I am not able to revert the changes as the same error persists even after bringing the publication back to the original state.
To add to the complexity, we have also used dynamic snapshots between publisher and suscribers.
So, Can anyone please tell me how can I change the publication script without deleting the subscribers?Any pointers in this direction are really appreciated.
Regards
Rahul