Database corruption

Question

Database corruption

chris_wallace_000

SSC-Addicted

Points: 484
More actions
June 22, 2009 at 7:27 am

#384816

Hi all!!
I have a web hosting environment whereby there is an Active / Passive SQL cluster. Last week our main database became marked as 'Suspect'. I have been tasked to identify the underlying cause, but am having great difficulties.
Findings so far:
SQL Error Log:
06/09/2009 10:18:54,spid21s,Unknown,An error occurred during recovery preventing the database 'KentLive' (database ID 8) from restarting. Diagnose the recovery errors and fix them or restore from a known good backup. If errors are not corrected or expected contact Technical Support.
06/09/2009 10:18:54,spid21s,Unknown,Error: 3414 Severity: 21 State: 1.
06/09/2009 10:18:54,spid21s,Unknown,During redoing of a logged operation in database 'KentLive' an error occurred at log record ID (24550:433:46). Typically the specific failure is previously logged as an error in the Windows Event Log service. Restore the database from a full backup or repair the database.
06/09/2009 10:18:54,spid21s,Unknown,Error: 3313 Severity: 21 State: 2.
06/09/2009 10:18:53,spid21s,Unknown,External dump process return code 0x20000001.External dump process returned no errors.
06/09/2009 10:18:53,spid21s,Unknown,Stack Signature for the dump is 0xEDB185D2
06/09/2009 10:18:53,spid21s,Unknown,* -------------------------------------------------------------------------------
06/09/2009 10:18:53,spid21s,Unknown,78132A36 Module(MSVCR80+00002A36)
06/09/2009 10:18:53,spid21s,Unknown,781329AA Module(MSVCR80+000029AA)
06/09/2009 10:18:53,spid21s,Unknown,010B9201 Module(sqlservr+000B9201)
06/09/2009 10:18:53,spid21s,Unknown,010B9064 Module(sqlservr+000B9064)
06/09/2009 10:18:53,spid21s,Unknown,010B939C Module(sqlservr+000B939C)
06/09/2009 10:18:53,spid21s,Unknown,010B94A5 Module(sqlservr+000B94A5)
06/09/2009 10:18:53,spid21s,Unknown,010075DC Module(sqlservr+000075DC)
06/09/2009 10:18:53,spid21s,Unknown,010078CC Module(sqlservr+000078CC)
06/09/2009 10:18:53,spid21s,Unknown,010077A6 Module(sqlservr+000077A6)
06/09/2009 10:18:53,spid21s,Unknown,0240D8A3 Module(sqlservr+0140D8A3)
06/09/2009 10:18:53,spid21s,Unknown,01087CB1 Module(sqlservr+00087CB1)
06/09/2009 10:18:53,spid21s,Unknown,0108701A Module(sqlservr+0008701A)
06/09/2009 10:18:53,spid21s,Unknown,01086D06 Module(sqlservr+00086D06)
06/09/2009 10:18:53,spid21s,Unknown,02100ACA Module(sqlservr+01100ACA)
06/09/2009 10:18:53,spid21s,Unknown,020F564A Module(sqlservr+010F564A)
06/09/2009 10:18:53,spid21s,Unknown,020E97AF Module(sqlservr+010E97AF)
06/09/2009 10:18:53,spid21s,Unknown,020FD621 Module(sqlservr+010FD621)
06/09/2009 10:18:53,spid21s,Unknown,021D4A9F Module(sqlservr+011D4A9F)
06/09/2009 10:18:53,spid21s,Unknown,021C4CA3 Module(sqlservr+011C4CA3)
06/09/2009 10:18:53,spid21s,Unknown,021CA334 Module(sqlservr+011CA334)
06/09/2009 10:18:53,spid21s,Unknown,021D2241 Module(sqlservr+011D2241)
06/09/2009 10:18:53,spid21s,Unknown,0215784A Module(sqlservr+0115784A)
06/09/2009 10:18:53,spid21s,Unknown,0106E9EF Module(sqlservr+0006E9EF)
06/09/2009 10:18:53,spid21s,Unknown,023C3298 Module(sqlservr+013C3298)
06/09/2009 10:18:53,spid21s,Unknown,01443470 Module(sqlservr+00443470)
06/09/2009 10:18:53,spid21s,Unknown,015BFA3D Module(sqlservr+005BFA3D)
06/09/2009 10:18:53,spid21s,Unknown,021A642D Module(sqlservr+011A642D)
06/09/2009 10:18:53,spid21s,Unknown,021A6880 Module(sqlservr+011A6880)
06/09/2009 10:18:53,spid21s,Unknown,021A29C4 Module(sqlservr+011A29C4)
06/09/2009 10:18:53,spid21s,Unknown,77E4BEE7 Module(kernel32+0000BEE7)
06/09/2009 10:18:53,spid21s,Unknown,* Short Stack Dump
06/09/2009 10:18:53,spid21s,Unknown,* -------------------------------------------------------------------------------
06/09/2009 10:18:53,spid21s,Unknown,* *******************************************************************************
06/09/2009 10:18:53,spid21s,Unknown,* SegSs: 78130023: 00000000 00000000 00000000 00000000 00000000 00000000
06/09/2009 10:18:53,spid21s,Unknown,* Esp: 6392A7A8: 52BB07D8 000042AC 00000000 00000000 77E4BEE7 00000000
06/09/2009 10:18:53,spid21s,Unknown,* EFlags: 00000246:
06/09/2009 10:18:53,spid21s,Unknown,* SegCs: 0000001B:
06/09/2009 10:18:53,spid21s,Unknown,* Ebp: 6392A7FC: 6392A840 021A29C4 000042AC 00000000 00000000 00000000
06/09/2009 10:18:53,spid21s,Unknown,* Eip: 77E4BEE7: 10C2C95E 01093D00 840FC000 00000095 F29DE950 9090FFFF
06/09/2009 10:18:53,spid21s,Unknown,* Edx: FFFFFFFF:
06/09/2009 10:18:53,spid21s,Unknown,* Ecx: 6392AE1C: 00000000 00010007 00000000 00740072 0015941C 6392A7DC
06/09/2009 10:18:53,spid21s,Unknown,* Ebx: FFFFFFFF:
06/09/2009 10:18:53,spid21s,Unknown,* Eax: 6392A7AC: 000042AC 00000000 00000000 77E4BEE7 00000000 7C82771B
06/09/2009 10:18:53,spid21s,Unknown,* Esi: 00000000:
06/09/2009 10:18:53,spid21s,Unknown,* Edi: 6392A8C8: 00159418 006C0069 00730065 004D005C 00630069 006F0072
06/09/2009 10:18:53,spid21s,Unknown,*
06/09/2009 10:18:53,spid21s,Unknown,* dbghelp 646E0000 647F4FFF 00115000
06/09/2009 10:18:53,spid21s,Unknown,* xplog70 642B0000 642B2FFF 00003000
06/09/2009 10:18:53,spid21s,Unknown,* xplog70 64290000 6429BFFF 0000c000
06/09/2009 10:18:53,spid21s,Unknown,* xpstar90 64260000 64285FFF 00026000
06/09/2009 10:18:53,spid21s,Unknown,* odbcint 64140000 64156FFF 00017000
06/09/2009 10:18:53,spid21s,Unknown,* ATL80 7C630000 7C64AFFF 0001b000
06/09/2009 10:18:53,spid21s,Unknown,* BatchParser90 63F50000 63F6EFFF 0001f000
06/09/2009 10:18:53,spid21s,Unknown,* ODBC32 63F10000 63F4CFFF 0003d000
06/09/2009 10:18:53,spid21s,Unknown,* SQLSCM90 63EF0000 63EF8FFF 00009000
06/09/2009 10:18:53,spid21s,Unknown,* xpstar90 63E90000 63ED8FFF 00049000
06/09/2009 10:18:53,spid21s,Unknown,* xpsqlbot 63E70000 63E75FFF 00006000
06/09/2009 10:18:53,spid21s,Unknown,* msftepxy 00950000 00964FFF 00015000
06/09/2009 10:18:53,spid21s,Unknown,* SQLNCLIR 00910000 00942FFF 00033000
06/09/2009 10:18:53,spid21s,Unknown,* comdlg32 762B0000 762F8FFF 00049000
06/09/2009 10:18:53,spid21s,Unknown,* COMCTL32 77530000 775C6FFF 00097000
06/09/2009 10:18:53,spid21s,Unknown,* sqlncli 63480000 636A3FFF 00224000
06/09/2009 10:18:53,spid21s,Unknown,* CLBCatQ 777B0000 77832FFF 00083000
06/09/2009 10:18:53,spid21s,Unknown,* xpsp2res 631B0000 63474FFF 002c5000
06/09/2009 10:18:53,spid21s,Unknown,* ntdsapi 766F0000 76703FFF 00014000
06/09/2009 10:18:53,spid21s,Unknown,* SAMLIB 7E020000 7E02EFFF 0000f000
06/09/2009 10:18:53,spid21s,Unknown,* NTMARTA 77E00000 77E20FFF 00021000
06/09/2009 10:18:53,spid21s,Unknown,* dssenh 68100000 68126FFF 00027000
06/09/2009 10:18:53,spid21s,Unknown,* imagehlp 76C10000 76C37FFF 00028000
06/09/2009 10:18:53,spid21s,Unknown,* WINTRUST 76BB0000 76BDAFFF 0002b000
06/09/2009 10:18:53,spid21s,Unknown,* dbghelp 62BC0000 62CD4FFF 00115000
06/09/2009 10:18:53,spid21s,Unknown,* msfte 62960000 62BB8FFF 00259000
06/09/2009 10:18:53,spid21s,Unknown,* security 62230000 62233FFF 00004000
06/09/2009 10:18:53,spid21s,Unknown,* wshtcpip 71AE0000 71AE7FFF 00008000
06/09/2009 10:18:53,spid21s,Unknown,* hnetcfg 61CD0000 61D29FFF 0005a000
06/09/2009 10:18:53,spid21s,Unknown,* rasadhlp 76F80000 76F84FFF 00005000
06/09/2009 10:18:53,spid21s,Unknown,* WLDAP32 76F10000 76F3DFFF 0002e000
06/09/2009 10:18:53,spid21s,Unknown,* winrnr 76F70000 76F76FFF 00007000
06/09/2009 10:18:53,spid21s,Unknown,* DNSAPI 76ED0000 76EF9FFF 0002a000
06/09/2009 10:18:53,spid21s,Unknown,* WSOCK32 71BB0000 71BB8FFF 00009000
06/09/2009 10:18:53,spid21s,Unknown,* VERSION 77B90000 77B97FFF 00008000
06/09/2009 10:18:53,spid21s,Unknown,* MTXCLU 74F40000 74F58FFF 00019000
06/09/2009 10:18:53,spid21s,Unknown,* msvcp60 61BF0000 61C54FFF 00065000
06/09/2009 10:18:53,spid21s,Unknown,* MSDTCPRX 61B70000 61BE8FFF 00079000
06/09/2009 10:18:53,spid21s,Unknown,* XOLEHLP 61B60000 61B65FFF 00006000
06/09/2009 10:18:53,spid21s,Unknown,* COMRES 77010000 770D5FFF 000c6000
06/09/2009 10:18:53,spid21s,Unknown,* schannel 76750000 76776FFF 00027000
06/09/2009 10:18:53,spid21s,Unknown,* cryptdll 766E0000 766EBFFF 0000c000
06/09/2009 10:18:53,spid21s,Unknown,* kerberos 34460000 344B7FFF 00058000
06/09/2009 10:18:53,spid21s,Unknown,* iphlpapi 76CF0000 76D09FFF 0001a000
06/09/2009 10:18:53,spid21s,Unknown,* msv1_0 76C90000 76CB6FFF 00027000
06/09/2009 10:18:53,spid21s,Unknown,* MSCOREE 341F0000 34234FFF 00045000
06/09/2009 10:18:53,spid21s,Unknown,* AUTHZ 76C40000 76C53FFF 00014000
06/09/2009 10:18:53,spid21s,Unknown,* rsaenh 68000000 68034FFF 00035000
06/09/2009 10:18:53,spid21s,Unknown,* SQLOS 344D0000 344D4FFF 00005000
06/09/2009 10:18:53,spid21s,Unknown,* sqlevn70 4F610000 4F7B8FFF 001a9000
06/09/2009 10:18:53,spid21s,Unknown,* RESUTILS 74EF0000 74F02FFF 00013000
06/09/2009 10:18:53,spid21s,Unknown,* OLEAUT32 77D00000 77D8AFFF 0008b000
06/09/2009 10:18:53,spid21s,Unknown,* ole32 77670000 777A8FFF 00139000
06/09/2009 10:18:53,spid21s,Unknown,* CLUSAPI 74DE0000 74DF1FFF 00012000
06/09/2009 10:18:53,spid21s,Unknown,* instapi 48060000 48069FFF 0000a000
06/09/2009 10:18:53,spid21s,Unknown,* psapi 76B70000 76B7AFFF 0000b000
06/09/2009 10:18:53,spid21s,Unknown,* comctl32 77420000 77522FFF 00103000
06/09/2009 10:18:53,spid21s,Unknown,* IMM32 76290000 762ACFFF 0001d000
06/09/2009 10:18:53,spid21s,Unknown,* SHLWAPI 77DA0000 77DF1FFF 00052000
06/09/2009 10:18:53,spid21s,Unknown,* SHELL32 7C8D0000 7D0CDFFF 007fe000
06/09/2009 10:18:53,spid21s,Unknown,* NETAPI32 71C40000 71C96FFF 00057000
06/09/2009 10:18:53,spid21s,Unknown,* opends60 333E0000 333E6FFF 00007000
06/09/2009 10:18:53,spid21s,Unknown,* USERENV 76920000 769E1FFF 000c2000
06/09/2009 10:18:53,spid21s,Unknown,* WS2HELP 71BF0000 71BF7FFF 00008000
06/09/2009 10:18:53,spid21s,Unknown,* WS2_32 71C00000 71C16FFF 00017000
06/09/2009 10:18:53,spid21s,Unknown,* MSWSOCK 71B20000 71B60FFF 00041000
06/09/2009 10:18:53,spid21s,Unknown,* MSASN1 76190000 761A1FFF 00012000
06/09/2009 10:18:53,spid21s,Unknown,* CRYPT32 761B0000 76242FFF 00093000
06/09/2009 10:18:53,spid21s,Unknown,* GDI32 77C00000 77C47FFF 00048000
06/09/2009 10:18:53,spid21s,Unknown,* USER32 77380000 77410FFF 00091000
06/09/2009 10:18:53,spid21s,Unknown,* Secur32 76F50000 76F62FFF 00013000
06/09/2009 10:18:53,spid21s,Unknown,* RPCRT4 77C50000 77CEEFFF 0009f000
06/09/2009 10:18:53,spid21s,Unknown,* ADVAPI32 77F50000 77FEAFFF 0009b000
06/09/2009 10:18:53,spid21s,Unknown,* MSVCP80 7C420000 7C4A6FFF 00087000
06/09/2009 10:18:53,spid21s,Unknown,* msvcrt 77BA0000 77BF9FFF 0005a000
06/09/2009 10:18:53,spid21s,Unknown,* MSVCR80 78130000 781CAFFF 0009b000
06/09/2009 10:18:53,spid21s,Unknown,* kernel32 77E40000 77F41FFF 00102000
06/09/2009 10:18:53,spid21s,Unknown,* ntdll 7C800000 7C8BFFFF 000c0000
06/09/2009 10:18:53,spid21s,Unknown,* sqlservr 01000000 02C09FFF 01c0a000
06/09/2009 10:18:53,spid21s,Unknown,* MODULE BASE END SIZE
06/09/2009 10:18:53,spid21s,Unknown,*
06/09/2009 10:18:53,spid21s,Unknown,*
06/09/2009 10:18:53,spid21s,Unknown,*
06/09/2009 10:18:53,spid21s,Unknown,* ex_raise2: Exception raised major=52 minor=42 state=1 severity=22
06/09/2009 10:18:53,spid21s,Unknown,*
06/09/2009 10:18:53,spid21s,Unknown,* 06/09/09 10:18:53 spid 21
06/09/2009 10:18:53,spid21s,Unknown,* BEGIN STACK DUMP:
06/09/2009 10:18:53,spid21s,Unknown,*
06/09/2009 10:18:53,spid21s,Unknown,* *******************************************************************************
06/09/2009 10:18:53,spid21s,Unknown,***Stack Dump being sent to R:\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLDump0378.txt
06/09/2009 10:18:53,spid21s,Unknown,*
06/09/2009 10:18:53,spid21s,Unknown,* User initiated stack dump. This is not a server exception dump.
06/09/2009 10:18:53,spid21s,Unknown,*
06/09/2009 10:18:53,spid21s,Unknown,**Dump thread - spid = 21 PSS = 0x52BB07D8 EC = 0x52BB07E0
06/09/2009 10:18:53,spid21s,Unknown,Using 'dbghelp.dll' version '4.0.5'
06/09/2009 10:18:53,spid21s,Unknown,ex_raise2: Exception raised major=52 minor=42 state=1 severity=22 attempting to create symptom dump
06/09/2009 10:18:53,spid21s,Unknown,An inconsistency was detected during an internal operation in database 'KentLive'(ID:8) on page (1:105040). Please contact technical support. Reference number 6.
06/09/2009 10:18:53,spid21s,Unknown,Error: 5242 Severity: 22 State: 1.
06/09/2009 10:18:53,spid21s,Unknown,External dump process return code 0x20000001.External dump process returned no errors.
06/09/2009 10:18:53,spid21s,Unknown,Stack Signature for the dump is 0xE950A0D6
06/09/2009 10:18:53,spid21s,Unknown,* -------------------------------------------------------------------------------
06/09/2009 10:18:53,spid21s,Unknown,78132A36 Module(MSVCR80+00002A36)
06/09/2009 10:18:53,spid21s,Unknown,781329AA Module(MSVCR80+000029AA)
06/09/2009 10:18:53,spid21s,Unknown,010B9201 Module(sqlservr+000B9201)
06/09/2009 10:18:53,spid21s,Unknown,010B9064 Module(sqlservr+000B9064)
06/09/2009 10:18:53,spid21s,Unknown,010B939C Module(sqlservr+000B939C)
06/09/2009 10:18:53,spid21s,Unknown,010B94A5 Module(sqlservr+000B94A5)
06/09/2009 10:18:53,spid21s,Unknown,010075DC Module(sqlservr+000075DC)
06/09/2009 10:18:53,spid21s,Unknown,010078CC Module(sqlservr+000078CC)
06/09/2009 10:18:53,spid21s,Unknown,010077A6 Module(sqlservr+000077A6)
06/09/2009 10:18:53,spid21s,Unknown,0240D8A3 Module(sqlservr+0140D8A3)
06/09/2009 10:18:53,spid21s,Unknown,01087CB1 Module(sqlservr+00087CB1)
06/09/2009 10:18:53,spid21s,Unknown,0108701A Module(sqlservr+0008701A)
06/09/2009 10:18:53,spid21s,Unknown,01086D06 Module(sqlservr+00086D06)
06/09/2009 10:18:53,spid21s,Unknown,02100ACA Module(sqlservr+01100ACA)
06/09/2009 10:18:53,spid21s,Unknown,020F564A Module(sqlservr+010F564A)
06/09/2009 10:18:53,spid21s,Unknown,020E97AF Module(sqlservr+010E97AF)
06/09/2009 10:18:53,spid21s,Unknown,020FD621 Module(sqlservr+010FD621)
06/09/2009 10:18:53,spid21s,Unknown,021D4A9F Module(sqlservr+011D4A9F)
06/09/2009 10:18:53,spid21s,Unknown,021C4CA3 Module(sqlservr+011C4CA3)
06/09/2009 10:18:53,spid21s,Unknown,021CA199 Module(sqlservr+011CA199)
06/09/2009 10:18:53,spid21s,Unknown,0215F15D Module(sqlservr+0115F15D)
06/09/2009 10:18:53,spid21s,Unknown,0215CA34 Module(sqlservr+0115CA34)
06/09/2009 10:18:53,spid21s,Unknown,0106181A Module(sqlservr+0006181A)
06/09/2009 10:18:53,spid21s,Unknown,0106E9EF Module(sqlservr+0006E9EF)
06/09/2009 10:18:53,spid21s,Unknown,023C3298 Module(sqlservr+013C3298)
06/09/2009 10:18:53,spid21s,Unknown,01443470 Module(sqlservr+00443470)
06/09/2009 10:18:53,spid21s,Unknown,015BFA3D Module(sqlservr+005BFA3D)
06/09/2009 10:18:53,spid21s,Unknown,021A642D Module(sqlservr+011A642D)
06/09/2009 10:18:53,spid21s,Unknown,021A6880 Module(sqlservr+011A6880)
06/09/2009 10:18:53,spid21s,Unknown,021A29C4 Module(sqlservr+011A29C4)
06/09/2009 10:18:53,spid21s,Unknown,77E4BEE7 Module(kernel32+0000BEE7)
06/09/2009 10:18:53,spid21s,Unknown,* Short Stack Dump
06/09/2009 10:18:53,spid21s,Unknown,* -------------------------------------------------------------------------------
06/09/2009 10:18:53,spid21s,Unknown,* *******************************************************************************
06/09/2009 10:18:53,spid21s,Unknown,* SegSs: 78130023: 00000000 00000000 00000000 00000000 00000000 00000000
06/09/2009 10:18:53,spid21s,Unknown,* Esp: 6392B950: 52BB07D8 000042AC 00000000 00000000 77E4BEE7 00000000
06/09/2009 10:18:53,spid21s,Unknown,* EFlags: 00000246:
06/09/2009 10:18:53,spid21s,Unknown,* SegCs: 0000001B:
06/09/2009 10:18:53,spid21s,Unknown,* Ebp: 6392B9A4: 6392B9E8 021A29C4 000042AC 00000000 00000000 00000000
06/09/2009 10:18:53,spid21s,Unknown,* Eip: 77E4BEE7: 10C2C95E 01093D00 840FC000 00000095 F29DE950 9090FFFF
06/09/2009 10:18:53,spid21s,Unknown,* Edx: FFFFFFFF:
06/09/2009 10:18:53,spid21s,Unknown,* Ecx: 6392BFC4: 00000000 00010007 00000000 00740072 00185D5C 6392B984
06/09/2009 10:18:53,spid21s,Unknown,* Ebx: FFFFFFFF:
06/09/2009 10:18:53,spid21s,Unknown,* Eax: 6392B954: 000042AC 00000000 00000000 77E4BEE7 00000000 7C82771B
06/09/2009 10:18:53,spid21s,Unknown,* Esi: 00000000:
06/09/2009 10:18:53,spid21s,Unknown,* Edi: 6392BA70: 00185D58 00000000 00000000 00000000 00000000 00000000
06/09/2009 10:18:53,spid21s,Unknown,*
06/09/2009 10:18:53,spid21s,Unknown,* dbghelp 646E0000 647F4FFF 00115000
06/09/2009 10:18:53,spid21s,Unknown,* xplog70 642B0000 642B2FFF 00003000
06/09/2009 10:18:53,spid21s,Unknown,* xplog70 64290000 6429BFFF 0000c000
06/09/2009 10:18:53,spid21s,Unknown,* xpstar90 64260000 64285FFF 00026000
06/09/2009 10:18:53,spid21s,Unknown,* odbcint 64140000 64156FFF 00017000
06/09/2009 10:18:53,spid21s,Unknown,* ATL80 7C630000 7C64AFFF 0001b000
06/09/2009 10:18:53,spid21s,Unknown,* BatchParser90 63F50000 63F6EFFF 0001f000
06/09/2009 10:18:53,spid21s,Unknown,* ODBC32 63F10000 63F4CFFF 0003d000
06/09/2009 10:18:53,spid21s,Unknown,* SQLSCM90 63EF0000 63EF8FFF 00009000
06/09/2009 10:18:53,spid21s,Unknown,* xpstar90 63E90000 63ED8FFF 00049000
06/09/2009 10:18:53,spid21s,Unknown,* xpsqlbot 63E70000 63E75FFF 00006000
06/09/2009 10:18:53,spid21s,Unknown,* msftepxy 00950000 00964FFF 00015000
06/09/2009 10:18:53,spid21s,Unknown,* SQLNCLIR 00910000 00942FFF 00033000
06/09/2009 10:18:53,spid21s,Unknown,* comdlg32 762B0000 762F8FFF 00049000
06/09/2009 10:18:53,spid21s,Unknown,* COMCTL32 77530000 775C6FFF 00097000
06/09/2009 10:18:53,spid21s,Unknown,* sqlncli 63480000 636A3FFF 00224000
06/09/2009 10:18:53,spid21s,Unknown,* CLBCatQ 777B0000 77832FFF 00083000
06/09/2009 10:18:53,spid21s,Unknown,* xpsp2res 631B0000 63474FFF 002c5000
06/09/2009 10:18:53,spid21s,Unknown,* ntdsapi 766F0000 76703FFF 00014000
06/09/2009 10:18:53,spid21s,Unknown,* SAMLIB 7E020000 7E02EFFF 0000f000
06/09/2009 10:18:53,spid21s,Unknown,* NTMARTA 77E00000 77E20FFF 00021000
06/09/2009 10:18:53,spid21s,Unknown,* dssenh 68100000 68126FFF 00027000
06/09/2009 10:18:53,spid21s,Unknown,* imagehlp 76C10000 76C37FFF 00028000
06/09/2009 10:18:53,spid21s,Unknown,* WINTRUST 76BB0000 76BDAFFF 0002b000
06/09/2009 10:18:53,spid21s,Unknown,* dbghelp 62BC0000 62CD4FFF 00115000
06/09/2009 10:18:53,spid21s,Unknown,* msfte 62960000 62BB8FFF 00259000
06/09/2009 10:18:53,spid21s,Unknown,* security 62230000 62233FFF 00004000
06/09/2009 10:18:53,spid21s,Unknown,* wshtcpip 71AE0000 71AE7FFF 00008000
06/09/2009 10:18:53,spid21s,Unknown,* hnetcfg 61CD0000 61D29FFF 0005a000
06/09/2009 10:18:53,spid21s,Unknown,* rasadhlp 76F80000 76F84FFF 00005000
06/09/2009 10:18:53,spid21s,Unknown,* WLDAP32 76F10000 76F3DFFF 0002e000
06/09/2009 10:18:53,spid21s,Unknown,* winrnr 76F70000 76F76FFF 00007000
06/09/2009 10:18:53,spid21s,Unknown,* DNSAPI 76ED0000 76EF9FFF 0002a000
06/09/2009 10:18:53,spid21s,Unknown,* WSOCK32 71BB0000 71BB8FFF 00009000
06/09/2009 10:18:53,spid21s,Unknown,* VERSION 77B90000 77B97FFF 00008000
06/09/2009 10:18:53,spid21s,Unknown,* MTXCLU 74F40000 74F58FFF 00019000
06/09/2009 10:18:53,spid21s,Unknown,* msvcp60 61BF0000 61C54FFF 00065000
06/09/2009 10:18:53,spid21s,Unknown,* MSDTCPRX 61B70000 61BE8FFF 00079000
06/09/2009 10:18:53,spid21s,Unknown,* XOLEHLP 61B60000 61B65FFF 00006000
06/09/2009 10:18:53,spid21s,Unknown,* COMRES 77010000 770D5FFF 000c6000
06/09/2009 10:18:53,spid21s,Unknown,* schannel 76750000 76776FFF 00027000
06/09/2009 10:18:53,spid21s,Unknown,* cryptdll 766E0000 766EBFFF 0000c000
06/09/2009 10:18:53,spid21s,Unknown,* kerberos 34460000 344B7FFF 00058000
06/09/2009 10:18:53,spid21s,Unknown,* iphlpapi 76CF0000 76D09FFF 0001a000
06/09/2009 10:18:53,spid21s,Unknown,* msv1_0 76C90000 76CB6FFF 00027000
06/09/2009 10:18:53,spid21s,Unknown,* MSCOREE 341F0000 34234FFF 00045000
06/09/2009 10:18:53,spid21s,Unknown,* AUTHZ 76C40000 76C53FFF 00014000
06/09/2009 10:18:53,spid21s,Unknown,* rsaenh 68000000 68034FFF 00035000
06/09/2009 10:18:53,spid21s,Unknown,* SQLOS 344D0000 344D4FFF 00005000
06/09/2009 10:18:53,spid21s,Unknown,* sqlevn70 4F610000 4F7B8FFF 001a9000
06/09/2009 10:18:53,spid21s,Unknown,* RESUTILS 74EF0000 74F02FFF 00013000
06/09/2009 10:18:53,spid21s,Unknown,* OLEAUT32 77D00000 77D8AFFF 0008b000
06/09/2009 10:18:53,spid21s,Unknown,* ole32 77670000 777A8FFF 00139000
06/09/2009 10:18:53,spid21s,Unknown,* CLUSAPI 74DE0000 74DF1FFF 00012000
06/09/2009 10:18:53,spid21s,Unknown,* instapi 48060000 48069FFF 0000a000
06/09/2009 10:18:53,spid21s,Unknown,* psapi 76B70000 76B7AFFF 0000b000
06/09/2009 10:18:53,spid21s,Unknown,* comctl32 77420000 77522FFF 00103000
06/09/2009 10:18:53,spid21s,Unknown,* IMM32 76290000 762ACFFF 0001d000
06/09/2009 10:18:53,spid21s,Unknown,* SHLWAPI 77DA0000 77DF1FFF 00052000
06/09/2009 10:18:53,spid21s,Unknown,* SHELL32 7C8D0000 7D0CDFFF 007fe000
06/09/2009 10:18:53,spid21s,Unknown,* NETAPI32 71C40000 71C96FFF 00057000
06/09/2009 10:18:53,spid21s,Unknown,* opends60 333E0000 333E6FFF 00007000
06/09/2009 10:18:53,spid21s,Unknown,* USERENV 76920000 769E1FFF 000c2000
06/09/2009 10:18:53,spid21s,Unknown,* WS2HELP 71BF0000 71BF7FFF 00008000
06/09/2009 10:18:53,spid21s,Unknown,* WS2_32 71C00000 71C16FFF 00017000
06/09/2009 10:18:53,spid21s,Unknown,* MSWSOCK 71B20000 71B60FFF 00041000
06/09/2009 10:18:53,spid21s,Unknown,* MSASN1 76190000 761A1FFF 00012000
06/09/2009 10:18:53,spid21s,Unknown,* CRYPT32 761B0000 76242FFF 00093000
06/09/2009 10:18:53,spid21s,Unknown,* GDI32 77C00000 77C47FFF 00048000
06/09/2009 10:18:53,spid21s,Unknown,* USER32 77380000 77410FFF 00091000
06/09/2009 10:18:53,spid21s,Unknown,* Secur32 76F50000 76F62FFF 00013000
06/09/2009 10:18:53,spid21s,Unknown,* RPCRT4 77C50000 77CEEFFF 0009f000
06/09/2009 10:18:53,spid21s,Unknown,* ADVAPI32 77F50000 77FEAFFF 0009b000
06/09/2009 10:18:53,spid21s,Unknown,* MSVCP80 7C420000 7C4A6FFF 00087000
06/09/2009 10:18:53,spid21s,Unknown,* msvcrt 77BA0000 77BF9FFF 0005a000
06/09/2009 10:18:53,spid21s,Unknown,* MSVCR80 78130000 781CAFFF 0009b000
06/09/2009 10:18:53,spid21s,Unknown,* kernel32 77E40000 77F41FFF 00102000
06/09/2009 10:18:53,spid21s,Unknown,* ntdll 7C800000 7C8BFFFF 000c0000
06/09/2009 10:18:53,spid21s,Unknown,* sqlservr 01000000 02C09FFF 01c0a000
06/09/2009 10:18:53,spid21s,Unknown,* MODULE BASE END SIZE
06/09/2009 10:18:53,spid21s,Unknown,*
06/09/2009 10:18:53,spid21s,Unknown,*
06/09/2009 10:18:53,spid21s,Unknown,*
06/09/2009 10:18:53,spid21s,Unknown,* ex_raise2: Exception raised major=52 minor=42 state=1 severity=22
06/09/2009 10:18:53,spid21s,Unknown,*
06/09/2009 10:18:53,spid21s,Unknown,* 06/09/09 10:18:53 spid 21
06/09/2009 10:18:53,spid21s,Unknown,* BEGIN STACK DUMP:
06/09/2009 10:18:53,spid21s,Unknown,*
06/09/2009 10:18:53,spid21s,Unknown,* *******************************************************************************
06/09/2009 10:18:53,spid21s,Unknown,***Stack Dump being sent to R:\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLDump0377.txt
06/09/2009 10:18:53,spid21s,Unknown,*
06/09/2009 10:18:53,spid21s,Unknown,* User initiated stack dump. This is not a server exception dump.
06/09/2009 10:18:53,spid21s,Unknown,*
06/09/2009 10:18:53,spid21s,Unknown,**Dump thread - spid = 21 PSS = 0x52BB07D8 EC = 0x52BB07E0
06/09/2009 10:18:53,spid21s,Unknown,Using 'dbghelp.dll' version '4.0.5'
06/09/2009 10:18:53,spid21s,Unknown,ex_raise2: Exception raised major=52 minor=42 state=1 severity=22 attempting to create symptom dump
06/09/2009 10:18:53,spid21s,Unknown,Starting up database 'KentLive'.
06/09/2009 10:18:53,spid21s,Unknown,SQL Server has encountered 4 occurrence(s) of cachestore flush for the 'Bound Trees' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.
06/09/2009 10:18:53,spid21s,Unknown,SQL Server has encountered 4 occurrence(s) of cachestore flush for the 'SQL Plans' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.
06/09/2009 10:18:52,spid21s,Unknown,SQL Server has encountered 4 occurrence(s) of cachestore flush for the 'Object Plans' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.
06/09/2009 10:18:52,spid94,Unknown,During undoing of a logged operation in database 'KentLive' an error occurred at log record ID (24550:433:1). Typically the specific failure is logged previously as an error in the Windows Event Log service. Restore the database or file from a backup or repair the database.
06/09/2009 10:18:52,spid94,Unknown,Error: 3314 Severity: 21 State: 5.
06/09/2009 10:18:52,spid94,Unknown,The log for database 'KentLive' is not available. Check the event log for related error messages. Resolve any errors and restart the database.
06/09/2009 10:18:52,spid94,Unknown,Error: 9001 Severity: 21 State: 1.
06/09/2009 10:18:52,spid94,Unknown,During undoing of a logged operation in database 'KentLive' an error occurred at log record ID (24550:433:37). Typically the specific failure is logged previously as an error in the Windows Event Log service. Restore the database or file from a backup or repair the database.
06/09/2009 10:18:52,spid94,Unknown,Error: 3314 Severity: 21 State: 4.
06/09/2009 10:18:52,spid94,Unknown,The log for database 'KentLive' is not available. Check the event log for related error messages. Resolve any errors and restart the database.
06/09/2009 10:18:52,spid94,Unknown,Error: 9001 Severity: 21 State: 5.
06/09/2009 10:18:52,spid94,Unknown,During undoing of a logged operation in database 'KentLive' an error occurred at log record ID (24550:433:37). Typically the specific failure is logged previously as an error in the Windows Event Log service. Restore the database or file from a backup or repair the database.
06/09/2009 10:18:52,spid94,Unknown,Error: 3314 Severity: 21 State: 4.
06/09/2009 10:18:52,spid94,Unknown,The log for database 'KentLive' is not available. Check the event log for related error messages. Resolve any errors and restart the database.
06/09/2009 10:18:52,spid94,Unknown,Error: 9001 Severity: 21 State: 5.
06/09/2009 10:18:52,spid94,Unknown,During undoing of a logged operation in database 'KentLive' an error occurred at log record ID (24550:433:38). Typically the specific failure is logged previously as an error in the Windows Event Log service. Restore the database or file from a backup or repair the database.
06/09/2009 10:18:52,spid94,Unknown,Error: 3314 Severity: 21 State: 2.
06/09/2009 10:18:52,spid94,Unknown,The log for database 'KentLive' is not available. Check the event log for related error messages. Resolve any errors and restart the database.
06/09/2009 10:18:52,spid94,Unknown,Error: 9001 Severity: 21 State: 1.
06/09/2009 10:18:52,spid94,Unknown,During undoing of a logged operation in database 'KentLive' an error occurred at log record ID (24550:433:46). Typically the specific failure is logged previously as an error in the Windows Event Log service. Restore the database or file from a backup or repair the database.
06/09/2009 10:18:52,spid94,Unknown,Error: 3314 Severity: 21 State: 4.
06/09/2009 10:18:52,spid94,Unknown,External dump process return code 0x20000001.External dump process returned no errors.
06/09/2009 10:18:50,spid94,Unknown,Stack Signature for the dump is 0x86225FF1
06/09/2009 10:18:50,spid94,Unknown,78132A36 Module(MSVCR80+00002A36)
06/09/2009 10:18:50,spid94,Unknown,781329AA Module(MSVCR80+000029AA)
06/09/2009 10:18:50,spid94,Unknown,010B9201 Module(sqlservr+000B9201)
06/09/2009 10:18:50,spid94,Unknown,010B9064 Module(sqlservr+000B9064)
06/09/2009 10:18:50,spid94,Unknown,010B939C Module(sqlservr+000B939C)
06/09/2009 10:18:50,spid94,Unknown,010B94A5 Module(sqlservr+000B94A5)
06/09/2009 10:18:50,spid94,Unknown,010075DC Module(sqlservr+000075DC)
06/09/2009 10:18:50,spid94,Unknown,010078CC Module(sqlservr+000078CC)
06/09/2009 10:18:50,spid94,Unknown,010077A6 Module(sqlservr+000077A6)
06/09/2009 10:18:50,spid94,Unknown,0102F1F4 Module(sqlservr+0002F1F4)
06/09/2009 10:18:50,spid94,Unknown,01032A36 Module(sqlservr+00032A36)
06/09/2009 10:18:50,spid94,Unknown,010286DC Module(sqlservr+000286DC)
06/09/2009 10:18:50,spid94,Unknown,010293B5 Module(sqlservr+000293B5)
06/09/2009 10:18:50,spid94,Unknown,010227F3 Module(sqlservr+000227F3)
06/09/2009 10:18:50,spid94,Unknown,012386C2 Module(sqlservr+002386C2)
06/09/2009 10:18:50,spid94,Unknown,0123882D Module(sqlservr+0023882D)
06/09/2009 10:18:50,spid94,Unknown,012389B6 Module(sqlservr+002389B6)
06/09/2009 10:18:50,spid94,Unknown,010286DC Module(sqlservr+000286DC)
06/09/2009 10:18:50,spid94,Unknown,010293B5 Module(sqlservr+000293B5)
06/09/2009 10:18:50,spid94,Unknown,010227F3 Module(sqlservr+000227F3)
06/09/2009 10:18:50,spid94,Unknown,01048B4C Module(sqlservr+00048B4C)
06/09/2009 10:18:50,spid94,Unknown,01048CD2 Module(sqlservr+00048CD2)
06/09/2009 10:18:50,spid94,Unknown,010259F5 Module(sqlservr+000259F5)
06/09/2009 10:18:50,spid94,Unknown,01033160 Module(sqlservr+00033160)
06/09/2009 10:18:50,spid94,Unknown,010588CA Module(sqlservr+000588CA)
06/09/2009 10:18:50,spid94,Unknown,01026125 Module(sqlservr+00026125)
06/09/2009 10:18:50,spid94,Unknown,0105930D Module(sqlservr+0005930D)
06/09/2009 10:18:50,spid94,Unknown,01046B91 Module(sqlservr+00046B91)
06/09/2009 10:18:50,spid94,Unknown,01046ACD Module(sqlservr+00046ACD)
06/09/2009 10:18:50,spid94,Unknown,0105E25A Module(sqlservr+0005E25A)
06/09/2009 10:18:50,spid94,Unknown,021B231A Module(sqlservr+011B231A)
06/09/2009 10:18:50,spid94,Unknown,021E21DF Module(sqlservr+011E21DF)
06/09/2009 10:18:50,spid94,Unknown,021EDDFF Module(sqlservr+011EDDFF)
06/09/2009 10:18:50,spid94,Unknown,0107A3CE Module(sqlservr+0007A3CE)
06/09/2009 10:18:50,spid94,Unknown,0107AAF5 Module(sqlservr+0007AAF5)
06/09/2009 10:18:50,spid94,Unknown,021F41F0 Module(sqlservr+011F41F0)
06/09/2009 10:18:50,spid94,Unknown,01443470 Module(sqlservr+00443470)
06/09/2009 10:18:50,spid94,Unknown,0145A0A1 Module(sqlservr+0045A0A1)
06/09/2009 10:18:50,spid94,Unknown,021C3DFA Module(sqlservr+011C3DFA)
06/09/2009 10:18:50,spid94,Unknown,021C3EF2 Module(sqlservr+011C3EF2)
06/09/2009 10:18:50,spid94,Unknown,021A6880 Module(sqlservr+011A6880)
06/09/2009 10:18:50,spid94,Unknown,021A29C4 Module(sqlservr+011A29C4)
06/09/2009 10:18:50,spid94,Unknown,77E4BEE7 Module(kernel32+0000BEE7)
06/09/2009 10:18:50,spid94,Unknown,* Short Stack Dump
06/09/2009 10:18:50,spid94,Unknown,* -------------------------------------------------------------------------------
06/09/2009 10:18:50,spid94,Unknown,* *******************************************************************************
06/09/2009 10:18:50,spid94,Unknown,* SegSs: 78130023: 00000000 00000000 00000000 00000000 00000000 00000000
06/09/2009 10:18:50,spid94,Unknown,* Esp: 638A1330: 51F2B5E0 000042AC 00000000 00000000 77E4BEE7 00000000
06/09/2009 10:18:50,spid94,Unknown,* EFlags: 00000246:
06/09/2009 10:18:50,spid94,Unknown,* SegCs: 0000001B:
06/09/2009 10:18:50,spid94,Unknown,* Ebp: 638A1384: 638A13C8 021A29C4 000042AC 00000000 00000000 00000000
06/09/2009 10:18:50,spid94,Unknown,* Eip: 77E4BEE7: 10C2C95E 01093D00 840FC000 00000095 F29DE950 9090FFFF
06/09/2009 10:18:50,spid94,Unknown,* Edx: 0000003D:
06/09/2009 10:18:50,spid94,Unknown,* Ecx: 638A19A4: 00000000 00010007 00000000 00740072 00177B0C 638A1364
06/09/2009 10:18:50,spid94,Unknown,* Ebx: 0000003F:
06/09/2009 10:18:50,spid94,Unknown,* Eax: 638A1334: 000042AC 00000000 00000000 77E4BEE7 00000000 7C82771B
06/09/2009 10:18:50,spid94,Unknown,* Esi: 00000000:
06/09/2009 10:18:50,spid94,Unknown,* Edi: 638A1450: 00177B08 00177B08 02193378 638A5314 00000001 00200020
06/09/2009 10:18:50,spid94,Unknown,*
06/09/2009 10:18:50,spid94,Unknown,* dbghelp 643E0000 644F4FFF 00115000
06/09/2009 10:18:50,spid94,Unknown,* xplog70 642B0000 642B2FFF 00003000
06/09/2009 10:18:50,spid94,Unknown,* xplog70 64290000 6429BFFF 0000c000
06/09/2009 10:18:50,spid94,Unknown,* xpstar90 64260000 64285FFF 00026000
06/09/2009 10:18:50,spid94,Unknown,* odbcint 64140000 64156FFF 00017000
06/09/2009 10:18:50,spid94,Unknown,* ATL80 7C630000 7C64AFFF 0001b000
06/09/2009 10:18:50,spid94,Unknown,* BatchParser90 63F50000 63F6EFFF 0001f000
06/09/2009 10:18:50,spid94,Unknown,* ODBC32 63F10000 63F4CFFF 0003d000
06/09/2009 10:18:50,spid94,Unknown,* SQLSCM90 63EF0000 63EF8FFF 00009000
06/09/2009 10:18:50,spid94,Unknown,* xpstar90 63E90000 63ED8FFF 00049000
06/09/2009 10:18:50,spid94,Unknown,* xpsqlbot 63E70000 63E75FFF 00006000
06/09/2009 10:18:50,spid94,Unknown,* msftepxy 00950000 00964FFF 00015000
06/09/2009 10:18:50,spid94,Unknown,* SQLNCLIR 00910000 00942FFF 00033000
06/09/2009 10:18:50,spid94,Unknown,* comdlg32 762B0000 762F8FFF 00049000
06/09/2009 10:18:50,spid94,Unknown,* COMCTL32 77530000 775C6FFF 00097000
06/09/2009 10:18:50,spid94,Unknown,* sqlncli 63480000 636A3FFF 00224000
06/09/2009 10:18:50,spid94,Unknown,* CLBCatQ 777B0000 77832FFF 00083000
06/09/2009 10:18:50,spid94,Unknown,* xpsp2res 631B0000 63474FFF 002c5000
06/09/2009 10:18:50,spid94,Unknown,* ntdsapi 766F0000 76703FFF 00014000
06/09/2009 10:18:50,spid94,Unknown,* SAMLIB 7E020000 7E02EFFF 0000f000
06/09/2009 10:18:50,spid94,Unknown,* NTMARTA 77E00000 77E20FFF 00021000
06/09/2009 10:18:50,spid94,Unknown,* dssenh 68100000 68126FFF 00027000
06/09/2009 10:18:50,spid94,Unknown,* imagehlp 76C10000 76C37FFF 00028000
06/09/2009 10:18:50,spid94,Unknown,* WINTRUST 76BB0000 76BDAFFF 0002b000
06/09/2009 10:18:50,spid94,Unknown,* dbghelp 62BC0000 62CD4FFF 00115000
06/09/2009 10:18:50,spid94,Unknown,* msfte 62960000 62BB8FFF 00259000
06/09/2009 10:18:50,spid94,Unknown,* security 62230000 62233FFF 00004000
06/09/2009 10:18:50,spid94,Unknown,* wshtcpip 71AE0000 71AE7FFF 00008000
06/09/2009 10:18:50,spid94,Unknown,* hnetcfg 61CD0000 61D29FFF 0005a000
06/09/2009 10:18:50,spid94,Unknown,* rasadhlp 76F80000 76F84FFF 00005000
06/09/2009 10:18:50,spid94,Unknown,* WLDAP32 76F10000 76F3DFFF 0002e000
06/09/2009 10:18:50,spid94,Unknown,* winrnr 76F70000 76F76FFF 00007000
06/09/2009 10:18:50,spid94,Unknown,* DNSAPI 76ED0000 76EF9FFF 0002a000
06/09/2009 10:18:50,spid94,Unknown,* WSOCK32 71BB0000 71BB8FFF 00009000
06/09/2009 10:18:50,spid94,Unknown,* VERSION 77B90000 77B97FFF 00008000
06/09/2009 10:18:50,spid94,Unknown,* MTXCLU 74F40000 74F58FFF 00019000
06/09/2009 10:18:50,spid94,Unknown,* msvcp60 61BF0000 61C54FFF 00065000
06/09/2009 10:18:50,spid94,Unknown,* MSDTCPRX 61B70000 61BE8FFF 00079000
06/09/2009 10:18:50,spid94,Unknown,* XOLEHLP 61B60000 61B65FFF 00006000
06/09/2009 10:18:50,spid94,Unknown,* COMRES 77010000 770D5FFF 000c6000
06/09/2009 10:18:50,spid94,Unknown,* schannel 76750000 76776FFF 00027000
06/09/2009 10:18:50,spid94,Unknown,* cryptdll 766E0000 766EBFFF 0000c000
06/09/2009 10:18:50,spid94,Unknown,* kerberos 34460000 344B7FFF 00058000
06/09/2009 10:18:50,spid94,Unknown,* iphlpapi 76CF0000 76D09FFF 0001a000
06/09/2009 10:18:50,spid94,Unknown,* msv1_0 76C90000 76CB6FFF 00027000
06/09/2009 10:18:50,spid94,Unknown,* MSCOREE 341F0000 34234FFF 00045000
06/09/2009 10:18:50,spid94,Unknown,* AUTHZ 76C40000 76C53FFF 00014000
06/09/2009 10:18:50,spid94,Unknown,* rsaenh 68000000 68034FFF 00035000
06/09/2009 10:18:50,spid94,Unknown,* SQLOS 344D0000 344D4FFF 00005000
06/09/2009 10:18:50,spid94,Unknown,* sqlevn70 4F610000 4F7B8FFF 001a9000
06/09/2009 10:18:50,spid94,Unknown,* RESUTILS 74EF0000 74F02FFF 00013000
06/09/2009 10:18:50,spid94,Unknown,* OLEAUT32 77D00000 77D8AFFF 0008b000
06/09/2009 10:18:50,spid94,Unknown,* ole32 77670000 777A8FFF 00139000
06/09/2009 10:18:50,spid94,Unknown,* CLUSAPI 74DE0000 74DF1FFF 00012000
06/09/2009 10:18:50,spid94,Unknown,* instapi 48060000 48069FFF 0000a000
06/09/2009 10:18:50,spid94,Unknown,* psapi 76B70000 76B7AFFF 0000b000
06/09/2009 10:18:50,spid94,Unknown,* comctl32 77420000 77522FFF 00103000
06/09/2009 10:18:50,spid94,Unknown,* IMM32 76290000 762ACFFF 0001d000
06/09/2009 10:18:50,spid94,Unknown,* SHLWAPI 77DA0000 77DF1FFF 00052000
06/09/2009 10:18:50,spid94,Unknown,* SHELL32 7C8D0000 7D0CDFFF 007fe000
06/09/2009 10:18:50,spid94,Unknown,* NETAPI32 71C40000 71C96FFF 00057000
06/09/2009 10:18:50,spid94,Unknown,* opends60 333E0000 333E6FFF 00007000
06/09/2009 10:18:50,spid94,Unknown,* USERENV 76920000 769E1FFF 000c2000
06/09/2009 10:18:50,spid94,Unknown,* WS2HELP 71BF0000 71BF7FFF 00008000
06/09/2009 10:18:50,spid94,Unknown,* WS2_32 71C00000 71C16FFF 00017000
06/09/2009 10:18:50,spid94,Unknown,* MSWSOCK 71B20000 71B60FFF 00041000
06/09/2009 10:18:50,spid94,Unknown,* MSASN1 76190000 761A1FFF 00012000
06/09/2009 10:18:50,spid94,Unknown,* CRYPT32 761B0000 76242FFF 00093000
06/09/2009 10:18:50,spid94,Unknown,* GDI32 77C00000 77C47FFF 00048000
06/09/2009 10:18:50,spid94,Unknown,* USER32 77380000 77410FFF 00091000
06/09/2009 10:18:50,spid94,Unknown,* Secur32 76F50000 76F62FFF 00013000
06/09/2009 10:18:50,spid94,Unknown,* RPCRT4 77C50000 77CEEFFF 0009f000
06/09/2009 10:18:50,spid94,Unknown,* ADVAPI32 77F50000 77FEAFFF 0009b000
06/09/2009 10:18:50,spid94,Unknown,* MSVCP80 7C420000 7C4A6FFF 00087000
06/09/2009 10:18:50,spid94,Unknown,* msvcrt 77BA0000 77BF9FFF 0005a000
06/09/2009 10:18:50,spid94,Unknown,* MSVCR80 78130000 781CAFFF 0009b000
06/09/2009 10:18:50,spid94,Unknown,* kernel32 77E40000 77F41FFF 00102000
06/09/2009 10:18:50,spid94,Unknown,* ntdll 7C800000 7C8BFFFF 000c0000
06/09/2009 10:18:50,spid94,Unknown,* sqlservr 01000000 02C09FFF 01c0a000
06/09/2009 10:18:50,spid94,Unknown,* MODULE BASE END SIZE
06/09/2009 10:18:50,spid94,Unknown,*
06/09/2009 10:18:50,spid94,Unknown,*
06/09/2009 10:18:50,spid94,Unknown,* 00 00
06/09/2009 10:18:50,spid94,Unknown,* r e n t I D & Û3 72 00 65 00 6e 00 74 00 49 00 44 00 00 26 04 04 db 33
06/09/2009 10:18:50,spid94,Unknown,* D & ó3 @ p a 00 44 00 00 26 04 04 f3 33 00 00 09 40 00 70 00 61 00
06/09/2009 10:18:50,spid94,Unknown,* g e @ P a g e I 67 00 65 00 00 00 07 40 00 50 00 61 00 67 00 65 00 49
06/09/2009 10:18:50,spid94,Unknown,* M o v e P a 01 00 00 00 08 00 4d 00 6f 00 76 00 65 00 50 00 61 00
06/09/2009 10:18:50,spid94,Unknown,* 16 00 00 00 12 00 00 00 02 00 00 00 00 00 00 00 00 00
06/09/2009 10:18:50,spid94,Unknown,* Input Buffer 92 bytes -
06/09/2009 10:18:50,spid94,Unknown,*
06/09/2009 10:18:50,spid94,Unknown,* HandleAndNoteToErrorlog: Exception raised major=34 minor=48 severity=21
06/09/2009 10:18:50,spid94,Unknown,*
06/09/2009 10:18:50,spid94,Unknown,* 06/09/09 10:18:50 spid 94
06/09/2009 10:18:50,spid94,Unknown,* BEGIN STACK DUMP:
06/09/2009 10:18:50,spid94,Unknown,*
06/09/2009 10:18:50,spid94,Unknown,* *******************************************************************************
06/09/2009 10:18:50,spid94,Unknown,***Stack Dump being sent to R:\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLDump0376.txt
06/09/2009 10:18:50,spid94,Unknown,**Dump thread - spid = 94 PSS = 0x51F2B5E0 EC = 0x51F2B5E8
06/09/2009 10:18:50,spid94,Unknown,Using 'dbghelp.dll' version '4.0.5'
06/09/2009 10:18:50,spid94,Unknown,Rollback encountered a page with a log sequence number (LSN) less than the original log record LSN. Could not undo log record (24550:433:46) for transaction ID (0:3327952) on page (1:105040) database 'KentLive' (database ID 8). Page information: LSN = (24550:433:32) type = 2. Log information: OpCode = 2 context 4. Restore or repair the database.
06/09/2009 10:18:50,spid94,Unknown,Error: 3448 Severity: 21 State: 1.
06/09/2009 10:18:50,spid94,Unknown,An inconsistency was detected during an internal operation in database 'KentLive'(ID:8) on page (1:105040). Please contact technical support. Reference number 6.
06/09/2009 10:18:50,spid94,Unknown,Error: 5242 Severity: 22 State: 1.
06/09/2009 10:18:50,spid94,Unknown,External dump process return code 0x20000001.External dump process returned no errors.
06/09/2009 10:18:48,spid94,Unknown,Stack Signature for the dump is 0x5D63EFF8
06/09/2009 10:18:48,spid94,Unknown,* -------------------------------------------------------------------------------
06/09/2009 10:18:48,spid94,Unknown,78132A36 Module(MSVCR80+00002A36)
06/09/2009 10:18:48,spid94,Unknown,781329AA Module(MSVCR80+000029AA)
06/09/2009 10:18:48,spid94,Unknown,010B9201 Module(sqlservr+000B9201)
06/09/2009 10:18:48,spid94,Unknown,010B9064 Module(sqlservr+000B9064)
06/09/2009 10:18:48,spid94,Unknown,010B939C Module(sqlservr+000B939C)
06/09/2009 10:18:48,spid94,Unknown,010B94A5 Module(sqlservr+000B94A5)
06/09/2009 10:18:48,spid94,Unknown,010075DC Module(sqlservr+000075DC)
06/09/2009 10:18:48,spid94,Unknown,010078CC Module(sqlservr+000078CC)
06/09/2009 10:18:48,spid94,Unknown,010077A6 Module(sqlservr+000077A6)
06/09/2009 10:18:48,spid94,Unknown,0102F1F4 Module(sqlservr+0002F1F4)
06/09/2009 10:18:48,spid94,Unknown,01032A36 Module(sqlservr+00032A36)
06/09/2009 10:18:48,spid94,Unknown,010286DC Module(sqlservr+000286DC)
06/09/2009 10:18:48,spid94,Unknown,010293B5 Module(sqlservr+000293B5)
06/09/2009 10:18:48,spid94,Unknown,010227F3 Module(sqlservr+000227F3)
06/09/2009 10:18:48,spid94,Unknown,012386C2 Module(sqlservr+002386C2)
06/09/2009 10:18:48,spid94,Unknown,0123882D Module(sqlservr+0023882D)
06/09/2009 10:18:48,spid94,Unknown,012389B6 Module(sqlservr+002389B6)
06/09/2009 10:18:48,spid94,Unknown,010286DC Module(sqlservr+000286DC)
06/09/2009 10:18:48,spid94,Unknown,010293B5 Module(sqlservr+000293B5)
06/09/2009 10:18:48,spid94,Unknown,010227F3 Module(sqlservr+000227F3)
06/09/2009 10:18:48,spid94,Unknown,01048B4C Module(sqlservr+00048B4C)
06/09/2009 10:18:48,spid94,Unknown,01048CD2 Module(sqlservr+00048CD2)
06/09/2009 10:18:48,spid94,Unknown,010259F5 Module(sqlservr+000259F5)
06/09/2009 10:18:48,spid94,Unknown,01033160 Module(sqlservr+00033160)
06/09/2009 10:18:48,spid94,Unknown,010588CA Module(sqlservr+000588CA)
06/09/2009 10:18:48,spid94,Unknown,01026125 Module(sqlservr+00026125)
06/09/2009 10:18:48,spid94,Unknown,0105930D Module(sqlservr+0005930D)
06/09/2009 10:18:48,spid94,Unknown,01046B91 Module(sqlservr+00046B91)
06/09/2009 10:18:48,spid94,Unknown,01046ACD Module(sqlservr+00046ACD)
06/09/2009 10:18:48,spid94,Unknown,0105E25A Module(sqlservr+0005E25A)
06/09/2009 10:18:48,spid94,Unknown,0105AE2E Module(sqlservr+0005AE2E)
06/09/2009 10:18:48,spid94,Unknown,01060309 Module(sqlservr+00060309)
06/09/2009 10:18:48,spid94,Unknown,01060161 Module(sqlservr+00060161)
06/09/2009 10:18:48,spid94,Unknown,0105D444 Module(sqlservr+0005D444)
06/09/2009 10:18:48,spid94,Unknown,01061766 Module(sqlservr+00061766)
06/09/2009 10:18:48,spid94,Unknown,0106181A Module(sqlservr+0006181A)
06/09/2009 10:18:48,spid94,Unknown,0106E9EF Module(sqlservr+0006E9EF)
06/09/2009 10:18:48,spid94,Unknown,023C3298 Module(sqlservr+013C3298)
06/09/2009 10:18:48,spid94,Unknown,01443470 Module(sqlservr+00443470)
06/09/2009 10:18:48,spid94,Unknown,015BFA3D Module(sqlservr+005BFA3D)
06/09/2009 10:18:48,spid94,Unknown,021A642D Module(sqlservr+011A642D)
06/09/2009 10:18:48,spid94,Unknown,021A6880 Module(sqlservr+011A6880)
06/09/2009 10:18:48,spid94,Unknown,021A29C4 Module(sqlservr+011A29C4)
06/09/2009 10:18:48,spid94,Unknown,77E4BEE7 Module(kernel32+0000BEE7)
06/09/2009 10:18:48,spid94,Unknown,* Short Stack Dump
06/09/2009 10:18:48,spid94,Unknown,* -------------------------------------------------------------------------------
06/09/2009 10:18:48,spid94,Unknown,* *******************************************************************************
06/09/2009 10:18:48,spid94,Unknown,* SegSs: 78130023: 00000000 00000000 00000000 00000000 00000000 00000000
06/09/2009 10:18:48,spid94,Unknown,* Esp: 638AA7B0: 51F2B5E0 000042AC 00000000 00000000 77E4BEE7 00000000
06/09/2009 10:18:48,spid94,Unknown,* EFlags: 00000246:
06/09/2009 10:18:48,spid94,Unknown,* SegCs: 0000001B:
06/09/2009 10:18:48,spid94,Unknown,* Ebp: 638AA804: 638AA848 021A29C4 000042AC 00000000 00000000 00000000
06/09/2009 10:18:48,spid94,Unknown,* Eip: 77E4BEE7: 10C2C95E 01093D00 840FC000 00000095 F29DE950 9090FFFF
06/09/2009 10:18:48,spid94,Unknown,* Edx: FFFFFFFF:
06/09/2009 10:18:48,spid94,Unknown,* Ecx: 638AAE24: 00000000 00010007 00000000 00740072 00177B0C 638AA7E4
06/09/2009 10:18:48,spid94,Unknown,* Ebx: FFFFFFFF:
06/09/2009 10:18:48,spid94,Unknown,* Eax: 638AA7B4: 000042AC 00000000 00000000 77E4BEE7 00000000 7C82771B
06/09/2009 10:18:48,spid94,Unknown,* Esi: 00000000:
06/09/2009 10:18:48,spid94,Unknown,* Edi: 638AA8D0: 00177B08 00004446 22F541C0 00040000 14001000 C0000000
06/09/2009 10:18:48,spid94,Unknown,*
06/09/2009 10:18:48,spid94,Unknown,* dbghelp 643E0000 644F4FFF 00115000
06/09/2009 10:18:48,spid94,Unknown,* xplog70 642B0000 642B2FFF 00003000
06/09/2009 10:18:48,spid94,Unknown,* xplog70 64290000 6429BFFF 0000c000
06/09/2009 10:18:48,spid94,Unknown,* xpstar90 64260000 64285FFF 00026000
06/09/2009 10:18:48,spid94,Unknown,* odbcint 64140000 64156FFF 00017000
06/09/2009 10:18:48,spid94,Unknown,* ATL80 7C630000 7C64AFFF 0001b000
06/09/2009 10:18:48,spid94,Unknown,* BatchParser90 63F50000 63F6EFFF 0001f000
06/09/2009 10:18:48,spid94,Unknown,* ODBC32 63F10000 63F4CFFF 0003d000
06/09/2009 10:18:48,spid94,Unknown,* SQLSCM90 63EF0000 63EF8FFF 00009000
06/09/2009 10:18:48,spid94,Unknown,* xpstar90 63E90000 63ED8FFF 00049000
06/09/2009 10:18:48,spid94,Unknown,* xpsqlbot 63E70000 63E75FFF 00006000
06/09/2009 10:18:48,spid94,Unknown,* msftepxy 00950000 00964FFF 00015000
06/09/2009 10:18:48,spid94,Unknown,* SQLNCLIR 00910000 00942FFF 00033000
06/09/2009 10:18:48,spid94,Unknown,* comdlg32 762B0000 762F8FFF 00049000
06/09/2009 10:18:48,spid94,Unknown,* COMCTL32 77530000 775C6FFF 00097000
06/09/2009 10:18:48,spid94,Unknown,* sqlncli 63480000 636A3FFF 00224000
06/09/2009 10:18:48,spid94,Unknown,* CLBCatQ 777B0000 77832FFF 00083000
06/09/2009 10:18:48,spid94,Unknown,* xpsp2res 631B0000 63474FFF 002c5000
06/09/2009 10:18:48,spid94,Unknown,* ntdsapi 766F0000 76703FFF 00014000
06/09/2009 10:18:48,spid94,Unknown,* SAMLIB 7E020000 7E02EFFF 0000f000
06/09/2009 10:18:48,spid94,Unknown,* NTMARTA 77E00000 77E20FFF 00021000
06/09/2009 10:18:48,spid94,Unknown,* dssenh 68100000 68126FFF 00027000
06/09/2009 10:18:48,spid94,Unknown,* imagehlp 76C10000 76C37FFF 00028000
06/09/2009 10:18:48,spid94,Unknown,* WINTRUST 76BB0000 76BDAFFF 0002b000
06/09/2009 10:18:48,spid94,Unknown,* dbghelp 62BC0000 62CD4FFF 00115000
06/09/2009 10:18:48,spid94,Unknown,* msfte 62960000 62BB8FFF 00259000
06/09/2009 10:18:48,spid94,Unknown,* security 62230000 62233FFF 00004000
06/09/2009 10:18:48,spid94,Unknown,* wshtcpip 71AE0000 71AE7FFF 00008000
06/09/2009 10:18:48,spid94,Unknown,* hnetcfg 61CD0000 61D29FFF 0005a000
06/09/2009 10:18:48,spid94,Unknown,* rasadhlp 76F80000 76F84FFF 00005000
06/09/2009 10:18:48,spid94,Unknown,* WLDAP32 76F10000 76F3DFFF 0002e000
06/09/2009 10:18:48,spid94,Unknown,* winrnr 76F70000 76F76FFF 00007000
06/09/2009 10:18:48,spid94,Unknown,* DNSAPI 76ED0000 76EF9FFF 0002a000
06/09/2009 10:18:48,spid94,Unknown,* WSOCK32 71BB0000 71BB8FFF 00009000
06/09/2009 10:18:48,spid94,Unknown,* VERSION 77B90000 77B97FFF 00008000
06/09/2009 10:18:48,spid94,Unknown,* MTXCLU 74F40000 74F58FFF 00019000
06/09/2009 10:18:48,spid94,Unknown,* msvcp60 61BF0000 61C54FFF 00065000
06/09/2009 10:18:48,spid94,Unknown,* MSDTCPRX 61B70000 61BE8FFF 00079000
06/09/2009 10:18:48,spid94,Unknown,* XOLEHLP 61B60000 61B65FFF 00006000
06/09/2009 10:18:48,spid94,Unknown,* COMRES 77010000 770D5FFF 000c6000
06/09/2009 10:18:48,spid94,Unknown,* schannel 76750000 76776FFF 00027000
06/09/2009 10:18:48,spid94,Unknown,* cryptdll 766E0000 766EBFFF 0000c000
06/09/2009 10:18:48,spid94,Unknown,* kerberos 34460000 344B7FFF 00058000
06/09/2009 10:18:48,spid94,Unknown,* iphlpapi 76CF0000 76D09FFF 0001a000
06/09/2009 10:18:48,spid94,Unknown,* msv1_0 76C90000 76CB6FFF 00027000
06/09/2009 10:18:48,spid94,Unknown,* MSCOREE 341F0000 34234FFF 00045000
06/09/2009 10:18:48,spid94,Unknown,* AUTHZ 76C40000 76C53FFF 00014000
06/09/2009 10:18:48,spid94,Unknown,* rsaenh 68000000 68034FFF 00035000
06/09/2009 10:18:48,spid94,Unknown,* SQLOS 344D0000 344D4FFF 00005000
06/09/2009 10:18:48,spid94,Unknown,* sqlevn70 4F610000 4F7B8FFF 001a9000
06/09/2009 10:18:48,spid94,Unknown,* RESUTILS 74EF0000 74F02FFF 00013000
06/09/2009 10:18:48,spid94,Unknown,* OLEAUT32 77D00000 77D8AFFF 0008b000
06/09/2009 10:18:48,spid94,Unknown,* ole32 77670000 777A8FFF 00139000
06/09/2009 10:18:48,spid94,Unknown,* CLUSAPI 74DE0000 74DF1FFF 00012000
06/09/2009 10:18:48,spid94,Unknown,* instapi 48060000 48069FFF 0000a000
06/09/2009 10:18:48,spid94,Unknown,* psapi 76B70000 76B7AFFF 0000b000
06/09/2009 10:18:48,spid94,Unknown,* comctl32 77420000 77522FFF 00103000
06/09/2009 10:18:48,spid94,Unknown,* IMM32 76290000 762ACFFF 0001d000
06/09/2009 10:18:48,spid94,Unknown,* SHLWAPI 77DA0000 77DF1FFF 00052000
06/09/2009 10:18:48,spid94,Unknown,* SHELL32 7C8D0000 7D0CDFFF 007fe000
06/09/2009 10:18:48,spid94,Unknown,* NETAPI32 71C40000 71C96FFF 00057000
06/09/2009 10:18:48,spid94,Unknown,* opends60 333E0000 333E6FFF 00007000
06/09/2009 10:18:48,spid94,Unknown,* USERENV 76920000 769E1FFF 000c2000
06/09/2009 10:18:48,spid94,Unknown,* WS2HELP 71BF0000 71BF7FFF 00008000
06/09/2009 10:18:48,spid94,Unknown,* WS2_32 71C00000 71C16FFF 00017000
06/09/2009 10:18:48,spid94,Unknown,* MSWSOCK 71B20000 71B60FFF 00041000
06/09/2009 10:18:48,spid94,Unknown,* MSASN1 76190000 761A1FFF 00012000
06/09/2009 10:18:48,spid94,Unknown,* CRYPT32 761B0000 76242FFF 00093000
06/09/2009 10:18:48,spid94,Unknown,* GDI32 77C00000 77C47FFF 00048000
06/09/2009 10:18:48,spid94,Unknown,* USER32 77380000 77410FFF 00091000
06/09/2009 10:18:48,spid94,Unknown,* Secur32 76F50000 76F62FFF 00013000
06/09/2009 10:18:48,spid94,Unknown,* RPCRT4 77C50000 77CEEFFF 0009f000
06/09/2009 10:18:48,spid94,Unknown,* ADVAPI32 77F50000 77FEAFFF 0009b000
06/09/2009 10:18:48,spid94,Unknown,* MSVCP80 7C420000 7C4A6FFF 00087000
06/09/2009 10:18:48,spid94,Unknown,* msvcrt 77BA0000 77BF9FFF 0005a000
06/09/2009 10:18:48,spid94,Unknown,* MSVCR80 78130000 781CAFFF 0009b000
06/09/2009 10:18:48,spid94,Unknown,* kernel32 77E40000 77F41FFF 00102000
06/09/2009 10:18:48,spid94,Unknown,* ntdll 7C800000 7C8BFFFF 000c0000
06/09/2009 10:18:48,spid94,Unknown,* sqlservr 01000000 02C09FFF 01c0a000
06/09/2009 10:18:48,spid94,Unknown,* MODULE BASE END SIZE
06/09/2009 10:18:48,spid94,Unknown,*
06/09/2009 10:18:48,spid94,Unknown,*
06/09/2009 10:18:48,spid94,Unknown,* 00 00
06/09/2009 10:18:48,spid94,Unknown,* r e n t I D & Û3 72 00 65 00 6e 00 74 00 49 00 44 00 00 26 04 04 db 33
06/09/2009 10:18:48,spid94,Unknown,* D & ó3 @ p a 00 44 00 00 26 04 04 f3 33 00 00 09 40 00 70 00 61 00
06/09/2009 10:18:48,spid94,Unknown,* g e @ P a g e I 67 00 65 00 00 00 07 40 00 50 00 61 00 67 00 65 00 49
06/09/2009 10:18:48,spid94,Unknown,* M o v e P a 01 00 00 00 08 00 4d 00 6f 00 76 00 65 00 50 00 61 00
06/09/2009 10:18:48,spid94,Unknown,* 16 00 00 00 12 00 00 00 02 00 00 00 00 00 00 00 00 00
06/09/2009 10:18:48,spid94,Unknown,* Input Buffer 92 bytes -
06/09/2009 10:18:48,spid94,Unknown,*
06/09/2009 10:18:48,spid94,Unknown,* ex_raise2: Exception raised major=52 minor=42 state=1 severity=22
06/09/2009 10:18:48,spid94,Unknown,*
06/09/2009 10:18:48,spid94,Unknown,* 06/09/09 10:18:48 spid 94
06/09/2009 10:18:48,spid94,Unknown,* BEGIN STACK DUMP:
06/09/2009 10:18:48,spid94,Unknown,*
06/09/2009 10:18:48,spid94,Unknown,* *******************************************************************************
06/09/2009 10:18:48,spid94,Unknown,***Stack Dump being sent to R:\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLDump0375.txt
06/09/2009 10:18:48,spid94,Unknown,*
06/09/2009 10:18:48,spid94,Unknown,* User initiated stack dump. This is not a server exception dump.
06/09/2009 10:18:48,spid94,Unknown,*
06/09/2009 10:18:48,spid94,Unknown,**Dump thread - spid = 94 PSS = 0x51F2B5E0 EC = 0x51F2B5E8
06/09/2009 10:18:48,spid94,Unknown,Using 'dbghelp.dll' version '4.0.5'
06/09/2009 10:18:48,spid94,Unknown,ex_raise2: Exception raised major=52 minor=42 state=1 severity=22 attempting to create symptom dump
06/09/2009 09:29:57,spid90,Unknown,An inconsistency was detected during an internal operation in database 'KentLive'(ID:8) on page (1:105040). Please contact technical support. Reference number 6.
06/09/2009 09:29:57,spid90,Unknown,Error: 5242 Severity: 22 State: 1.
06/09/2009 09:29:57,spid90,Unknown,External dump process return code 0x20000001.External dump process returned no errors.
06/09/2009 09:29:55,spid90,Unknown,Stack Signature for the dump is 0x9DCA42B0
06/09/2009 09:29:55,spid90,Unknown,* -------------------------------------------------------------------------------
Hardware Tests
All hardware tests came back reporting no errors.
Does anyone know what else I can check or maybe interpret some of my error log??
Any help would be very much appreciated.
Thanks in advance.
C

Viewing 15 posts - 1 through 15 (of 18 total)

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

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

chris_wallace_000 (6/22/2009)
SQL Error Log:
06/09/2009 10:18:54,spid21s,Unknown,An error occurred during recovery preventing the database 'KentLive' (database ID 8) from restarting. Diagnose the recovery errors and fix them or restore from a known good backup. If errors are not corrected or expected contact Technical Support.
06/09/2009 10:18:54,spid21s,Unknown,Error: 3414 Severity: 21 State: 1.
06/09/2009 10:18:54,spid21s,Unknown,During redoing of a logged operation in database 'KentLive' an error occurred at log record ID (24550:433:46). Typically the specific failure is previously logged as an error in the Windows Event Log service. Restore the database from a full backup or repair the database.

These look like the main lines of interest. Please can you check the earlier SQL error logs as well as the windows event log to see if there's anything else.

The most common cause for database corruption is problems with the IO subsystem. This can be faulty drivers, misbehaving anti-virus, faulty controller (in the case of RAID or SAN) or actual disk problems.

Do you have a backup?

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

chris_wallace_000 SSC-Addicted Points: 484 More actions · Answer 2

Thanks for your prompt response. Yes the database is backed up and it has been recovered and moved onto another SQL server whilst this investigation takes place.

I am running verifier.exe on the troublesome node and have checked the SAN logs with HP. They say that there is no issue with the SAN. What is the best way of testing I/O issues?? I have run sqlio.exe as well - no abnormal results were reported.

I'm stuck as to identifying the root cause. Every test I run seems to come back ok.

Event logs have no hardware issues before the DB inconsitencies (e.g. no report of I/O errors or HBA errors) - just lots of "Attempt to fetch logical page (1:100138) in database 8 failed. It belongs to allocation unit 0 not to 72057594088980480." type errors :S

Thanks in advance - much appreciated.

C

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

I'm not an expert on IO or hardware.

Was there a hard power failure? If the caches aren't properly battery-backed, that can cause problems.

Make sure that the HBA drivers are up to date, firmware is up to date, anti-virus does not check the SQL files.

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

Steve Jones - SSC Editor SSC Guru Points: 736254 More actions · Answer 4

I most often see bad drivers reported as the issues on this site. HBAs are complicated and their drivers (out of date, mismatched firmware, something like that) seem to be a source of issues. Often the vendor isn't completely aware of if there's a mismatch since they deal with many customers. Get them to verify on your system the exact drivers and firmware versions that should be there.

chris_wallace_000 SSC-Addicted Points: 484 More actions · Answer 5

No that's fine - neither am I. There was no power failure.

Thanks for your help anyway 🙂

I'll keep digging.

Cheers

C

chris_wallace_000 SSC-Addicted Points: 484 More actions · Answer 6

chris_wallace_000

SSC-Addicted

Points: 484

June 22, 2009 at 9:28 am

#1013393

Thanks SSChampion - will do.

Cheers

C

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

chris_wallace_000 (6/22/2009)
Thanks SSChampion - will do.

Who are you talking to? 😉

SSChampion is a forum title, like yours is "Forum Newbie"

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

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

This looks exactly like a stale read issue from an I/O subsystem controller. It's definitely the data files that are corrupt, not the log file.

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

chris_wallace_000 SSC-Addicted Points: 484 More actions · Answer 9

chris_wallace_000

SSC-Addicted

Points: 484

June 22, 2009 at 10:40 am

#1013444

Ah! 🙁

You can tell I'm a newbie!!!

chris_wallace_000 SSC-Addicted Points: 484 More actions · Answer 10

Thanks. It's just prooving extremely difficult to track down what is causing it (Grrrr)

The interesting thing is that the DB is running on the second node fine - and this has the exact same configuration and drivers.

Has anyone seen a cluster service cause this type of issue at all??

chris_wallace_000 SSC-Addicted Points: 484 More actions · Answer 11

Thanks. It's just prooving extremely difficult to track down what is causing it (Grrrr)

The interesting thing is that the DB is running on the second node fine - and this has the exact same configuration and drivers.

Has anyone seen a cluster service cause this type of issue at all??

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

No - it's nothing to do with clustering - it's the I/O subsystem. Possibly bad memory on the primary node. Can you run memory diagnostics on it?

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

Jeffrey Williams SSC Guru Points: 90303 More actions · Answer 13

I find this section the most interesting:

06/09/2009 10:18:50,spid94,Unknown,***Stack Dump being sent to R:\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLDump0376.txt

06/09/2009 10:18:50,spid94,Unknown,**Dump thread - spid = 94 PSS = 0x51F2B5E0 EC = 0x51F2B5E8

06/09/2009 10:18:50,spid94,Unknown,Using 'dbghelp.dll' version '4.0.5'

06/09/2009 10:18:50,spid94,Unknown,Rollback encountered a page with a log sequence number (LSN) less than the original log record LSN. Could not undo log record (24550:433:46) for transaction ID (0:3327952) on page (1:105040) database 'KentLive' (database ID 8). Page information: LSN = (24550:433:32) type = 2. Log information: OpCode = 2 context 4. Restore or repair the database.

06/09/2009 10:18:50,spid94,Unknown,Error: 3448 Severity: 21 State: 1.

06/09/2009 10:18:50,spid94,Unknown,An inconsistency was detected during an internal operation in database 'KentLive'(ID:8) on page (1:105040). Please contact technical support. Reference number 6.

06/09/2009 10:18:50,spid94,Unknown,Error: 5242 Severity: 22 State: 1.

This confirms (for me) that you are looking at an I/O subsystem problem.

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs

chris_wallace_000 SSC-Addicted Points: 484 More actions · Answer 14

Thanks for your input guys. It's greatly appreciated.

I have run extensive memory tests, and it all comes back fine.

I'm looking into drivers now!!

😀