database gor corrupted what to do

Question

Post reply

database gor corrupted what to do

Viewing 15 posts - 16 through 30 (of 40 total)

You must be logged in to reply to this topic. Login to reply

Krasavita SSC-Insane Points: 23138 More actions · Answer 1

DBCC CHECKTABLE (sysusers)

DBCC results for 'sysusers'.

There are 31 rows in 1 pages for object 'sysusers'.

DBCC IND (dbname, sysusers, -1)

PageFIDPagePIDIAMFIDIAMPIDObjectIDIndexIDPageTypeIndexLevelNextPageFID

139NULLNULL1011000

138139101200

140139100100

142NULLNULL1021000

141142102200

144NULLNULL1031000

143144103200

NextPagePIDPrevPageFIDPrevPagePID

000

DBCC TRACEON (3604)

DBCC PAGE (dbname, 1, 38, 2)

results:

PAGE: (1:38)

------------

BUFFER:

-------

BUF @0x00FBB280

---------------

bpage = 0x43104000 bhash = 0x00000000 bpageno = (1:38)

bdbid = 13 breferences = 1023 bstat = 0x9

bspin = 0 bnext = 0x00000000

PAGE HEADER:

------------

Page @0x43104000

----------------

m_pageId = (1:38) m_headerVersion = 1 m_type = 2

m_typeFlagBits = 0x0 m_level = 0 m_flagBits = 0xc002

m_objId = 10 m_indexId = 1 m_prevPage = (0:0)

m_nextPage = (0:0) pminlen = 9 m_slotCnt = 1

m_freeCnt = 8082 m_freeData = 108 m_reservedCnt = 0

m_lsn = (1:252:18) m_xactReserved = 0 m_xdesId = (0:0)

m_ghostRecCnt = 0 m_tornBits = 0

Allocation Status

-----------------

GAM (1:2) = ALLOCATED SGAM (1:3) = NOT ALLOCATED

PFS (1:1) = 0x60 MIXED_EXT ALLOCATED 0_PCT_FULL DIFF (1:6) = NOT CHANGED

ML (1:7) = NOT MIN_LOGGED

DATA:

-----

Memory Dump @0x43104000

-----------------------

43104000: 01020000 02c00100 00000000 00000900 ................

43104010: 00000000 00000100 0a000000 921f6c00 ..............l.

43104020: 26000000 01000000 01000000 fc000000 &...............

43104030: 12000000 00000000 00000000 00000000 ................

43104040: 00000000 00000000 00000000 00000000 ................

43104050: 00000000 00000000 00000000 00000000 ................

43104060: 16000028 00000001 00020000 00000000 ...(............

43104070: 00000000 00000000 00000000 00000000 ................

43104080: 00000000 00000000 00000000 00000000 ................

43104090: 00000000 00000000 00000000 00000000 ................

431040A0: 00000000 00000000 00000000 00000000 ................

431040B0: 00000000 00000000 00000000 00000000 ................

431040C0: 00000000 00000000 00000000 00000000 ................

431040D0: 00000000 00000000 00000000 00000000 ................

431040E0: 00000000 00000000 00000000 00000000 ................

431040F0: 00000000 00000000 00000000 00000000 ................

43104100: 00000000 00000000 00000000 00000000 ................

43104110: 00000000 00000000 00000000 00000000 ................

43104120: 00000000 00000000 00000000 00000000 ................

43104130: 00000000 00000000 00000000 00000000 ................

43104140: 00000000 00000000 00000000 00000000 ................

43104150: 00000000 00000000 00000000 00000000 ................

43104160: 00000000 00000000 00000000 00000000 ................

43104170: 00000000 00000000 00000000 00000000 ................

43104180: 00000000 00000000 00000000 00000000 ................

43104190: 00000000 00000000 00000000 00000000 ................

431041A0: 00000000 00000000 00000000 00000000 ................

431041B0: 00000000 00000000 00000000 00000000 ................

431041C0: 00000000 00000000 00000000 00000000 ................

431041D0: 00000000 00000000 00000000 00000000 ................

431041E0: 00000000 00000000 00000000 00000000 ................

431041F0: 00000000 00000000 00000000 00000000 ................

43104200: 00000000 00000000 00000000 00000000 ................

43104210: 00000000 00000000 00000000 00000000 ................

43104220: 00000000 00000000 00000000 00000000 ................

43104230: 00000000 00000000 00000000 00000000 ................

43104240: 00000000 00000000 00000000 00000000 ................

43104250: 00000000 00000000 00000000 00000000 ................

43104260: 00000000 00000000 00000000 00000000 ................

43104270: 00000000 00000000 00000000 00000000 ................

43104280: 00000000 00000000 00000000 00000000 ................

43104290: 00000000 00000000 00000000 00000000 ................

431042A0: 00000000 00000000 00000000 00000000 ................

431042B0: 00000000 00000000 00000000 00000000 ................

431042C0: 00000000 00000000 00000000 00000000 ................

431042D0: 00000000 00000000 00000000 00000000 ................

431042E0: 00000000 00000000 00000000 00000000 ................

431042F0: 00000000 00000000 00000000 00000000 ................

43104300: 00000000 00000000 00000000 00000000 ................

43104310: 00000000 00000000 00000000 00000000 ................

43104320: 00000000 00000000 00000000 00000000 ................

43104330: 00000000 00000000 00000000 00000000 ................

43104340: 00000000 00000000 00000000 00000000 ................

43104350: 00000000 00000000 00000000 00000000 ................

43104360: 00000000 00000000 00000000 00000000 ................

43104370: 00000000 00000000 00000000 00000000 ................

43104380: 00000000 00000000 00000000 00000000 ................

43104390: 00000000 00000000 00000000 00000000 ................

431043A0: 00000000 00000000 00000000 00000000 ................

431043B0: 00000000 00000000 00000000 00000000 ................

431043C0: 00000000 00000000 00000000 00000000 ................

431043D0: 00000000 00000000 00000000 00000000 ................

431043E0: 00000000 00000000 00000000 00000000 ................

431043F0: 00000000 00000000 00000000 00000000 ................

43104400: 00000000 00000000 00000000 00000000 ................

43104410: 00000000 00000000 00000000 00000000 ................

43104420: 00000000 00000000 00000000 00000000 ................

43104430: 00000000 00000000 00000000 00000000 ................

43104440: 00000000 00000000 00000000 00000000 ................

43104450: 00000000 00000000 00000000 00000000 ................

43104460: 00000000 00000000 00000000 00000000 ................

43104470: 00000000 00000000 00000000 00000000 ................

43104480: 00000000 00000000 00000000 00000000 ................

43104490: 00000000 00000000 00000000 00000000 ................

431044A0: 00000000 00000000 00000000 00000000 ................

431044B0: 00000000 00000000 00000000 00000000 ................

431044C0: 00000000 00000000 00000000 00000000 ................

431044D0: 00000000 00000000 00000000 00000000 ................

431044E0: 00000000 00000000 00000000 00000000 ................

431044F0: 00000000 00000000 00000000 00000000 ................

43104500: 00000000 00000000 00000000 00000000 ................

43104510: 00000000 00000000 00000000 00000000 ................

43104520: 00000000 00000000 00000000 00000000 ................

43104530: 00000000 00000000 00000000 00000000 ................

43104540: 00000000 00000000 00000000 00000000 ................

43104550: 00000000 00000000 00000000 00000000 ................

43104560: 00000000 00000000 00000000 00000000 ................

43104570: 00000000 00000000 00000000 00000000 ................

43104580: 00000000 00000000 00000000 00000000 ................

43104590: 00000000 00000000 00000000 00000000 ................

431045A0: 00000000 00000000 00000000 00000000 ................

431045B0: 00000000 00000000 00000000 00000000 ................

431045C0: 00000000 00000000 00000000 00000000 ................

431045D0: 00000000 00000000 00000000 00000000 ................

431045E0: 00000000 00000000 00000000 00000000 ................

431045F0: 00000000 00000000 00000000 00000000 ................

43104600: 00000000 00000000 00000000 00000000 ................

43104610: 00000000 00000000 00000000 00000000 ................

43104620: 00000000 00000000 00000000 00000000 ................

43104630: 00000000 00000000 00000000 00000000 ................

43104640: 00000000 00000000 00000000 00000000 ................

43104650: 00000000 00000000 00000000 00000000 ................

43104660: 00000000 00000000 00000000 00000000 ................

43104670: 00000000 00000000 00000000 00000000 ................

43104680: 00000000 00000000 00000000 00000000 ................

43104690: 00000000 00000000 00000000 00000000 ................

431046A0: 00000000 00000000 00000000 00000000 ................

431046B0: 00000000 00000000 00000000 00000000 ................

431046C0: 00000000 00000000 00000000 00000000 ................

431046D0: 00000000 00000000 00000000 00000000 ................

431046E0: 00000000 00000000 00000000 00000000 ................

431046F0: 00000000 00000000 00000000 00000000 ................

43104700: 00000000 00000000 00000000 00000000 ................

43104710: 00000000 00000000 00000000 00000000 ................

43104720: 00000000 00000000 00000000 00000000 ................

43104730: 00000000 00000000 00000000 00000000 ................

43104740: 00000000 00000000 00000000 00000000 ................

43104750: 00000000 00000000 00000000 00000000 ................

43104760: 00000000 00000000 00000000 00000000 ................

43104770: 00000000 00000000 00000000 00000000 ................

43104780: 00000000 00000000 00000000 00000000 ................

43104790: 00000000 00000000 00000000 00000000 ................

431047A0: 00000000 00000000 00000000 00000000 ................

431047B0: 00000000 00000000 00000000 00000000 ................

431047C0: 00000000 00000000 00000000 00000000 ................

431047D0: 00000000 00000000 00000000 00000000 ................

431047E0: 00000000 00000000 00000000 00000000 ................

431047F0: 00000000 00000000 00000000 00000000 ................

43104800: 00000000 00000000 00000000 00000000 ................

43104810: 00000000 00000000 00000000 00000000 ................

43104820: 00000000 00000000 00000000 00000000 ................

43104830: 00000000 00000000 00000000 00000000 ................

43104840: 00000000 00000000 00000000 00000000 ................

43104850: 00000000 00000000 00000000 00000000 ................

43104860: 00000000 00000000 00000000 00000000 ................

43104870: 00000000 00000000 00000000 00000000 ................

43104880: 00000000 00000000 00000000 00000000 ................

43104890: 00000000 00000000 00000000 00000000 ................

431048A0: 00000000 00000000 00000000 00000000 ................

431048B0: 00000000 00000000 00000000 00000000 ................

431048C0: 00000000 00000000 00000000 00000000 ................

431048D0: 00000000 00000000 00000000 00000000 ................

431048E0: 00000000 00000000 00000000 00000000 ................

431048F0: 00000000 00000000 00000000 00000000 ................

43104900: 00000000 00000000 00000000 00000000 ................

43104910: 00000000 00000000 00000000 00000000 ................

43104920: 00000000 00000000 00000000 00000000 ................

43104930: 00000000 00000000 00000000 00000000 ................

43104940: 00000000 00000000 00000000 00000000 ................

43104950: 00000000 00000000 00000000 00000000 ................

43104960: 00000000 00000000 00000000 00000000 ................

43104970: 00000000 00000000 00000000 00000000 ................

43104980: 00000000 00000000 00000000 00000000 ................

43104990: 00000000 00000000 00000000 00000000 ................

431049A0: 00000000 00000000 00000000 00000000 ................

431049B0: 00000000 00000000 00000000 00000000 ................

431049C0: 00000000 00000000 00000000 00000000 ................

431049D0: 00000000 00000000 00000000 00000000 ................

431049E0: 00000000 00000000 00000000 00000000 ................

431049F0: 00000000 00000000 00000000 00000000 ................

43104A00: 00000000 00000000 00000000 00000000 ................

43104A10: 00000000 00000000 00000000 00000000 ................

43104A20: 00000000 00000000 00000000 00000000 ................

43104A30: 00000000 00000000 00000000 00000000 ................

43104A40: 00000000 00000000 00000000 00000000 ................

43104A50: 00000000 00000000 00000000 00000000 ................

43104A60: 00000000 00000000 00000000 00000000 ................

43104A70: 00000000 00000000 00000000 00000000 ................

43104A80: 00000000 00000000 00000000 00000000 ................

43104A90: 00000000 00000000 00000000 00000000 ................

43104AA0: 00000000 00000000 00000000 00000000 ................

43104AB0: 00000000 00000000 00000000 00000000 ................

43104AC0: 00000000 00000000 00000000 00000000 ................

43104AD0: 00000000 00000000 00000000 00000000 ................

43104AE0: 00000000 00000000 00000000 00000000 ................

43104AF0: 00000000 00000000 00000000 00000000 ................

43104B00: 00000000 00000000 00000000 00000000 ................

43104B10: 00000000 00000000 00000000 00000000 ................

43104B20: 00000000 00000000 00000000 00000000 ................

43104B30: 00000000 00000000 00000000 00000000 ................

43104B40: 00000000 00000000 00000000 00000000 ................

43104B50: 00000000 00000000 00000000 00000000 ................

43104B60: 00000000 00000000 00000000 00000000 ................

43104B70: 00000000 00000000 00000000 00000000 ................

43104B80: 00000000 00000000 00000000 00000000 ................

43104B90: 00000000 00000000 00000000 00000000 ................

43104BA0: 00000000 00000000 00000000 00000000 ................

43104BB0: 00000000 00000000 00000000 00000000 ................

43104BC0: 00000000 00000000 00000000 00000000 ................

43104BD0: 00000000 00000000 00000000 00000000 ................

43104BE0: 00000000 00000000 00000000 00000000 ................

43104BF0: 00000000 00000000 00000000 00000000 ................

43104C00: 00000000 00000000 00000000 00000000 ................

43104C10: 00000000 00000000 00000000 00000000 ................

43104C20: 00000000 00000000 00000000 00000000 ................

43104C30: 00000000 00000000 00000000 00000000 ................

43104C40: 00000000 00000000 00000000 00000000 ................

43104C50: 00000000 00000000 00000000 00000000 ................

43104C60: 00000000 00000000 00000000 00000000 ................

43104C70: 00000000 00000000 00000000 00000000 ................

43104C80: 00000000 00000000 00000000 00000000 ................

43104C90: 00000000 00000000 00000000 00000000 ................

43104CA0: 00000000 00000000 00000000 00000000 ................

43104CB0: 00000000 00000000 00000000 00000000 ................

43104CC0: 00000000 00000000 00000000 00000000 ................

43104CD0: 00000000 00000000 00000000 00000000 ................

43104CE0: 00000000 00000000 00000000 00000000 ................

43104CF0: 00000000 00000000 00000000 00000000 ................

43104D00: 00000000 00000000 00000000 00000000 ................

43104D10: 00000000 00000000 00000000 00000000 ................

43104D20: 00000000 00000000 00000000 00000000 ................

43104D30: 00000000 00000000 00000000 00000000 ................

43104D40: 00000000 00000000 00000000 00000000 ................

43104D50: 00000000 00000000 00000000 00000000 ................

43104D60: 00000000 00000000 00000000 00000000 ................

43104D70: 00000000 00000000 00000000 00000000 ................

43104D80: 00000000 00000000 00000000 00000000 ................

43104D90: 00000000 00000000 00000000 00000000 ................

43104DA0: 00000000 00000000 00000000 00000000 ................

43104DB0: 00000000 00000000 00000000 00000000 ................

43104DC0: 00000000 00000000 00000000 00000000 ................

43104DD0: 00000000 00000000 00000000 00000000 ................

43104DE0: 00000000 00000000 00000000 00000000 ................

43104DF0: 00000000 00000000 00000000 00000000 ................

43104E00: 00000000 00000000 00000000 00000000 ................

43104E10: 00000000 00000000 00000000 00000000 ................

43104E20: 00000000 00000000 00000000 00000000 ................

43104E30: 00000000 00000000 00000000 00000000 ................

43104E40: 00000000 00000000 00000000 00000000 ................

43104E50: 00000000 00000000 00000000 00000000 ................

43104E60: 00000000 00000000 00000000 00000000 ................

43104E70: 00000000 00000000 00000000 00000000 ................

43104E80: 00000000 00000000 00000000 00000000 ................

43104E90: 00000000 00000000 00000000 00000000 ................

43104EA0: 00000000 00000000 00000000 00000000 ................

43104EB0: 00000000 00000000 00000000 00000000 ................

43104EC0: 00000000 00000000 00000000 00000000 ................

43104ED0: 00000000 00000000 00000000 00000000 ................

43104EE0: 00000000 00000000 00000000 00000000 ................

43104EF0: 00000000 00000000 00000000 00000000 ................

43104F00: 00000000 00000000 00000000 00000000 ................

43104F10: 00000000 00000000 00000000 00000000 ................

43104F20: 00000000 00000000 00000000 00000000 ................

43104F30: 00000000 00000000 00000000 00000000 ................

43104F40: 00000000 00000000 00000000 00000000 ................

43104F50: 00000000 00000000 00000000 00000000 ................

43104F60: 00000000 00000000 00000000 00000000 ................

43104F70: 00000000 00000000 00000000 00000000 ................

43104F80: 00000000 00000000 00000000 00000000 ................

43104F90: 00000000 00000000 00000000 00000000 ................

43104FA0: 00000000 00000000 00000000 00000000 ................

43104FB0: 00000000 00000000 00000000 00000000 ................

43104FC0: 00000000 00000000 00000000 00000000 ................

43104FD0: 00000000 00000000 00000000 00000000 ................

43104FE0: 00000000 00000000 00000000 00000000 ................

43104FF0: 00000000 00000000 00000000 00000000 ................

43105000: 00000000 00000000 00000000 00000000 ................

43105010: 00000000 00000000 00000000 00000000 ................

43105020: 00000000 00000000 00000000 00000000 ................

43105030: 00000000 00000000 00000000 00000000 ................

43105040: 00000000 00000000 00000000 00000000 ................

43105050: 00000000 00000000 00000000 00000000 ................

43105060: 00000000 00000000 00000000 00000000 ................

43105070: 00000000 00000000 00000000 00000000 ................

43105080: 00000000 00000000 00000000 00000000 ................

43105090: 00000000 00000000 00000000 00000000 ................

431050A0: 00000000 00000000 00000000 00000000 ................

431050B0: 00000000 00000000 00000000 00000000 ................

431050C0: 00000000 00000000 00000000 00000000 ................

431050D0: 00000000 00000000 00000000 00000000 ................

431050E0: 00000000 00000000 00000000 00000000 ................

431050F0: 00000000 00000000 00000000 00000000 ................

43105100: 00000000 00000000 00000000 00000000 ................

43105110: 00000000 00000000 00000000 00000000 ................

43105120: 00000000 00000000 00000000 00000000 ................

43105130: 00000000 00000000 00000000 00000000 ................

43105140: 00000000 00000000 00000000 00000000 ................

43105150: 00000000 00000000 00000000 00000000 ................

43105160: 00000000 00000000 00000000 00000000 ................

43105170: 00000000 00000000 00000000 00000000 ................

43105180: 00000000 00000000 00000000 00000000 ................

43105190: 00000000 00000000 00000000 00000000 ................

431051A0: 00000000 00000000 00000000 00000000 ................

431051B0: 00000000 00000000 00000000 00000000 ................

431051C0: 00000000 00000000 00000000 00000000 ................

431051D0: 00000000 00000000 00000000 00000000 ................

431051E0: 00000000 00000000 00000000 00000000 ................

431051F0: 00000000 00000000 00000000 00000000 ................

43105200: 00000000 00000000 00000000 00000000 ................

43105210: 00000000 00000000 00000000 00000000 ................

43105220: 00000000 00000000 00000000 00000000 ................

43105230: 00000000 00000000 00000000 00000000 ................

43105240: 00000000 00000000 00000000 00000000 ................

43105250: 00000000 00000000 00000000 00000000 ................

43105260: 00000000 00000000 00000000 00000000 ................

43105270: 00000000 00000000 00000000 00000000 ................

43105280: 00000000 00000000 00000000 00000000 ................

43105290: 00000000 00000000 00000000 00000000 ................

431052A0: 00000000 00000000 00000000 00000000 ................

431052B0: 00000000 00000000 00000000 00000000 ................

431052C0: 00000000 00000000 00000000 00000000 ................

431052D0: 00000000 00000000 00000000 00000000 ................

431052E0: 00000000 00000000 00000000 00000000 ................

431052F0: 00000000 00000000 00000000 00000000 ................

43105300: 00000000 00000000 00000000 00000000 ................

43105310: 00000000 00000000 00000000 00000000 ................

43105320: 00000000 00000000 00000000 00000000 ................

43105330: 00000000 00000000 00000000 00000000 ................

43105340: 00000000 00000000 00000000 00000000 ................

43105350: 00000000 00000000 00000000 00000000 ................

43105360: 00000000 00000000 00000000 00000000 ................

43105370: 00000000 00000000 00000000 00000000 ................

43105380: 00000000 00000000 00000000 00000000 ................

43105390: 00000000 00000000 00000000 00000000 ................

431053A0: 00000000 00000000 00000000 00000000 ................

431053B0: 00000000 00000000 00000000 00000000 ................

431053C0: 00000000 00000000 00000000 00000000 ................

431053D0: 00000000 00000000 00000000 00000000 ................

431053E0: 00000000 00000000 00000000 00000000 ................

431053F0: 00000000 00000000 00000000 00000000 ................

43105400: 00000000 00000000 00000000 00000000 ................

43105410: 00000000 00000000 00000000 00000000 ................

43105420: 00000000 00000000 00000000 00000000 ................

43105430: 00000000 00000000 00000000 00000000 ................

43105440: 00000000 00000000 00000000 00000000 ................

43105450: 00000000 00000000 00000000 00000000 ................

43105460: 00000000 00000000 00000000 00000000 ................

43105470: 00000000 00000000 00000000 00000000 ................

43105480: 00000000 00000000 00000000 00000000 ................

43105490: 00000000 00000000 00000000 00000000 ................

431054A0: 00000000 00000000 00000000 00000000 ................

431054B0: 00000000 00000000 00000000 00000000 ................

431054C0: 00000000 00000000 00000000 00000000 ................

431054D0: 00000000 00000000 00000000 00000000 ................

431054E0: 00000000 00000000 00000000 00000000 ................

431054F0: 00000000 00000000 00000000 00000000 ................

43105500: 00000000 00000000 00000000 00000000 ................

43105510: 00000000 00000000 00000000 00000000 ................

43105520: 00000000 00000000 00000000 00000000 ................

43105530: 00000000 00000000 00000000 00000000 ................

43105540: 00000000 00000000 00000000 00000000 ................

43105550: 00000000 00000000 00000000 00000000 ................

43105560: 00000000 00000000 00000000 00000000 ................

43105570: 00000000 00000000 00000000 00000000 ................

43105580: 00000000 00000000 00000000 00000000 ................

43105590: 00000000 00000000 00000000 00000000 ................

431055A0: 00000000 00000000 00000000 00000000 ................

431055B0: 00000000 00000000 00000000 00000000 ................

431055C0: 00000000 00000000 00000000 00000000 ................

431055D0: 00000000 00000000 00000000 00000000 ................

431055E0: 00000000 00000000 00000000 00000000 ................

431055F0: 00000000 00000000 00000000 00000000 ................

43105600: 00000000 00000000 00000000 00000000 ................

43105610: 00000000 00000000 00000000 00000000 ................

43105620: 00000000 00000000 00000000 00000000 ................

43105630: 00000000 00000000 00000000 00000000 ................

43105640: 00000000 00000000 00000000 00000000 ................

43105650: 00000000 00000000 00000000 00000000 ................

43105660: 00000000 00000000 00000000 00000000 ................

43105670: 00000000 00000000 00000000 00000000 ................

43105680: 00000000 00000000 00000000 00000000 ................

43105690: 00000000 00000000 00000000 00000000 ................

431056A0: 00000000 00000000 00000000 00000000 ................

431056B0: 00000000 00000000 00000000 00000000 ................

431056C0: 00000000 00000000 00000000 00000000 ................

431056D0: 00000000 00000000 00000000 00000000 ................

431056E0: 00000000 00000000 00000000 00000000 ................

431056F0: 00000000 00000000 00000000 00000000 ................

43105700: 00000000 00000000 00000000 00000000 ................

43105710: 00000000 00000000 00000000 00000000 ................

43105720: 00000000 00000000 00000000 00000000 ................

43105730: 00000000 00000000 00000000 00000000 ................

43105740: 00000000 00000000 00000000 00000000 ................

43105750: 00000000 00000000 00000000 00000000 ................

43105760: 00000000 00000000 00000000 00000000 ................

43105770: 00000000 00000000 00000000 00000000 ................

43105780: 00000000 00000000 00000000 00000000 ................

43105790: 00000000 00000000 00000000 00000000 ................

431057A0: 00000000 00000000 00000000 00000000 ................

431057B0: 00000000 00000000 00000000 00000000 ................

431057C0: 00000000 00000000 00000000 00000000 ................

431057D0: 00000000 00000000 00000000 00000000 ................

431057E0: 00000000 00000000 00000000 00000000 ................

431057F0: 00000000 00000000 00000000 00000000 ................

43105800: 00000000 00000000 00000000 00000000 ................

43105810: 00000000 00000000 00000000 00000000 ................

43105820: 00000000 00000000 00000000 00000000 ................

43105830: 00000000 00000000 00000000 00000000 ................

43105840: 00000000 00000000 00000000 00000000 ................

43105850: 00000000 00000000 00000000 00000000 ................

43105860: 00000000 00000000 00000000 00000000 ................

43105870: 00000000 00000000 00000000 00000000 ................

43105880: 00000000 00000000 00000000 00000000 ................

43105890: 00000000 00000000 00000000 00000000 ................

431058A0: 00000000 00000000 00000000 00000000 ................

431058B0: 00000000 00000000 00000000 00000000 ................

431058C0: 00000000 00000000 00000000 00000000 ................

431058D0: 00000000 00000000 00000000 00000000 ................

431058E0: 00000000 00000000 00000000 00000000 ................

431058F0: 00000000 00000000 00000000 00000000 ................

43105900: 00000000 00000000 00000000 00000000 ................

43105910: 00000000 00000000 00000000 00000000 ................

43105920: 00000000 00000000 00000000 00000000 ................

43105930: 00000000 00000000 00000000 00000000 ................

43105940: 00000000 00000000 00000000 00000000 ................

43105950: 00000000 00000000 00000000 00000000 ................

43105960: 00000000 00000000 00000000 00000000 ................

43105970: 00000000 00000000 00000000 00000000 ................

43105980: 00000000 00000000 00000000 00000000 ................

43105990: 00000000 00000000 00000000 00000000 ................

431059A0: 00000000 00000000 00000000 00000000 ................

431059B0: 00000000 00000000 00000000 00000000 ................

431059C0: 00000000 00000000 00000000 00000000 ................

431059D0: 00000000 00000000 00000000 00000000 ................

431059E0: 00000000 00000000 00000000 00000000 ................

431059F0: 00000000 00000000 00000000 00000000 ................

43105A00: 00000000 00000000 00000000 00000000 ................

43105A10: 00000000 00000000 00000000 00000000 ................

43105A20: 00000000 00000000 00000000 00000000 ................

43105A30: 00000000 00000000 00000000 00000000 ................

43105A40: 00000000 00000000 00000000 00000000 ................

43105A50: 00000000 00000000 00000000 00000000 ................

43105A60: 00000000 00000000 00000000 00000000 ................

43105A70: 00000000 00000000 00000000 00000000 ................

43105A80: 00000000 00000000 00000000 00000000 ................

43105A90: 00000000 00000000 00000000 00000000 ................

43105AA0: 00000000 00000000 00000000 00000000 ................

43105AB0: 00000000 00000000 00000000 00000000 ................

43105AC0: 00000000 00000000 00000000 00000000 ................

43105AD0: 00000000 00000000 00000000 00000000 ................

43105AE0: 00000000 00000000 00000000 00000000 ................

43105AF0: 00000000 00000000 00000000 00000000 ................

43105B00: 00000000 00000000 00000000 00000000 ................

43105B10: 00000000 00000000 00000000 00000000 ................

43105B20: 00000000 00000000 00000000 00000000 ................

43105B30: 00000000 00000000 00000000 00000000 ................

43105B40: 00000000 00000000 00000000 00000000 ................

43105B50: 00000000 00000000 00000000 00000000 ................

43105B60: 00000000 00000000 00000000 00000000 ................

43105B70: 00000000 00000000 00000000 00000000 ................

43105B80: 00000000 00000000 00000000 00000000 ................

43105B90: 00000000 00000000 00000000 00000000 ................

43105BA0: 00000000 00000000 00000000 00000000 ................

43105BB0: 00000000 00000000 00000000 00000000 ................

43105BC0: 00000000 00000000 00000000 00000000 ................

43105BD0: 00000000 00000000 00000000 00000000 ................

43105BE0: 00000000 00000000 00000000 00000000 ................

43105BF0: 00000000 00000000 00000000 00000000 ................

43105C00: 00000000 00000000 00000000 00000000 ................

43105C10: 00000000 00000000 00000000 00000000 ................

43105C20: 00000000 00000000 00000000 00000000 ................

43105C30: 00000000 00000000 00000000 00000000 ................

43105C40: 00000000 00000000 00000000 00000000 ................

43105C50: 00000000 00000000 00000000 00000000 ................

43105C60: 00000000 00000000 00000000 00000000 ................

43105C70: 00000000 00000000 00000000 00000000 ................

43105C80: 00000000 00000000 00000000 00000000 ................

43105C90: 00000000 00000000 00000000 00000000 ................

43105CA0: 00000000 00000000 00000000 00000000 ................

43105CB0: 00000000 00000000 00000000 00000000 ................

43105CC0: 00000000 00000000 00000000 00000000 ................

43105CD0: 00000000 00000000 00000000 00000000 ................

43105CE0: 00000000 00000000 00000000 00000000 ................

43105CF0: 00000000 00000000 00000000 00000000 ................

43105D00: 00000000 00000000 00000000 00000000 ................

43105D10: 00000000 00000000 00000000 00000000 ................

43105D20: 00000000 00000000 00000000 00000000 ................

43105D30: 00000000 00000000 00000000 00000000 ................

43105D40: 00000000 00000000 00000000 00000000 ................

43105D50: 00000000 00000000 00000000 00000000 ................

43105D60: 00000000 00000000 00000000 00000000 ................

43105D70: 00000000 00000000 00000000 00000000 ................

43105D80: 00000000 00000000 00000000 00000000 ................

43105D90: 00000000 00000000 00000000 00000000 ................

43105DA0: 00000000 00000000 00000000 00000000 ................

43105DB0: 00000000 00000000 00000000 00000000 ................

43105DC0: 00000000 00000000 00000000 00000000 ................

43105DD0: 00000000 00000000 00000000 00000000 ................

43105DE0: 00000000 00000000 00000000 00000000 ................

43105DF0: 00000000 00000000 00000000 00000000 ................

43105E00: 00000000 00000000 00000000 00000000 ................

43105E10: 00000000 00000000 00000000 00000000 ................

43105E20: 00000000 00000000 00000000 00000000 ................

43105E30: 00000000 00000000 00000000 00000000 ................

43105E40: 00000000 00000000 00000000 00000000 ................

43105E50: 00000000 00000000 00000000 00000000 ................

43105E60: 00000000 00000000 00000000 00000000 ................

43105E70: 00000000 00000000 00000000 00000000 ................

43105E80: 00000000 00000000 00000000 00000000 ................

43105E90: 00000000 00000000 00000000 00000000 ................

43105EA0: 00000000 00000000 00000000 00000000 ................

43105EB0: 00000000 00000000 00000000 00000000 ................

43105EC0: 00000000 00000000 00000000 00000000 ................

43105ED0: 00000000 00000000 00000000 00000000 ................

43105EE0: 00000000 00000000 00000000 00000000 ................

43105EF0: 00000000 00000000 00000000 00000000 ................

43105F00: 00000000 00000000 00000000 00000000 ................

43105F10: 00000000 00000000 00000000 00000000 ................

43105F20: 00000000 00000000 00000000 00000000 ................

43105F30: 00000000 00000000 00000000 00000000 ................

43105F40: 00000000 00000000 00000000 00000000 ................

43105F50: 00000000 00000000 00000000 00000000 ................

43105F60: 00000000 00000000 00000000 00000000 ................

43105F70: 00000000 00000000 00000000 00000000 ................

43105F80: 00000000 00000000 00000000 00000000 ................

43105F90: 00000000 00000000 00000000 00000000 ................

43105FA0: 00000000 00000000 00000000 00000000 ................

43105FB0: 00000000 00000000 00000000 00000000 ................

43105FC0: 00000000 00000000 00000000 00000000 ................

43105FD0: 00000000 00000000 00000000 00000000 ................

43105FE0: 00000000 00000000 00000000 00000000 ................

43105FF0: 00000000 00000000 00000000 00006000 ..............`.

Krasavita SSC-Insane Points: 23138 More actions · Answer 2

I had to do it DBCC TRACEoff (3604) 2 minutes later this is production server.

I did it like this:

DBCC TRACEoff (3604) is this correct?

Krasavita SSC-Insane Points: 23138 More actions · Answer 3

Also, when our db got corrupted we rebooted sql server and db came back,db got corrupted,but could be memory of db got corrupted and didn't repair on it own? Would this show in logs?

Paul Randal One Orange Chip Points: 29544 More actions · Answer 4

No, you didn't need to turn that TF off - all it does is put DBCC undocumented command output to the console instead of the errorlog.

Ok - your I/O subsystem isn't reading pages correctly. All the information you posted shows that page (1:38), which SQL Server complained was corrupt, isn't actually corrupt.

You need to run I/O subsystem diagnostics, check all your firmware levels, and possibly move to a new I/O subsystem.

Thanks

Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005

Krasavita SSC-Insane Points: 23138 More actions · Answer 5

Should I turn that TF on ?

why do I need to - put DBCC undocumented command output to the console instead of the errorlog?

Can you explain more how you see that I/O subsystem isn't reading pages correctly.

All the information you posted shows that page (1:38), which SQL Server complained was corrupt, isn't actually corrupt.

How to run I/O subsystem diagnostics and check for all firmware levels

Paul Randal One Orange Chip Points: 29544 More actions · Answer 6

You don't *have* to turn it off because it's going to do anything bad to your system, but you can if you want to. It's easier to have output come to the console rather than have to go looking in the error log every time you run a DBCC PAGE command.

The page was corrupt as far as SQL Server was concerned that one time, because the I/O subsystem did not return the correct data from disk. This is not a SQL Server problem and is sometimes called a stale-read.

You need to figure out how to run diagnostics on your I/O subsystem yourself - if you don't know, call your hardware vendor to help you.

Again, this isn't a SQL Server problem - it's you I/O hardware. There's nothing more we can help you with here.

Thanks

Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005

Krasavita SSC-Insane Points: 23138 More actions · Answer 7

What is this mean:

DBCC results for 'sysusers'.

There are 31 rows in 1 pages for object 'sysusers'.

Paul Randal One Orange Chip Points: 29544 More actions · Answer 8

It's kind of self-explanataory - the sysusers table has 31 rows that are stored in one page.

Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005

Krasavita SSC-Insane Points: 23138 More actions · Answer 9

I am sorry to ask a a stuped question,but I want to know is id good that is contains 31 rows in a page?

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 10

Krasavita (10/9/2009)
I am sorry to ask a a stuped question,but I want to know is id good that is contains 31 rows in a page?

It's not good or bad. It's just a fact. Like saying that an encyclopedia has 5000 pages spread across 5 volumes. It's just telling you how many rows are in the table (31) and how many pages the table occupies (1)

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Krasavita SSC-Insane Points: 23138 More actions · Answer 11

Thank you very much, why did I need to check for it if my db got corrupted?

Also,

What is this mean? I know that is Shows all pages in use by indexes of the specified table,but by looking at these results how do you know what's wrong? Thank you again

DBCC IND (dbname, sysusers, -1)

PageFID PagePID IAMFID IAMPID ObjectID IndexID PageType IndexLevel NextPageFID

1 39 NULL NULL 10 1 10 0 0

1 38 1 39 10 1 2 0 0

1 40 1 39 10 0 1 0 0

1 42 NULL NULL 10 2 10 0 0

1 41 1 42 10 2 2 0 0

1 44 NULL NULL 10 3 10 0 0

1 43 1 44 10 3 2 0 0

NextPagePID PrevPageFID PrevPagePID

0 0 0

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 12

Krasavita (10/9/2009)
Thank you very much, why did I need to check for it if my db got corrupted?

It was the table that was referred to in the error. Guess Paul wanted to know how many total pages there were in the table.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Krasavita SSC-Insane Points: 23138 More actions · Answer 13

Another question:

I ran:

DBCC TRACEON (3604)

DBCC PAGE (yourdb, 1, 38, 2)

Please explain 1, 38, 2 what these numbers mean. Thank you

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 14

FileID, Page Number, Display mode

If you want to know about DBCC PAGE and DBCC IND, go read Paul's blog. He's written pages on them.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Krasavita SSC-Insane Points: 23138 More actions · Answer 15

By looking at my results by DBCC page how do you see there is a problem????