DBCC CHECKDB was affecting performance. Screens were hanging, timeouts, etc.
So I made the unfortunate decision of Killing the 2 processes.
I keep checking the percent complete and they are stuck at 33% and 17%.
Will I have to restart the SQL Server Service?
Are they any other options?
Every night all our DBCC CHECKDB runs on all our databases. The trouble is one of them is very large and the database is inaccessible whilst this runs. DBCC CHECKDB (dbname) WITH physical_only executed by user found 0 errors and repaired 0 errors. Elapsed time: 0 hours 24 minutes 46 seconds
This normally happens fairly shortly after the backup, and normally (but not always) after a series of these entries in the log.SQL Server has encountered 7976 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [D:Program FilesMicrosoft SQL ServerMSSQL11. MSSQLSERVERMSSQ LDATA empdb.mdf] in database [tempdb] (2).Would this cause SQL to automatically run a CheckDB.
I would like to know if it is possible to date stamp the output file for the DBCC integrity check?
The following cmd works fine however I tried different ways to date stamp the output file with no luck.
sqlcmd -U backup -P Password -S Server -Q"DBCC CHECKDB('DatabaseName') WITH ALL_ERRORMSGS" -o"G:LOGSDBCCResults.txt"
For Backup Database i used script
BACKUP DATABSE.
Then after that, i need to check Database inigrity, for that
i used DBCC CHECKDB and DBCC CHECKCATALOG
but, i want to store the result in a text file, after executing these two commends, how to write commend line please help me.
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 few extremely large databases in SQL Server 6.5 sp3
(soon to be 5a - but we won't talk about that!!) NT 4.0 sp4
(about 10 GIG each). I don't have a big window of down-time
in order to do any maintenance. Does anyone know of a way to
be able to run dbcc checkdb or other dbcc's that I can run to
verify the database yet complete within a reasonable amount
of time? The last time dbcc checkdb was run, it was started
Friday night and still not complete Sunday night.
Over a weekend, I may have up to a 24 hour maintenance window.
Any suggestions would be appreciated.
Thanks!
Toni
Hai ,
When I ran DBCC CHECK DB of userdatabase, its reporting along with usual messages as
Descriptor for system table '8' in database '8' not found in the descriptor hash table.
I could'nt understand being familiar error encounterd .
Any one will appreciate for the help
Thank you
Hello All,
I recently took over a SQL server with 300 MB of data. I am relatively new to SQL 6.5 and have been reading that DBCC checkdb and checkalloc should be run at least once per week. Apparently the person before me never ran any of those checks. Is not running the database consistency checks for so long going to present a problem? has anyone run into problems when running those checks? Any advise is greatly appreciated.
Pauli
I ran "dbcc checkdb(MCMSdb) with no_infomsgs" and I get the following:
Server: Msg 8946, Level 16, State 12, Line 2
Table error: Allocation page (1:274992) has invalid PFS_PAGE page header values. Type is 0. Check type, object ID and page ID on the page.
What cane be done to correct this problem?
Can this error prevent a user from connecting to the database?
hi guys
I ran checkdb and found 4 error message on the db.. it seen like same object.. can anyone tell me what it is.. and how can i fix it? thanks !!!!
1.
Server: Msg 8976, Level 16, State 1, Line 35
Table error: Object ID 2094630505, index ID 1. Page (1:809859) was not seen in the scan although its parent (1:77885) and previous (1:809767) refer to it. Check any previous errors.
2.
Server: Msg 8978, Level 16, State 1, Line 35
Table error: Object ID 2094630505, index ID 1. Page (1:809860) is missing a reference from previous page (1:809859). Possible chain linkage problem.
3.
Server: Msg 8976, Level 16, State 1, Line 35
Table error: Object ID 2094630505, index ID 1. Page (1:1453795) was not seen in the scan although its parent (1:1453347) and previous (1:1453796) refer to it. Check any previous errors.
4.
Server: Msg 8978, Level 16, State 1, Line 35
Table error: Object ID 2094630505, index ID 1. Page (1:1453801) is missing a reference from previous page (1:1453795). Possible chain linkage problem.
Hi All,
Does anybody know if the results of DBCC CHECKDB are stored anywhere? If yes, where?
Also, if you don't select "attempt to repair minor problems" option when you set up the maintenance plan, will SQL Server let you know about any errors Integrity check encounters? If yes, where the erros can be found?
Thanks.
Hello all,
in the SQL 6.5 documentation it says when running the DBCC CHECKDB, you should make the database read Only or DBO use only. Do you guys know if SQL 6.5 locks rows while this runs? In SQL 7.0/2000 it only locks the schema.
Thanks,
Lee E. Smith
I am using windows nt40 and sql server 6.5 on a DEC ALPHA and accidentlly
started a dbcc checkdb. Is it possible to stop the process with out damaging the database?
When running dbcc checkdb from my workstation(nt) I recieve some of
the output and then I get "Connection Broken" this is on a 6.5 machine
with the service pack 5, what could be causing my ODBC connection to drop
during the proccess of running checkdb?
Kevin
Hi All,
How can I make the dbcc checkdb fail so I can get the errors displayed in the report log? DBCC Checkdb is the step in the integrity job that I run once a month. What I am trying to do is when the dbcc checkdb fails for any reason, I want to get notified so I can correct the problem. I don't want to use repair fast or any other repair parameters that you can select when you run dbcc checkdb function because most of my dbs are 24x7.
Thanks.
How often do you run it in your shop?
I'm seeing (from the new SQL Best Practices Analyzer) that MS recommends that it be done once every two weeks on SQL 2005.
I have never been in the habit of running it in production. I have never experienced database corruption in any form.
Just curious.
Regards,
hmscott
Hi All,
I have a job set up that runs the dbcc checkdb and puts the results into a table. Then I run a query against this table to check the results of dbcc checkdb. If there are errors, I get a page that lets me know that there are some problems. When I ran this job on my production server, the job failed stating that there are problems with data integrity. So I copied this db to a dev server and recreated the job just like I have in prod. The job completed successfully withou any errors. Can anybody tell me what to look at to figure out why it failed on the prod server?
Thanks.
Madhur writes "Last week DBCC CHECKDB <database name> took 2 Hrs to complete on a database.
Today again i have started but with the following command:
dbcc checkdb (<database name>, REPAIR_FAST ).
It is now running for more than 2.5 Hrs now.
Does the execution time increases even when the DB is consistent?
Can we cancel the execution in the middle? What consequences it may have on the db?
Thanks in advance."
I have a db that is about 50Gigs. Last night it went into a suspect mode and I have not been able to get any of my tables to display. I am running the dbcc checkdb. I have been running it for over 7 hrs. Do you have any suggestions as to what I should do or do you have any ideas as to how long this process might take?
thanks,
Ricardo writes "We are consistently getting this error. We have check the hardware and nothing appears in the checkdk, can you help.
Thanks
Ricardo
dbcc checkdb (virtualrequest)
DBCC results for 'tblVRAnswers'.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 370256524, index ID 3: Page (1:243518) could not be processed. See other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 370256524, index ID 3, page (1:243518). Test (IS_ON (BUF_IOERR, bp->bstat) &&bp->berrcode) failed. Values are 2057 and -1.
There are 9608 rows in 106 pages for object 'tblVRAnswers'.
CHECKDB found 0 allocation errors and 2 consistency errors in database 'VirtualRequest'.
dbcc checkdb (virtualrequest)
DBCC results for 'tblvrquestions'.
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'VirtualRequest', index 'tblVRRequestedItems.IX_NC_tblVRRequestedItems_CurrentStatusID' (ID 784825958) (index ID 2). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:214293:372) with values (CurrentStatusID = 3 and RequestedItemID = 413260) points to the data row identified by ().
There are 6614 rows in 103 pages for object 'tblvrquestions'.
CHECKDB found 0 allocation errors and 1 consistency errors in database 'VirtualRequest'
dbcc checkdb (virtualrequest)
DBCC results for 'tblvrquestions'.
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'VirtualRequest', index 'tblVRRequestedItems.IX_NC_tblVRRequestedItems_CurrentStatusID' (ID 784825958) (index ID 2). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:214293:372) with values (CurrentStatusID = 3 and RequestedItemID = 413260) points to the data row identified by ().
There are 6614 rows in 103 pages for object 'tblvrquestions'.
CHECKDB found 0 allocation errors and 1 consistency errors in database 'VirtualRequest'."
We had a bit of an accident last night.
My nightly maintenance task runs fine normally. Last night it didn't.
When it got to DBCC CHECKDB for an audit database (it gets populated from triggers in other databases; one of the tables has over a million records), the live database server shut down and did not come back up. DBCC CHECKDB completed in 6 seconds with no errors. The next task in the sequence that would have run (but the log has no message of it completing or failing) was DBCC INDEXDEFRAG on that audit table with over a million records.
Even the OFF button on the 64-bit Dell server (SQL2005, Windows Server Enterprise x64 2003 SP1, 16 gig ram) did not work. There wasn't even the blue screen of death. It was just a blue screen. A plug out and plug back in was required.
The only recent configuration change has been that we have had Dell install a piece of disk-level replication software called Double Take.
Could CheckDB have contributed to this problem?
When i run TKizers sp to check database integrity. I'm getting this error.
Executed as user: IAPESQLAdmin. ...536) DBCC results for 'sysobjects'. [SQLSTATE 01000] (Message 2536) There are 1364 rows in 23 pages for object 'sysobjects'. [SQLSTATE 01000] (Message 2593) DBCC results for 'sysindexes'. [SQLSTATE 01000] (Message 2536) There are 138 rows in 5 pages for object 'sysindexes'. [SQLSTATE 01000] (Message 2593) DBCC results for 'syscolumns'. [SQLSTATE 01000] (Message 2536) There are 5251 rows in 104 pages for object 'syscolumns'. [SQLSTATE 01000] (Message 2593) DBCC results for 'systypes'. [SQLSTATE 01000] (Message 2536) There are 26 rows in 1 pages for object 'systypes'. [SQLSTATE 01000] (Message 2593) DBCC results for 'syscomments'. [SQLSTATE 01000] (Message 2536) There are 2115 rows in 1112 pages for object 'syscomments'. [SQLSTATE 01000] (Message 2593) DBCC results for 'sysfiles1'. [SQLSTATE 01000] (Message 2536) There are 2 rows in 1 pages for object 'sysfiles1'. [SQLSTATE 01000] (Message 2593) DBCC results for 'syspermissions'. [SQLSTATE... The step failed.
=============================
http://www.sqlserverstudy.com
I ran "dbcc checkdb(MCMSdb) with no_infomsgs" and I get the following:Server: Msg 8946, Level 16, State 12, Line 2Table error: Allocation page (1:274992) has invalid PFS_PAGE pageheader values. Type is 0. Check type, object ID and page ID on thepage.What cane be done to correct this problem?Can this error prevent a user from connecting to the database?
View 2 Replies View RelatedMy dbcc checkdb has been running for approximately 29 hours. Is this normal? Thanks!!!
View 6 Replies View RelatedDoes anyone know how long DBCC CHECKDB REPAIR_REBUILD will take on a 4 GB database? The regular DBCC CHECKDB takes about 4 minutes.
Thanks
I need a bit of a hand with coding the DBCC CHECKDB command in QA.
I have been trying to configure my helpdesk database after moving drives in the original box after the old one ran out of space.
Now when i try and start the server daemons, i get a database check error.
can anyone help out with a DBCC CHECKDB command that will only check the database named AHDTEST50?
Thanks!
Hi,
Appreciated someone able to provide me some clu on how to perfom DBCC CHECKDB. Is it necessary to set the database to "Read only" before execute DBCC CHECKDB?
Appreaciated your help.
Regards,
Jimmy Liew
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?
Hi all, weird output ...
when running DBCC CHECKDB on a DB i get this error:
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (4:3457816) with latch type SH. sysindexes failed.
when running DBCC CHECKTABLE ('sysindexes') i get a little bit more info:
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (4:3457816) with latch type SH. sysindexes failed.
Server: Msg 8944, Level 16, State 1, Line 1
Table error: Object ID 2, index ID 0, page (4:3457816), row 9. Test (!(hdr->r_tagA & (VERSION_MASK | RECTAG_RESV_A | RECTAG_RESV_B))) failed. Values are 105 and 193.
CHECKTABLE found 0 allocation errors and 1 consistency errors in table 'sysindexes' (object ID 2).
I'm a bit clueless after seeing this and would like to know if someone has experienced this before and would be willing to offer some advice.
Thank you!
I am getting the following after kicking off DBCC CHECKDB 'DATABASE', REPAIR_ALLOW_DATA_LOSS) :
Executed as user: USER. Database 'TEST' consistency errors in sysobjects, sysindexes, syscolumns, or systypes prevent further CHECKDB processing. [SQLSTATE 42000] (Error 7995) Clustered index successfully restored for object 'syscolumns' in database 'TEST'. [SQLSTATE 01000] (Error 2592) DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000] (Error 2528). The step failed.
I have found this link:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/tr_reslsyserr_2_4d2r.asp
Not good. Has anyone experianced this before.
I got error after running DBCC checkDB, the error was:
-----------
[10] Database MyDB: Check Data and Index Linkage...
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 8921: [Microsoft][ODBC SQL Server Driver][SQL Server]CHECKTABLE terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is corrupt. Check previous errors.
[Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation errors and 1 consistency errors not associated with any single object.
[Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation errors and 1 consistency errors in database 'MyDB'.
[Microsoft][ODBC SQL Server Driver][SQL Server]repair_fast is the minimum repair level for the errors found by DBCC CHECKDB (MyDB ).
The following errors were found:
[Microsoft][ODBC SQL Server Driver][SQL Server]CHECKTABLE terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is corrupt. Check previous errors.
[Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation errors and 1 consistency errors not associated with any single object.
[Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation errors and 1 consistency errors in database 'MyDB'.
[Microsoft][ODBC SQL Server Driver][SQL Server]repair_fast is the minimum repair level for the errors found by DBCC CHECKDB (MyDB ).
** Execution Time: 1 hrs, 44 mins, 34 secs **
---------
Then after running DBCC CheckDB (MyDB, repair_fast), the error was:
---------------
Server: Msg 8966, Level 16, State 2, Line 1
Could not read and latch page (1:1879304) with latch type SH. Latch failed.
CHECKDB found 0 allocation errors and 1 consistency errors not associated with any single object.
CHECKDB found 0 allocation errors and 1 consistency errors in database 'MyDB'.
repair_fast is the minimum repair level for the errors found by DBCC CHECKDB (MyDB, repair_fast).
--------
If I run DBCC CheckTbale for each table, there is no error on those tables.
Please help. Thanks.
Linda
I have a very intersting scenario occuring during a DBCC CheckDB, which causes the server and I/O bus to completely hang when using an ExtremeRAID3000 fibre card. Here is the full hardware scenario:
Two Windows 2000 Advanced Servers (clustered) w/2GB RAM each
ExtremeRAID3000 card
JBOD with Fibre Drives
SQL2000 SP3 (have not tried SP4 yet)
I have been able to reproduce this on 3 different clusters. Each had different brands of memory/motherboard/hard drives. The only common hardware item was the ExtremeRAID3000.
Each clustered server runs about 400 databases, 24/7/365. I only reboot the computers about once every 3000 hours as the Windows Updates pile up and need to be applied.
If I run a DBCC CHECKDB on various databases, the command hangs and the I/O subsystem crashes, requiring a full reboot of both nodes in order to get the fibre I/O working again.
All other operations work fine, including:
physical defragmenting the hard drive
logical defragmentation of the databases
full/Differential database backups
chkdsk (fsutil /set dirty)
failover
multiple terrabytes of bytes read/written through SQL for weeks on end
I currently backup and restore the databases onto a different server each week, and run DBCC CHECKDB to verify them, which is how I know they are fine (plus the customer's don't complain of anything corrupt).
Any ideas what DBCC CHECKDB could possibly be doing to cause the I/O subsystem to go offline? This is not consistent either, I can run it on some databases some weeks, and other databases other weeks. It varies from time to time. But if I find one it crashes on, it will hang again if I run it again immediately after rebooting. So I haven't run DBCC CHECKDB's on the production servers with ExtremeRAID 3000's in over two years.
One final thing, I have several other clusters that do not use these cards, and they have no problems with DBCC CHECKDB.
Intelligent Design is Christianity Evolving due to Natural Selection.
Simon writes "There are error messages in our DBCC CheckDB job. It happens in two of tables. (See below for the sample error messages.)
I have found two postings in the forum; but it seems that they are not applicable to my situation:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=65913
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55021
The errors happen to two of the user tables.
So my questions are:
1. How to fix these errors?
2. Are the records in the DB still good?
3. How to prevent this happening again?
The database server is running Windows 2000 sp4 and SQL 2000 sp3. It's running on the RAID5 in MS Cluster environment.
I really appreciate your assistance. Thank you.
The error message samples are:
Msg 8974, Sev 16: Text node referenced by more than one node. Object ID 837578022, text, ntext, or image node page (1:130912), slot 27, text ID 25207869603840 is pointed to by page (1:1392667), slot 2 and by page (1:1210230), slot 10. [SQLSTATE 42000]
Msg 8961, Sev 16: Table error: Object ID 837578022. The text, ntext, or image node at page (1:130912), slot 30, text ID 25199404974080 does not match its reference from page (1:131226), slot 17. [SQLSTATE 42000]
Msg 8974, Sev 16: Text node referenced by more than one node. Object ID 837578022, text, ntext, or image node page (1:130912), slot 30, text ID 25254380437504 is pointed to by page (1:1392667), slot 4 and by page (1:131226), slot 17. [SQLSTATE 42000]
Msg 8964, Sev 16: Table error: Object ID 837578022. The text, ntext, or image node at page (1:134162), slot 23, text ID 25204615217152 is not referenced. [SQLSTATE 42000]
Msg 8990, Sev 16: CHECKDB found 0 allocation errors and 211 consistency errors in table 'TABLE_ONE' (object ID 837578022). [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'TABLE_TWO'. [SQLSTATE 01000]
Msg 8974, Sev 16: Text node referenced by more than one node. Object ID 853578079, text, ntext, or image node page (1:129320), slot 38, text ID 25496001314816 is pointed to by page (1:239021), slot 101 and by page (1:487008), slot 100. [SQLSTATE 42000]
Msg 8961, Sev 16: Table error: Object ID 853578079. The text, ntext, or image node at page (1:129320), slot 39, text ID 25199327903744 does not match its reference from page (1:487008), slot 101. [SQLSTATE 42000]
Msg 8974, Sev 16: Text node referenced by more than one node. Object ID 853578079, text, ntext, or image node page (1:129320), slot 39, text ID 25496001642496 is pointed to by page (1:239021), slot 102 and by page (1:487008), slot 101. [SQLSTATE 42000]
Msg 8964, Sev 16: Table error: Object ID 853578079. The text, ntext, or image node at page (1:136454), slot 1, text ID 25031875559424 is not referenced. [SQLSTATE 42000]
Msg 8964, Sev 16: Table error: Object ID 853578079. The text, ntext, or image node at page (1:136454), slot 2, text ID 25031875887104 is not referenced. [SQLSTATE 42000]
Msg 8964, Sev 16: Table error: Object ID 853578079. The text, ntext, or image node at page (1:136603), slot 2, text ID 25031875231744 is not referenced. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 853578079, index ID 255: Page (1:137476) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8939, Sev 16: Table error: Object ID 853578079, index ID 255, page (1:137476). Test (m_freeCnt == freeCnt) failed. Values are 357 and 525. [SQLSTATE 42000]
Msg 2593, Sev 16: There are 1972569 rows in 14051 pages for object 'TABLE_TWO'. [SQLSTATE 01000]
Msg 8990, Sev 16: CHECKDB found 0 allocation errors and 166 consistency errors in table 'TABLE_TWO' (object ID 853578079). [SQLSTATE 01000]"