DBCC Failed and results have me confused

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

General SQL Server Forums

Data Corruption Issues

DBCC Failed and results have me confused

Author

Topic

txkap
Starting Member

2 Posts

Posted - 2011-11-09 : 21:23:31

So I am taking over in a crisis and everywhere I turn it seems there are fires! I feel like I am surrounded by a forest fire.... I have looked through other threads and I can't see one that matches my results:

DBCC CheckDB
RESULTS:
Could not read and latch page (1:8125) with latch type SH. sysindexes failed.

DBCC CheckTable('sysindexes')
RESULTS:
Table error: Object ID 2, index ID 0, page (1:8125). Test (m_flagBits & PG_ALIGNED4) failed. Values are 0 and 2.
CHECKTABLE found 0 allocation errors and 1 consistency errors in table 'sysindexes' (object ID 2).

Select * from sysindexes
RESULTS:
Everything pulls back, no errors.

DBCC TRACEON (3604)
DBCC PAGE (MyDB, 1, 8125, 3)
RESULTS:
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

PAGE: (1:8125)
--------------

BUFFER:
-------

BUF @0x18F01900
---------------
bpage = 0x43C38000 bhash = 0x00000000 bpageno = (1:8125)
bdbid = 7 breferences = 15 bstat = 0xb
bspin = 0 bnext = 0x00000000

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

Page @0x43C38000
----------------
m_pageId = (1:8125) m_headerVersion = 1 m_type = 1
m_typeFlagBits = 0x0 m_level = 0 m_flagBits = 0x0
m_objId = 2 m_indexId = 0 m_prevPage = (1:14730)
m_nextPage = (1:42692) pminlen = 82 m_slotCnt = 31
m_freeCnt = 474 m_freeData = 8004 m_reservedCnt = 0
m_lsn = (30385:14315:19) m_xactReserved = 0 m_xdesId = (0:49025003)
m_ghostRecCnt = 5 m_tornBits = 0

Allocation Status
-----------------
GAM (1:2) = ALLOCATED SGAM (1:3) = NOT ALLOCATED
PFS (1:8088) = 0x8 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.

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-11-10 : 05:50:09

SQL 2000?

This is not repairable. Unless you have a clean backup (one without the corruption), you're going to have to recreate the DB - script objects, bcp out data and reload.

--
Gail Shaw
SQL Server MVP

txkap
Starting Member

2 Posts

Posted - 2011-11-12 : 22:49:10

kind of figured that, was just wondering if someone had any hail mary pass...is there anyway I can find the exact table?

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-11-13 : 06:27:04

It's a system table that's affected - sysindexes. That's the table that stores info about how to access user tables in the DB.

--
Gail Shaw
SQL Server MVP

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources