Database / DBCC Help!!! - SQL Server Forums

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

Database / DBCC Help!!!

Author

Topic

tcasey@eaccp.net
Starting Member

2 Posts

Posted - 2008-06-06 : 11:51:53

I have a one database that appears to have some corruption but being new to SQL 2005 I can't seem to find the problem, only a bunch of stack dumps and DBCC doesn't appear to return the results I would expect.

DBCC CHECKDB (MYDB) WITH ALL_ERRORMSGS, NO-INFOMSGS

Msg 211, Level 23, State 51, Line 2
Possible schema corruption. Ru DBCC CheckCatalog.
Msg 0, level 20, State 0, line 0
A severe error occurred on the current command. The results should be discard

DBCC CHECKCATALOG (MYDB)

DBCC execution completed. If DBCC printed error messages, contact your system administrator

Stack Dump

06/06/2008 08:45:58,spid187,Unknown,External dump process return code 0x20000001.<nl/>External dump process returned no errors.
06/06/2008 08:45:56,spid187,Unknown,Stack Signature for the dump is 0x4E678B02
06/06/2008 08:45:56,spid187,Unknown,* -------------------------------------------------------------------------------
06/06/2008 08:45:56,spid187,Unknown,78132A47 Module(MSVCR80+00002A47)
06/06/2008 08:45:56,spid187,Unknown,781329BB Module(MSVCR80+000029BB)
06/06/2008 08:45:56,spid187,Unknown,010B9201 Module(sqlservr+000B9201)
06/06/2008 08:45:56,spid187,Unknown,010B9064 Module(sqlservr+000B9064)
06/06/2008 08:45:56,spid187,Unknown,010B939C Module(sqlservr+000B939C)
06/06/2008 08:45:56,spid187,Unknown,010B94A5 Module(sqlservr+000B94A5)
06/06/2008 08:45:56,spid187,Unknown,010075DC Module(sqlservr+000075DC)
06/06/2008 08:45:56,spid187,Unknown,010078CC Module(sqlservr+000078CC)
06/06/2008 08:45:56,spid187,Unknown,010077A6 Module(sqlservr+000077A6)
06/06/2008 08:45:56,spid187,Unknown,0102F1F4 Module(sqlservr+0002F1F4)
06/06/2008 08:45:56,spid187,Unknown,01032A36 Module(sqlservr+00032A36)
06/06/2008 08:45:56,spid187,Unknown,01028600 Module(sqlservr+00028600)
06/06/2008 08:45:56,spid187,Unknown,0134752A Module(sqlservr+0034752A)
06/06/2008 08:45:56,spid187,Unknown,01430633 Module(sqlservr+00430633)
06/06/2008 08:45:56,spid187,Unknown,01346B6B Module(sqlservr+00346B6B)
06/06/2008 08:45:56,spid187,Unknown,013A929A Module(sqlservr+003A929A)
06/06/2008 08:45:56,spid187,Unknown,01368BB2 Module(sqlservr+00368BB2)
06/06/2008 08:45:56,spid187,Unknown,013A9BDC Module(sqlservr+003A9BDC)
06/06/2008 08:45:56,spid187,Unknown,013A9A04 Module(sqlservr+003A9A04)
06/06/2008 08:45:56,spid187,Unknown,0131F5C0 Module(sqlservr+0031F5C0)
06/06/2008 08:45:56,spid187,Unknown,013A9A04 Module(sqlservr+003A9A04)
06/06/2008 08:45:56,spid187,Unknown,0131F721 Module(sqlservr+0031F721)
06/06/2008 08:45:56,spid187,Unknown,01320085 Module(sqlservr+00320085)
06/06/2008 08:45:56,spid187,Unknown,013A9A04 Module(sqlservr+003A9A04)
06/06/2008 08:45:56,spid187,Unknown,01369B63 Module(sqlservr+00369B63)
06/06/2008 08:45:56,spid187,Unknown,0136A2D8 Module(sqlservr+0036A2D8)
06/06/2008 08:45:56,spid187,Unknown,0136A1B4 Module(sqlservr+0036A1B4)
06/06/2008 08:45:56,spid187,Unknown,0136A071 Module(sqlservr+0036A071)
06/06/2008 08:45:56,spid187,Unknown,013AD9F3 Module(sqlservr+003AD9F3)
06/06/2008 08:45:56,spid187,Unknown,013AD7EB Module(sqlservr+003AD7EB)
06/06/2008 08:45:56,spid187,Unknown,013AD6FB Module(sqlservr+003AD6FB)
06/06/2008 08:45:56,spid187,Unknown,013B50A3 Module(sqlservr+003B50A3)
06/06/2008 08:45:56,spid187,Unknown,012FB17F Module(sqlservr+002FB17F)
06/06/2008 08:45:56,spid187,Unknown,012FBE95 Module(sqlservr+002FBE95)
06/06/2008 08:45:56,spid187,Unknown,012FBDDB Module(sqlservr+002FBDDB)
06/06/2008 08:45:56,spid187,Unknown,011A06A5 Module(sqlservr+001A06A5)
06/06/2008 08:45:56,spid187,Unknown,01482AB3 Module(sqlservr+00482AB3)
06/06/2008 08:45:56,spid187,Unknown,01443470 Module(sqlservr+00443470)
06/06/2008 08:45:56,spid187,Unknown,015BFA3D Module(sqlservr+005BFA3D)
06/06/2008 08:45:56,spid187,Unknown,021A642D Module(sqlservr+011A642D)
06/06/2008 08:45:56,spid187,Unknown,021A6880 Module(sqlservr+011A6880)
06/06/2008 08:45:56,spid187,Unknown,021A29C4 Module(sqlservr+011A29C4)
06/06/2008 08:45:56,spid187,Unknown,77E4BEE7 Module(kernel32+0000BEE7)
06/06/2008 08:45:56,spid187,Unknown,* Short Stack Dump
06/06/2008 08:45:56,spid187,Unknown,* -------------------------------------------------------------------------------
06/06/2008 08:45:56,spid187,Unknown,* *******************************************************************************
06/06/2008 08:45:56,spid187,Unknown,* SegSs: 78130023: 00000000 00000000 00000000 00000000 00000000 00000000
06/06/2008 08:45:56,spid187,Unknown,* Esp: 664DD540: 0B74D5C0 000042AC 00000000 00000000 77E4BEE7 00000000
06/06/2008 08:45:56,spid187,Unknown,* EFlags: 00000246:
06/06/2008 08:45:56,spid187,Unknown,* SegCs: 664D001B: 00000000 00000100 FFFFFE00 FFFFFFFF FFFFFFFF FFFFFFFF
06/06/2008 08:45:56,spid187,Unknown,* Ebp: 664DD594: 664DD5D8 021A29C4 000042AC 00000000 00000000 00000000
06/06/2008 08:45:56,spid187,Unknown,* Eip: 77E4BEE7: 10C2C95E 01093D00 840FC000 00000095 F29DE950 9090FFFF
06/06/2008 08:45:56,spid187,Unknown,* Edx: FFFFFFFF:
06/06/2008 08:45:56,spid187,Unknown,* Ecx: 664DDBB4: 00000000 00010007 00000000 0090008E 65153AFC 664DD574
06/06/2008 08:45:56,spid187,Unknown,* Ebx: FFFFFFFF:
06/06/2008 08:45:56,spid187,Unknown,* Eax: 664DD544: 000042AC 00000000 00000000 77E4BEE7 00000000 7C82771B
06/06/2008 08:45:56,spid187,Unknown,* Esi: 00000000:
06/06/2008 08:45:56,spid187,Unknown,* Edi: 664DD660: 65153AF8 664DD684 01006176 664DD684 0100617E 027E5570
06/06/2008 08:45:56,spid187,Unknown,*
06/06/2008 08:45:56,spid187,Unknown,* dbghelp 66BE0000 66CF4FFF 00115000
06/06/2008 08:45:56,spid187,Unknown,* OLEDB32R 63D60000 63D70FFF 00011000
06/06/2008 08:45:56,spid187,Unknown,* MSDART 63C10000 63C29FFF 0001a000
06/06/2008 08:45:56,spid187,Unknown,* oledb32 64090000 64108FFF 00079000
06/06/2008 08:45:56,spid187,Unknown,* xplog70 64730000 64732FFF 00003000
06/06/2008 08:45:56,spid187,Unknown,* xplog70 64710000 6471BFFF 0000c000
06/06/2008 08:45:56,spid187,Unknown,* xpstar90 645E0000 64605FFF 00026000
06/06/2008 08:45:56,spid187,Unknown,* odbcint 645C0000 645D6FFF 00017000
06/06/2008 08:45:56,spid187,Unknown,* ATL80 7C630000 7C64AFFF 0001b000
06/06/2008 08:45:56,spid187,Unknown,* BatchParser90 643D0000 643EEFFF 0001f000
06/06/2008 08:45:56,spid187,Unknown,* ODBC32 64390000 643CCFFF 0003d000
06/06/2008 08:45:56,spid187,Unknown,* SQLSCM90 64370000 64378FFF 00009000
06/06/2008 08:45:56,spid187,Unknown,* xpstar90 64310000 64358FFF 00049000
06/06/2008 08:45:56,spid187,Unknown,* xpsqlbot 642F0000 642F5FFF 00006000
06/06/2008 08:45:56,spid187,Unknown,* msftepxy 637C0000 637D4FFF 00015000
06/06/2008 08:45:56,spid187,Unknown,* SQLNCLIR 007C0000 007F2FFF 00033000
06/06/2008 08:45:56,spid187,Unknown,* comdlg32 762B0000 762F8FFF 00049000
06/06/2008 08:45:56,spid187,Unknown,* COMCTL32 77530000 775C6FFF 00097000
06/06/2008 08:45:56,spid187,Unknown,* sqlncli 63410000 63633FFF 00224000
06/06/2008 08:45:56,spid187,Unknown,* CLBCatQ 777B0000 77832FFF 00083000
06/06/2008 08:45:56,spid187,Unknown,* xpsp2res 63140000 63404FFF 002c5000
06/06/2008 08:45:56,spid187,Unknown,* ntdsapi 766F0000 76703FFF 00014000
06/06/2008 08:45:56,spid187,Unknown,* SAMLIB 7E020000 7E02EFFF 0000f000
06/06/2008 08:45:56,spid187,Unknown,* NTMARTA 77E00000 77E20FFF 00021000
06/06/2008 08:45:56,spid187,Unknown,* wshtcpip 71AE0000 71AE7FFF 00008000
06/06/2008 08:45:56,spid187,Unknown,* hnetcfg 62FA0000 62FF9FFF 0005a000
06/06/2008 08:45:56,spid187,Unknown,* dssenh 68100000 68126FFF 00027000
06/06/2008 08:45:56,spid187,Unknown,* imagehlp 76C10000 76C37FFF 00028000
06/06/2008 08:45:56,spid187,Unknown,* WINTRUST 76BB0000 76BDAFFF 0002b000
06/06/2008 08:45:56,spid187,Unknown,* dbghelp 62BB0000 62CC4FFF 00115000
06/06/2008 08:45:56,spid187,Unknown,* msfte 62950000 62BA8FFF 00259000
06/06/2008 08:45:56,spid187,Unknown,* security 62280000 62283FFF 00004000
06/06/2008 08:45:56,spid187,Unknown,* rasadhlp 76F80000 76F84FFF 00005000
06/06/2008 08:45:56,spid187,Unknown,* WLDAP32 76F10000 76F3DFFF 0002e000
06/06/2008 08:45:56,spid187,Unknown,* winrnr 76F70000 76F76FFF 00007000
06/06/2008 08:45:56,spid187,Unknown,* DNSAPI 76ED0000 76EF9FFF 0002a000
06/06/2008 08:45:56,spid187,Unknown,* RESUTILS 61E30000 61E42FFF 00013000
06/06/2008 08:45:56,spid187,Unknown,* CLUSAPI 61E10000 61E21FFF 00012000
06/06/2008 08:45:56,spid187,Unknown,* WSOCK32 71BB0000 71BB8FFF 00009000
06/06/2008 08:45:56,spid187,Unknown,* VERSION 77B90000 77B97FFF 00008000
06/06/2008 08:45:56,spid187,Unknown,* MTXCLU 61DF0000 61E08FFF 00019000
06/06/2008 08:45:56,spid187,Unknown,* msvcp60 61D80000 61DE4FFF 00065000
06/06/2008 08:45:56,spid187,Unknown,* OLEAUT32 77D00000 77D8AFFF 0008b000
06/06/2008 08:45:56,spid187,Unknown,* MSDTCPRX 61D00000 61D78FFF 00079000
06/06/2008 08:45:56,spid187,Unknown,* XOLEHLP 61CF0000 61CF5FFF 00006000
06/06/2008 08:45:56,spid187,Unknown,* COMRES 77010000 770D5FFF 000c6000
06/06/2008 08:45:56,spid187,Unknown,* schannel 76750000 76776FFF 00027000
06/06/2008 08:45:56,spid187,Unknown,* cryptdll 766E0000 766EBFFF 0000c000
06/06/2008 08:45:56,spid187,Unknown,* kerberos 61C40000 61C97FFF 00058000
06/06/2008 08:45:56,spid187,Unknown,* iphlpapi 76CF0000 76D09FFF 0001a000
06/06/2008 08:45:56,spid187,Unknown,* msv1_0 76C90000 76CB6FFF 00027000
06/06/2008 08:45:56,spid187,Unknown,* ole32 77670000 777A8FFF 00139000
06/06/2008 08:45:56,spid187,Unknown,* MSCOREE 34200000 34245FFF 00046000
06/06/2008 08:45:56,spid187,Unknown,* AUTHZ 76C40000 76C53FFF 00014000
06/06/2008 08:45:56,spid187,Unknown,* rsaenh 68000000 68034FFF 00035000
06/06/2008 08:45:56,spid187,Unknown,* SQLOS 344D0000 344D4FFF 00005000
06/06/2008 08:45:56,spid187,Unknown,* sqlevn70 4F610000 4F7B8FFF 001a9000
06/06/2008 08:45:56,spid187,Unknown,* instapi 48060000 48069FFF 0000a000
06/06/2008 08:45:56,spid187,Unknown,* psapi 76B70000 76B7AFFF 0000b000
06/06/2008 08:45:56,spid187,Unknown,* comctl32 77420000 77522FFF 00103000
06/06/2008 08:45:56,spid187,Unknown,* SHLWAPI 77DA0000 77DF1FFF 00052000
06/06/2008 08:45:56,spid187,Unknown,* SHELL32 7C8D0000 7D0CEFFF 007ff000
06/06/2008 08:45:56,spid187,Unknown,* NETAPI32 71C40000 71C96FFF 00057000
06/06/2008 08:45:56,spid187,Unknown,* opends60 333E0000 333E6FFF 00007000
06/06/2008 08:45:56,spid187,Unknown,* USERENV 76920000 769E1FFF 000c2000
06/06/2008 08:45:56,spid187,Unknown,* WS2HELP 71BF0000 71BF7FFF 00008000
06/06/2008 08:45:56,spid187,Unknown,* WS2_32 71C00000 71C16FFF 00017000
06/06/2008 08:45:56,spid187,Unknown,* MSWSOCK 71B20000 71B60FFF 00041000
06/06/2008 08:45:56,spid187,Unknown,* MSASN1 76190000 761A1FFF 00012000
06/06/2008 08:45:56,spid187,Unknown,* CRYPT32 761B0000 76242FFF 00093000
06/06/2008 08:45:56,spid187,Unknown,* GDI32 77C00000 77C47FFF 00048000
06/06/2008 08:45:56,spid187,Unknown,* USER32 77380000 77410FFF 00091000
06/06/2008 08:45:56,spid187,Unknown,* Secur32 76F50000 76F62FFF 00013000
06/06/2008 08:45:56,spid187,Unknown,* RPCRT4 77C50000 77CEEFFF 0009f000
06/06/2008 08:45:56,spid187,Unknown,* ADVAPI32 77F50000 77FEAFFF 0009b000
06/06/2008 08:45:56,spid187,Unknown,* MSVCP80 7C420000 7C4A6FFF 00087000
06/06/2008 08:45:56,spid187,Unknown,* msvcrt 77BA0000 77BF9FFF 0005a000
06/06/2008 08:45:56,spid187,Unknown,* MSVCR80 78130000 781CAFFF 0009b000
06/06/2008 08:45:56,spid187,Unknown,* kernel32 77E40000 77F41FFF 00102000
06/06/2008 08:45:56,spid187,Unknown,* ntdll 7C800000 7C8BFFFF 000c0000
06/06/2008 08:45:56,spid187,Unknown,* sqlservr 01000000 02C09FFF 01c0a000
06/06/2008 08:45:56,spid187,Unknown,* MODULE BASE END SIZE
06/06/2008 08:45:56,spid187,Unknown,*
06/06/2008 08:45:56,spid187,Unknown,*
06/06/2008 08:45:56,spid187,Unknown,* 04 04 00 00 00 00
06/06/2008 08:45:56,spid187,Unknown,* h r e s h o l d & 68 00 72 00 65 00 73 00 68 00 6f 00 6c 00 64 00 00 26
06/06/2008 08:45:56,spid187,Unknown,* T h r o t t l e T 54 00 68 00 72 00 6f 00 74 00 74 00 6c 00 65 00 54 00
06/06/2008 08:45:56,spid187,Unknown,* i z e & d @ 00 69 00 7a 00 65 00 00 26 04 04 64 00 00 00 12 40 00
06/06/2008 08:45:56,spid187,Unknown,* M a x F e t c h S 00 4d 00 61 00 78 00 46 00 65 00 74 00 63 00 68 00 53
06/06/2008 08:45:56,spid187,Unknown,* I d ç ÿÿ @ 00 49 00 64 00 00 e7 02 00 09 04 10 00 00 ff ff 0d 40
06/06/2008 08:45:56,spid187,Unknown,* É µ @ B a t c h 00 a0 c9 0a b5 0f 08 40 00 42 00 61 00 74 00 63 00 68
06/06/2008 08:45:56,spid187,Unknown,* p e $ ßê½eÂÐ ¼í 70 00 65 00 00 24 10 10 17 df ea bd 65 c2 d0 11 bc ed
06/06/2008 08:45:56,spid187,Unknown,* o r k I t e m T y 6f 00 72 00 6b 00 49 00 74 00 65 00 6d 00 54 00 79 00
06/06/2008 08:45:56,spid187,Unknown,* d ç ÿÿ @ W 64 00 00 e7 02 00 09 04 10 00 00 ff ff 0d 40 00 57 00
06/06/2008 08:45:56,spid187,Unknown,* å ô« @ S i t e I e5 80 f4 ab 15 07 40 00 53 00 69 00 74 00 65 00 49 00
06/06/2008 08:45:56,spid187,Unknown,* d $ & Ç¾´Ó>KµÍX 00 64 00 00 24 10 10 26 06 c7 be b4 d3 3e 4b b5 cd 58
06/06/2008 08:45:56,spid187,Unknown,* o c e s s i n g I 00 6f 00 63 00 65 00 73 00 73 00 69 00 6e 00 67 00 49
06/06/2008 08:45:56,spid187,Unknown,* I t e m s @ P r 49 00 74 00 65 00 6d 00 73 00 00 00 0d 40 00 50 00 72
06/06/2008 08:45:56,spid187,Unknown,* n a b l e W o r k 6e 00 61 00 62 00 6c 00 65 00 57 00 6f 00 72 00 6b 00
06/06/2008 08:45:56,spid187,Unknown,* o c _ G e t R u n 6f 00 63 00 5f 00 47 00 65 00 74 00 52 00 75 00 6e 00
06/06/2008 08:45:56,spid187,Unknown,* d b o . p r 01 00 00 00 1d 00 64 00 62 00 6f 00 2e 00 70 00 72 00
06/06/2008 08:45:56,spid187,Unknown,* 16 00 00 00 12 00 00 00 02 00 00 00 00 00 00 00 00 00
06/06/2008 08:45:56,spid187,Unknown,* Input Buffer 255 bytes -
06/06/2008 08:45:56,spid187,Unknown,*
06/06/2008 08:45:56,spid187,Unknown,* ex_raise2: Exception raised<c/> major=2<c/> minor=11<c/> state=51<c/> severity=23
06/06/2008 08:45:56,spid187,Unknown,*
06/06/2008 08:45:56,spid187,Unknown,* 06/06/08 08:45:56 spid 187
06/06/2008 08:45:56,spid187,Unknown,* BEGIN STACK DUMP:
06/06/2008 08:45:56,spid187,Unknown,*
06/06/2008 08:45:56,spid187,Unknown,* *******************************************************************************
06/06/2008 08:45:56,spid187,Unknown,***Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLDump9210.txt
06/06/2008 08:45:56,spid187,Unknown,*
06/06/2008 08:45:56,spid187,Unknown,* User initiated stack dump. This is not a server exception dump.
06/06/2008 08:45:56,spid187,Unknown,*
06/06/2008 08:45:56,spid187,Unknown,**Dump thread - spid = 187<c/> PSS = 0x0B74D5C0<c/> EC = 0x0B74D5C8
06/06/2008 08:45:56,spid187,Unknown,Using 'dbghelp.dll' version '4.0.5'
06/06/2008 08:45:56,spid187,Unknown,ex_raise2: Exception raised<c/> major=2<c/> minor=11<c/> state=51<c/> severity=23<c/> attempting to create symptom dump

Any help would be greatly appreciated

paulrandal
Yak with Vast SQL Skills

899 Posts

Posted - 2008-06-06 : 15:01:48

This error comes from the metadata layer within the relational engine and indicates something badly corrupt with the various system tables. CHECKDB has asked the metadata layer for some information and the metadata layer has thrown this error.

You could try to narrow down the corruption by doing individual DBCC CHECKTABLEs on all the system tables. Do the following:

SELECT name, object_id FROM sys.objects;

And then run DBCC CHECKTABLE on each of the system tables, making sure to use the 'sys' schema too. For example,

DBCC CHECKTABLE ('sys.syshobts') WITH NO_INFOMSGS, ALL_ERRORMSGS

Thanks

Paul Randal
SQL Server MVP, Managing Director, SQLskills.com

tcasey@eaccp.net
Starting Member

2 Posts

Posted - 2008-06-06 : 15:57:45

We had a power outage the first part of May and my backup generator failed so all of my 20 servers went down dirty, so this probably caused my grief. Unfortunately the problem wasn't found until I started to reconfigure Backup Exec and wasn't able to see the KB count on this and all subsequent databases in the tree.

I ran your query and 1075 rows were returned, so that would have been an all day + project to figure out what was up. The database is used by Sharepoint 3.0 and since we just upgraded from 2.0 there was no real data there, only configuration. I grabbed a back from a month ago and restored. I ran DBCC CHECKDB against the restored database and the results were normal. I really appreciate your fast response and help.

Your page has been bookmarked and shared!

paulrandal
Yak with Vast SQL Skills

899 Posts

Posted - 2008-06-07 : 10:46:59

Glad it worked out.

Sheer luck you got a fast response yesterday - I was in between flights in San Fransisco on the way down to Orlando for TechEd.

Yours is an interesting situation that I rarely see so I'm going to blog about it today with my proposed solution.

Thanks!

Paul Randal
SQL Server MVP, Managing Director, SQLskills.com

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources