We are getting follwoing error continuously:
DESCRIPTION: Error: 7987, Severity: 22, State: 1
A possible database consistency problem has been detected on database 'SIEBELDB'.
DBCC CHECKDB and DBCC CHECKCATALOG should be run on database 'SIEBELDB'.
dbcc checkdb(7) output:
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (1:1119266) with latch type SH. sysindexes failed.
Server: Msg 8940, Level 16, State 1, Line 1
Table error: Object ID 2, index ID 0, page (1:1119266).
Test (IsAligned (sorted[i].offset)) failed. Address 0x116 is not aligned.
CHECKTABLE found 0 allocation errors and 1 consistency
errors in table 'sysindexes' (object ID 2).
DBCC execution completed. If DBCC printed error messages,
contact your system administrator.
Also DBCC PAGE (7,1,1119266,1) output is:
PAGE: (1:1119266)
-----------------
BUFFER:
-------
BUF @0x00F32540
---------------
bpage = 0x8111A000 bhash = 0x00000000 bpageno = (1:1119266)
bdbid = 7 breferences = 1 bstat = 0x9
bspin = 0 bnext = 0x00000000
PAGE HEADER:
------------
Page @0x8111A000
----------------
m_pageId = (1:1119266) m_headerVersion = 1 m_type = 1
m_typeFlagBits = 0x0 m_level = 0 m_flagBits = 0x4002
m_objId = 2 m_indexId = 0 m_prevPage = (1:4794)
m_nextPage = (1:113720) pminlen = 82 m_slotCnt = 22
m_freeCnt = 3068 m_freeData = 6376 m_reservedCnt = 0
m_lsn = (1045582:22576:19) m_xactReserved = 0
m_xdesId = (0:1858251967) m_ghostRecCnt = 0 m_tornBits = 402653386
Allocation Status
-----------------
GAM (1:1022464) = ALLOCATED
SGAM (1:1022465) = NOT ALLOCATED
PFS (1:1116144) = 0x40 ALLOCATED 0_PCT_FULL DIFF (1:1022470) = CHANGED
ML (1:1022471) = NOT MIN_LOGGED
DATA:
-----
Slot 0, Offset 0x1804
---------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
8111B804: 00520030 06a549ca 00a00060 00000000 0.R..I..`.......
8111B814: 00110000 00000000 000e0000 00010002 ................
8111B824: 00000000 00000000 00000000 00000000 ................
8111B834: 00000000 00000000 00300000 00000036 ..........0.6...
8111B844: 00000000 00000000 00000000 00000000 ................
8111B854: 001b0000 00000000 00a00003 80e200d2 ................
8111B864: 006c006c 0716000d 00000000 00000000 l.l.............
8111B874: 00010013 00000000 0001002d 00000000 ........-.......
8111B884: 00a703a7 0000000f 3400d008 00000000 ...........4....
8111B894: ffff0001 00000000 ffffffff 00010000 ................
8111B8A4: 0057005f 005f0041 00790053 005f0073 _.W.A._.S.y.s._.
8111B8B4: 0052004f 00450044 005f0052 00590042 O.R.D.E.R._.B.Y.
8111B8C4: 0030005f 00410036 00340035 00430039 _.0.6.A.5.4.9.C.
8111B8D4: 00000041 0026e1ad 19ee0000 00010000 A.....&.........
8111B8E4: 0001 ..
Slot 1, Offset 0x478b
---------------------
Row at offset 18315 may be corrupt.
Hex dump of remaining -10167 bytes:
OFFSET TABLE:
-------------
Row - Offset
21 (0x15) - -31386 (0xffff8566)
20 (0x14) - 29888 (0x74c0)
19 (0x13) - 26179 (0x6643)
18 (0x12) - 25661 (0x643d)
17 (0x11) - 29696 (0x7400)
16 (0x10) - -29891 (0xffff8b3d)
15 (0xf) - -11130 (0xffffd486)
14 (0xe) - 0 (0x0)
13 (0xd) - -29952 (0xffff8b00)
12 (0xc) - 7247 (0x1c4f)
11 (0xb) - 26704 (0x6850)
10 (0xa) - -24436 (0xffffa08c)
9 (0x9) - 4105 (0x1009)
8 (0x8) - 1128 (0x468)
7 (0x7) - 2466 (0x9a2)
6 (0x6) - 20752 (0x5110)
5 (0x5) - 26088 (0x65e8)
4 (0x4) - 278 (0x116)
3 (0x3) - -29952 (0xffff8b00)
2 (0x2) - -939 (0xfffffc55)
1 (0x1) - 18315 (0x478b)
0 (0x0) - 6148 (0x1804)
DBCC execution completed. If DBCC printed error messages,
contact your system administrator.
OS Windows 2000 Server SQL Sever Database 2000?
Pleas help resolving the issue.
