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.
| 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 |
|
|
|
|
|
|
DBCC Failed and results have me confused