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

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SQL2000 & Table error: Object ID 1, index ID 0 cro
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

AlanMcKinney
Starting Member

1 Posts

Posted - 09/26/2014 :  11:05:26  Show Profile  Reply with Quote
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.

  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000