SQL2000 & Table error: Object ID 1, index ID 0 cro

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

SQL2000 & Table error: Object ID 1, index ID 0 cro

Author

Topic

AlanMcKinney
Starting Member

1 Post

Posted - 2014-09-26 : 11:05:26

Results of dbcc checkdb (promise, repair_allow_data_loss)

Msg 8930, Level 16, State 1, Line 1
Table error: Object ID 1, index ID 0 cross-object chain linkage. Page (1:38345) points to (1:246800) in object ID 6, index ID 0.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
----------------------------------------------------------------------

Results of DBCC TRACEON (3604)
DBCC PAGE (promise, 1, 38345)
DBCC PAGE (promise, 1, 246800)
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

PAGE: (1:38345)
---------------

BUFFER:
-------

BUF @0x00FBE9C0
---------------
bpage = 0x432BE000 bhash = 0x00000000 bpageno = (1:38345)
bdbid = 7 breferences = 1 bstat = 0x9
bspin = 0 bnext = 0x00000000

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

Page @0x432BE000
----------------
m_pageId = (1:38345) m_headerVersion = 1 m_type = 1
m_typeFlagBits = 0x0 m_level = 0 m_flagBits = 0x2
m_objId = 1 m_indexId = 0 m_prevPage = (1:210259)
m_nextPage = (1:246800) pminlen = 42 m_slotCnt = 32
m_freeCnt = 4152 m_freeData = 8044 m_reservedCnt = 0
m_lsn = (107404:452:111) m_xactReserved = 0 m_xdesId = (0:38290536)
m_ghostRecCnt = 0 m_tornBits = 1

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

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

PAGE: (1:246800)
----------------

BUFFER:
-------

BUF @0x00FBE980
---------------
bpage = 0x432BC000 bhash = 0x00000000 bpageno = (1:246800)
bdbid = 7 breferences = 1 bstat = 0x9
bspin = 0 bnext = 0x00000000

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

Page @0x432BC000
----------------
m_pageId = (1:246800) m_headerVersion = 1 m_type = 1
m_typeFlagBits = 0x0 m_level = 0 m_flagBits = 0x8002
m_objId = 6 m_indexId = 0 m_prevPage = (1:70935)
m_nextPage = (1:14238) pminlen = 14 m_slotCnt = 1
m_freeCnt = 6150 m_freeData = 3364 m_reservedCnt = 0
m_lsn = (101710:181:2) m_xactReserved = 0 m_xdesId = (0:36934134)
m_ghostRecCnt = 0 m_tornBits = 1073742301

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

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

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources