SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 DBCC Failed and results have me confused
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

txkap
Starting Member

USA
2 Posts

Posted - 11/09/2011 :  21:23:31  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 11/10/2011 :  05:50:09  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
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
Go to Top of Page

txkap
Starting Member

USA
2 Posts

Posted - 11/12/2011 :  22:49:10  Show Profile  Reply with Quote
kind of figured that, was just wondering if someone had any hail mary pass...is there anyway I can find the exact table?
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 11/13/2011 :  06:27:04  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
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
Go to Top of Page
  Previous Topic Topic Next Topic  
 New 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.16 seconds. Powered By: Snitz Forums 2000