SQLDump

Question

SQLDump

QZheng

SSC Enthusiast

Points: 132
More actions
July 30, 2009 at 9:56 am

#207519

My server creating sqldump files that taking up all the C: space. the server stop. when I delete one of my database then the dump file stop create. After I restore the database, it start creating sqldump files again. This is our production database. I have to get it back to work as soon as passible. Anyone can help?
Thanks,
Qinghong

Viewing 5 posts - 1 through 4 (of 4 total)

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

Steve Jones - SSC Editor SSC Guru Points: 736211 More actions · Answer 1

First, do you mean backup files? You haven't provided much information about specifically what is happening.

Dump is an old term, and a backup is the new term for a copy of the database. Using the proper terminology will help us to understand each other.

I'm not sure what you mean about deleting a database and then creating a new one. If you create a database, no backup or dump is automatically created. A process would have to be set up (like a maintenance plan) that would perform the backup.

Please slow down, give us the details of what files you see, what is happening, what you have done (Specifically).

QZheng SSC Enthusiast Points: 132 More actions · Answer 2

Wednesday mornning, when I went to office, I found the SQL 2005 server crested SQLDumpxxxx.log,SQLDumpxxxx.mdmp and SQLDumpxxxx.txt files taken up all the C: drive space. I tried to delete the files, but it generated again. Then I deleted the database and restored the backup I had taken two days before, but as soon as the database restore finished, the sqldump files started creating again.

Below is one of the SQLDumpxxxx.log:

14s * MSDTCPRX 34370000 343E8FFF 00079000

2009-07-30 16:59:02.29 spid14s * OLEAUT32 77D00000 77D8AFFF 0008b000

2009-07-30 16:59:02.29 spid14s * msvcp60 343F0000 34454FFF 00065000

2009-07-30 16:59:02.29 spid14s * MTXCLU 34460000 34478FFF 00019000

2009-07-30 16:59:02.29 spid14s * VERSION 77B90000 77B97FFF 00008000

2009-07-30 16:59:02.29 spid14s * WSOCK32 71BB0000 71BB8FFF 00009000

2009-07-30 16:59:02.29 spid14s * CLUSAPI 34480000 34491FFF 00012000

2009-07-30 16:59:02.29 spid14s * RESUTILS 344A0000 344B2FFF 00013000

2009-07-30 16:59:02.29 spid14s * mswsock 71B20000 71B60FFF 00041000

2009-07-30 16:59:02.29 spid14s * DNSAPI 76ED0000 76EF9FFF 0002a000

2009-07-30 16:59:02.29 spid14s * winrnr 76F70000 76F76FFF 00007000

2009-07-30 16:59:02.29 spid14s * WLDAP32 76F10000 76F3DFFF 0002e000

2009-07-30 16:59:02.29 spid14s * rasadhlp 76F80000 76F84FFF 00005000

2009-07-30 16:59:02.29 spid14s * security 62860000 62863FFF 00004000

2009-07-30 16:59:02.29 spid14s * dssenh 68100000 68126FFF 00027000

2009-07-30 16:59:02.29 spid14s * hnetcfg 62E90000 62EE9FFF 0005a000

2009-07-30 16:59:02.29 spid14s * wshtcpip 71AE0000 71AE7FFF 00008000

2009-07-30 16:59:02.29 spid14s * NTMARTA 77E00000 77E20FFF 00021000

2009-07-30 16:59:02.29 spid14s * SAMLIB 7E020000 7E02EFFF 0000f000

2009-07-30 16:59:02.29 spid14s * msfte 62FB0000 63208FFF 00259000

2009-07-30 16:59:02.29 spid14s * dbghelp 63220000 63334FFF 00115000

2009-07-30 16:59:02.29 spid14s * WINTRUST 76BB0000 76BDAFFF 0002b000

2009-07-30 16:59:02.29 spid14s * imagehlp 76C10000 76C37FFF 00028000

2009-07-30 16:59:02.29 spid14s * ntdsapi 766F0000 76703FFF 00014000

2009-07-30 16:59:02.29 spid14s * xpsp2res 635A0000 63864FFF 002c5000

2009-07-30 16:59:02.29 spid14s * CLBCatQ 777B0000 77832FFF 00083000

2009-07-30 16:59:02.29 spid14s * sqlncli 63890000 63AB6FFF 00227000

2009-07-30 16:59:02.29 spid14s * COMCTL32 77530000 775C6FFF 00097000

2009-07-30 16:59:02.29 spid14s * comdlg32 762B0000 762F8FFF 00049000

2009-07-30 16:59:02.29 spid14s * SHLWAPI 77DA0000 77DF1FFF 00052000

2009-07-30 16:59:02.29 spid14s * SHELL32 7C8D0000 7D0CEFFF 007ff000

2009-07-30 16:59:02.29 spid14s * comctl32 77420000 77522FFF 00103000

2009-07-30 16:59:02.29 spid14s * SQLNCLIR 63B10000 63B42FFF 00033000

2009-07-30 16:59:02.29 spid14s * msftepxy 63DD0000 63DE4FFF 00015000

2009-07-30 16:59:02.29 spid14s * xpstar90 641C0000 6420AFFF 0004b000

2009-07-30 16:59:02.29 spid14s * SQLSCM90 64220000 64228FFF 00009000

2009-07-30 16:59:02.29 spid14s * ODBC32 64240000 6427CFFF 0003d000

2009-07-30 16:59:02.29 spid14s * BatchParser90 64280000 6429EFFF 0001f000

2009-07-30 16:59:02.29 spid14s * ATL80 7C630000 7C64AFFF 0001b000

2009-07-30 16:59:02.29 spid14s * odbcint 64400000 64416FFF 00017000

2009-07-30 16:59:02.29 spid14s * xpstar90 64420000 64445FFF 00026000

2009-07-30 16:59:02.29 spid14s * dbghelp 644D0000 645E4FFF 00115000

2009-07-30 16:59:02.29 spid14s *

2009-07-30 16:59:02.29 spid14s * Edi: 62AFE358: 00140E58 781580A6 62AFE870 00000000 78158027 0B2CBC2F

2009-07-30 16:59:02.29 spid14s * Esi: 00000000:

2009-07-30 16:59:02.29 spid14s * Eax: 62AFE23C: 000042AC 00000000 00000000 77E4BEF7 00000000 7C827739

2009-07-30 16:59:02.29 spid14s * Ebx: FFFFFFFF:

2009-07-30 16:59:02.29 spid14s * Ecx: 62AFE8AC: 00000000 00010007 00000000 0090008E 00140E5C 62AFE26C

2009-07-30 16:59:02.29 spid14s * Edx: FFFFFFFF:

2009-07-30 16:59:02.29 spid14s * Eip: 77E4BEF7: 10C2C95E 01093D00 840FC000 00000095 F29DE950 9090FFFF

2009-07-30 16:59:02.29 spid14s * Ebp: 62AFE28C: 62AFE2D0 021AE96C 000042AC 00000000 00000000 00000000

2009-07-30 16:59:02.29 spid14s * SegCs: 0030001B: 6B8008E1 014001E1 54E07800 6C3288E1 010003E1 6006E800

2009-07-30 16:59:02.29 spid14s * EFlags: 00000246:

2009-07-30 16:59:02.29 spid14s * Esp: 62AFE238: 03F747D8 000042AC 00000000 00000000 77E4BEF7 00000000

2009-07-30 16:59:02.29 spid14s * SegSs: 78130023: 00000000 00000000 00000000 00000000 00000000 00000000

2009-07-30 16:59:02.29 spid14s * *******************************************************************************

2009-07-30 16:59:02.29 spid14s * -------------------------------------------------------------------------------

2009-07-30 16:59:02.29 spid14s * Short Stack Dump

2009-07-30 16:59:02.30 spid14s 77E4BEF7 Module(kernel32+0000BEF7)

2009-07-30 16:59:02.30 spid14s 021AE96C Module(sqlservr+011AE96C)

2009-07-30 16:59:02.30 spid14s 021B2880 Module(sqlservr+011B2880)

2009-07-30 16:59:02.30 spid14s 021B242D Module(sqlservr+011B242D)

2009-07-30 16:59:02.30 spid14s 015C4F15 Module(sqlservr+005C4F15)

2009-07-30 16:59:02.30 spid14s 010B6518 Module(sqlservr+000B6518)

2009-07-30 16:59:02.30 spid14s 023D1135 Module(sqlservr+013D1135)

2009-07-30 16:59:02.30 spid14s 01090057 Module(sqlservr+00090057)

2009-07-30 16:59:02.30 spid14s 01090205 Module(sqlservr+00090205)

2009-07-30 16:59:02.30 spid14s 01090277 Module(sqlservr+00090277)

2009-07-30 16:59:02.30 spid14s 0108FBF2 Module(sqlservr+0008FBF2)

2009-07-30 16:59:02.30 spid14s 0108F8C1 Module(sqlservr+0008F8C1)

2009-07-30 16:59:02.30 spid14s 01087D0E Module(sqlservr+00087D0E)

2009-07-30 16:59:02.30 spid14s 01087DAD Module(sqlservr+00087DAD)

2009-07-30 16:59:02.30 spid14s 010879EA Module(sqlservr+000879EA)

2009-07-30 16:59:02.30 spid14s 01087B9F Module(sqlservr+00087B9F)

2009-07-30 16:59:02.30 spid14s 010067D3 Module(sqlservr+000067D3)

2009-07-30 16:59:02.30 spid14s 010068F9 Module(sqlservr+000068F9)

2009-07-30 16:59:02.30 spid14s 01006609 Module(sqlservr+00006609)

2009-07-30 16:59:02.30 spid14s 010DAF6C Module(sqlservr+000DAF6C)

2009-07-30 16:59:02.30 spid14s 010DAE8C Module(sqlservr+000DAE8C)

2009-07-30 16:59:02.30 spid14s 010DAB54 Module(sqlservr+000DAB54)

2009-07-30 16:59:02.31 spid14s 010DACF1 Module(sqlservr+000DACF1)

2009-07-30 16:59:02.32 spid14s 781329AA Module(MSVCR80+000029AA)

2009-07-30 16:59:02.32 spid14s 78132A36 Module(MSVCR80+00002A36)

2009-07-30 16:59:02.36 spid14s * -------------------------------------------------------------------------------

2009-07-30 16:59:02.40 spid14s Stack Signature for the dump is 0x76976582

2009-07-30 16:59:03.67 spid14s External dump process return code 0x20000001.

External dump process returned no errors.

2009-07-30 16:59:03.67 spid14s DoMiniDump () encountered error (0x800703E6) - Invalid access to memory location.

2009-07-30 16:59:03.67 spid14s ex_raise2: Exception raised, major=52, minor=42, state=1, severity=22, attempting to create symptom dump

2009-07-30 16:59:03.70 spid14s Using 'dbghelp.dll' version '4.0.5'

2009-07-30 16:59:03.72 spid14s **Dump thread - spid = 14, PSS = 0x03F747D8, EC = 0x03F747E0

2009-07-30 16:59:03.72 spid14s *

2009-07-30 16:59:03.72 spid14s * User initiated stack dump. This is not a server exception dump.

2009-07-30 16:59:03.72 spid14s *

2009-07-30 16:59:03.72 spid14s ***Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLDump0012.txt

2009-07-30 16:59:03.72 spid14s * *******************************************************************************

2009-07-30 16:59:03.72 spid14s *

2009-07-30 16:59:03.72 spid14s * BEGIN STACK DUMP:

2009-07-30 16:59:03.72 spid14s * 07/30/09 16:59:03 spid 14

2009-07-30 16:59:03.72 spid14s *

2009-07-30 16:59:03.72 spid14s * ex_raise2: Exception raised, major=52, minor=42, state=1, severity=22

2009-07-30 16:59:03.72 spid14s *

2009-07-30 16:59:03.72 spid14s * MODULE BASE END SIZE

2009-07-30 16:59:03.72 spid14s * sqlservr 01000000 02C1FFFF 01c20000

2009-07-30 16:59:03.72 spid14s * ntdll 7C800000 7C8C1FFF 000c2000

2009-07-30 16:59:03.72 spid14s * kernel32 77E40000 77F41FFF 00102000

2009-07-30 16:59:03.72 spid14s * MSVCR80 78130000 781CAFFF 0009b000

2009-07-30 16:59:03.72 spid14s * msvcrt 77BA0000 77BF9FFF 0005a000

2009-07-30 16:59:03.72 spid14s * MSVCP80 7C420000 7C4A6FFF 00087000

2009-07-30 16:59:03.72 spid14s * ADVAPI32 7D1E0000 7D27BFFF 0009c000

2009-07-30 16:59:03.72 spid14s * RPCRT4 77C50000 77CEEFFF 0009f000

2009-07-30 16:59:03.72 spid14s * Secur32 76F50000 76F62FFF 00013000

2009-07-30 16:59:03.72 spid14s * sqlos 344D0000 344D4FFF 00005000

2009-07-30 16:59:03.72 spid14s * USERENV 76920000 769E1FFF 000c2000

2009-07-30 16:59:03.72 spid14s * USER32 77380000 77410FFF 00091000

2009-07-30 16:59:03.72 spid14s * GDI32 77C00000 77C48FFF 00049000

2009-07-30 16:59:03.72 spid14s * WINMM 76AA0000 76ACCFFF 0002d000

2009-07-30 16:59:03.72 spid14s * opends60 333E0000 333E6FFF 00007000

2009-07-30 16:59:03.72 spid14s * NETAPI32 71C40000 71C96FFF 00057000

2009-07-30 16:59:03.72 spid14s * IMM32 76290000 762ACFFF 0001d000

2009-07-30 16:59:03.72 spid14s * psapi 76B70000 76B7AFFF 0000b000

2009-07-30 16:59:03.72 spid14s * instapi 48060000 48069FFF 0000a000

2009-07-30 16:59:03.72 spid14s * sqlevn70 4F610000 4F7B8FFF 001a9000

2009-07-30 16:59:03.72 spid14s * rsaenh 68000000 68034FFF 00035000

2009-07-30 16:59:03.72 spid14s * AUTHZ 76C40000 76C53FFF 00014000

2009-07-30 16:59:03.72 spid14s * MSCOREE 33DC0000 33E04FFF 00045000

2009-07-30 16:59:03.72 spid14s * ole32 77670000 777A8FFF 00139000

2009-07-30 16:59:03.72 spid14s * msv1_0 76C90000 76CB6FFF 00027000

2009-07-30 16:59:03.72 spid14s * WS2_32 71C00000 71C16FFF 00017000

2009-07-30 16:59:03.72 spid14s * WS2HELP 71BF0000 71BF7FFF 00008000

2009-07-30 16:59:03.72 spid14s * iphlpapi 76CF0000 76D09FFF 0001a000

2009-07-30 16:59:03.72 spid14s * kerberos 341F0000 34247FFF 00058000

2009-07-30 16:59:03.72 spid14s * cryptdll 766E0000 766EBFFF 0000c000

2009-07-30 16:59:03.72 spid14s * MSASN1 34250000 34261FFF 00012000

2009-07-30 16:59:03.72 spid14s * schannel 76750000 76776FFF 00027000

2009-07-30 16:59:03.72 spid14s * CRYPT32 34280000 34312FFF 00093000

2009-07-30 16:59:03.72 spid14s * COMRES 77010000 770D5FFF 000c6000

2009-07-30 16:59:03.72 spid14s * XOLEHLP 34360000 34365FFF 00006000

2009-07-30 16:59:03.72 spid14s * MSDTCPRX 34370000 343E8FFF 00079000

2009-07-30 16:59:03.72 spid14s * OLEAUT32 77D00000 77D8AFFF 0008b000

2009-07-30 16:59:03.72 spid14s * msvcp60 343F0000 34454FFF 00065000

2009-07-30 16:59:03.72 spid14s * MTXCLU 34460000 34478FFF 00019000

2009-07-30 16:59:03.72 spid14s * VERSION 77B90000 77B97FFF 00008000

2009-07-30 16:59:03.72 spid14s * WSOCK32 71BB0000 71BB8FFF 00009000

2009-07-30 16:59:03.72 spid14s * CLUSAPI 34480000 34491FFF 00012000

2009-07-30 16:59:03.72 spid14s * RESUTILS 344A0000 344B2FFF 00013000

2009-07-30 16:59:03.72 spid14s * mswsock 71B20000 71B60FFF 00041000

2009-07-30 16:59:03.72 spid14s * DNSAPI 76ED0000 76EF9FFF 0002a000

2009-07-30 16:59:03.72 spid14s * winrnr 76F70000 76F76FFF 00007000

2009-07-30 16:59:03.72 spid14s * WLDAP32 76F10000 76F3DFFF 0002e000

2009-07-30 16:59:03.72 spid14s * rasadhlp 76F80000 76F84FFF 00005000

2009-07-30 16:59:03.72 spid14s * security 62860000 62863FFF 00004000

2009-07-30 16:59:03.72 spid14s * dssenh 68100000 68126FFF 00027000

2009-07-30 16:59:03.72 spid14s * hnetcfg 62E90000 62EE9FFF 0005a000

2009-07-30 16:59:03.72 spid14s * wshtcpip 71AE0000 71AE7FFF 00008000

2009-07-30 16:59:03.72 spid14s * NTMARTA 77E00000 77E20FFF 00021000

2009-07-30 16:59:03.72 spid14s * SAMLIB 7E020000 7E02EFFF 0000f000

2009-07-30 16:59:03.72 spid14s * msfte 62FB0000 63208FFF 00259000

2009-07-30 16:59:03.72 spid14s * dbghelp 63220000 63334FFF 00115000

2009-07-30 16:59:03.72 spid14s * WINTRUST 76BB0000 76BDAFFF 0002b000

2009-07-30 16:59:03.72 spid14s * imagehlp 76C10000 76C37FFF 00028000

2009-07-30 16:59:03.72 spid14s * ntdsapi 766F0000 76703FFF 00014000

2009-07-30 16:59:03.72 spid14s * xpsp2res 635A0000 63864FFF 002c5000

2009-07-30 16:59:03.72 spid14s * CLBCatQ 777B0000 77832FFF 00083000

2009-07-30 16:59:03.72 spid14s * sqlncli 63890000 63AB6FFF 00227000

2009-07-30 16:59:03.72 spid14s * COMCTL32 77530000 775C6FFF 00097000

2009-07-30 16:59:03.72 spid14s * comdlg32 762B0000 762F8FFF 00049000

2009-07-30 16:59:03.72 spid14s * SHLWAPI 77DA0000 77DF1FFF 00052000

2009-07-30 16:59:03.72 spid14s * SHELL32 7C8D0000 7D0CEFFF 007ff000

2009-07-30 16:59:03.72 spid14s * comctl32 77420000 77522FFF 00103000

2009-07-30 16:59:03.72 spid14s * SQLNCLIR 63B10000 63B42FFF 00033000

2009-07-30 16:59:03.72 spid14s * msftepxy 63DD0000 63DE4FFF 00015000

2009-07-30 16:59:03.72 spid14s * xpstar90 641C0000 6420AFFF 0004b000

2009-07-30 16:59:03.72 spid14s * SQLSCM90 64220000 64228FFF 00009000

2009-07-30 16:59:03.72 spid14s * ODBC32 64240000 6427CFFF 0003d000

2009-07-30 16:59:03.72 spid14s * BatchParser90 64280000 6429EFFF 0001f000

2009-07-30 16:59:03.72 spid14s * ATL80 7C630000 7C64AFFF 0001b000

2009-07-30 16:59:03.72 spid14s * odbcint 64400000 64416FFF 00017000

2009-07-30 16:59:03.72 spid14s * xpstar90 64420000 64445FFF 00026000

2009-07-30 16:59:03.72 spid14s * dbghelp 644D0000 645E4FFF 00115000

2009-07-30 16:59:03.72 spid14s *

2009-07-30 16:59:03.72 spid14s * Edi: 62AFE358: 00140E58 781580A6 62AFE870 00000000 78158027 0B2CBC2F

2009-07-30 16:59:03.72 spid14s * Esi: 00000000:

2009-07-30 16:59:03.72 spid14s * Eax: 62AFE23C: 000042AC 00000000 00000000 77E4BEF7 00000000 7C827739

2009-07-30 16:59:03.72 spid14s * Ebx: FFFFFFFF:

2009-07-30 16:59:03.72 spid14s * Ecx: 62AFE8AC: 00000000 00010007 00000000 0090008E 00140E5C 62AFE26C

2009-07-30 16:59:03.73 spid14s * Edx: FFFFFFFF:

2009-07-30 16:59:03.73 spid14s * Eip: 77E4BEF7: 10C2C95E 01093D00 840FC000 00000095 F29DE950 9090FFFF

2009-07-30 16:59:03.73 spid14s * Ebp: 62AFE28C: 62AFE2D0 021AE96C 000042AC 00000000 00000000 00000000

2009-07-30 16:59:03.73 spid14s * SegCs: 0030001B: 6B8008E1 014001E1 54E07800 6C3288E1 010003E1 6006E800

2009-07-30 16:59:03.73 spid14s * EFlags: 00000246:

2009-07-30 16:59:03.73 spid14s * Esp: 62AFE238: 03F747D8 000042AC 00000000 00000000 77E4BEF7 00000000

2009-07-30 16:59:03.73 spid14s * SegSs: 78130023: 00000000 00000000 00000000 00000000 00000000 00000000

2009-07-30 16:59:03.73 spid14s * *******************************************************************************

2009-07-30 16:59:03.73 spid14s * -------------------------------------------------------------------------------

2009-07-30 16:59:03.73 spid14s * Short Stack Dump

2009-07-30 16:59:03.74 spid14s 77E4BEF7 Module(kernel32+0000BEF7)

2009-07-30 16:59:03.74 spid14s 021AE96C Module(sqlservr+011AE96C)

2009-07-30 16:59:03.74 spid14s 021B2880 Module(sqlservr+011B2880)

2009-07-30 16:59:03.74 spid14s 021B242D Module(sqlservr+011B242D)

2009-07-30 16:59:03.74 spid14s 015C4F15 Module(sqlservr+005C4F15)

2009-07-30 16:59:03.74 spid14s 010B6518 Module(sqlservr+000B6518)

2009-07-30 16:59:03.74 spid14s 023D1135 Module(sqlservr+013D1135)

2009-07-30 16:59:03.74 spid14s 01090057 Module(sqlservr+00090057)

2009-07-30 16:59:03.74 spid14s 01090205 Module(sqlservr+00090205)

2009-07-30 16:59:03.74 spid14s 01090277 Module(sqlservr+00090277)

2009-07-30 16:59:03.74 spid14s 0108FBF2 Module(sqlservr+0008FBF2)

2009-07-30 16:59:03.74 spid14s 0108F8C1 Module(sqlservr+0008F8C1)

2009-07-30 16:59:03.74 spid14s 01087D0E Module(sqlservr+00087D0E)

2009-07-30 16:59:03.74 spid14s 01087DAD Module(sqlservr+00087DAD)

2009-07-30 16:59:03.74 spid14s 010879EA Module(sqlservr+000879EA)

2009-07-30 16:59:03.74 spid14s 01087B9F Module(sqlservr+00087B9F)

2009-07-30 16:59:03.74 spid14s 010067D3 Module(sqlservr+000067D3)

2009-07-30 16:59:03.74 spid14s 010068F9 Module(sqlservr+000068F9)

2009-07-30 16:59:03.74 spid14s 01006609 Module(sqlservr+00006609)

2009-07-30 16:59:03.74 spid14s 010DAF6C Module(sqlservr+000DAF6C)

2009-07-30 16:59:03.74 spid14s 010DAE8C Module(sqlservr+000DAE8C)

2009-07-30 16:59:03.74 spid14s 010DAB54 Module(sqlservr+000DAB54)

2009-07-30 16:59:03.75 spid14s 010DACF1 Module(sqlservr+000DACF1)

2009-07-30 16:59:03.75 spid14s 781329AA Module(MSVCR80+000029AA)

2009-07-30 16:59:03.76 spid14s 78132A36 Module(MSVCR80+00002A36)

2009-07-30 16:59:03.80 spid14s * -------------------------------------------------------------------------------

2009-07-30 16:59:03.84 spid14s Stack Signature for the dump is 0x76976582

2009-07-30 16:59:05.11 spid14s External dump process return code 0x20000001.

External dump process returned no errors.

2009-07-30 16:59:05.11 spid14s DoMiniDump () encountered error (0x800703E6) - Invalid access to memory location.

2009-07-30 16:59:05.11 spid14s ex_raise2: Exception raised, major=52, minor=42, state=1, severity=22, attempting to create symptom dump

2009-07-30 16:59:05.13 spid14s Using 'dbghelp.dll' version '4.0.5'

2009-07-30 16:59:05.14 spid14s **Dump thread - spid = 14, PSS = 0x03F747D8, EC = 0x03F747E0

2009-07-30 16:59:05.14 spid14s *

2009-07-30 16:59:05.14 spid14s * User initiated stack dump. This is not a server exception dump.

2009-07-30 16:59:05.14 spid14s *

2009-07-30 16:59:05.14 spid14s ***Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLDump0013.txt

2009-07-30 16:59:05.14 spid14s * *******************************************************************************

2009-07-30 16:59:05.14 spid14s *

2009-07-30 16:59:05.14 spid14s * BEGIN STACK DUMP:

2009-07-30 16:59:05.14 spid14s * 07/30/09 16:59:05 spid 14

2009-07-30 16:59:05.14 spid14s *

2009-07-30 16:59:05.14 spid14s * ex_raise2: Exception raised, major=52, minor=42, state=1, severity=22

2009-07-30 16:59:05.14 spid14s *

2009-07-30 16:59:05.14 spid14s * MODULE BASE END SIZE

2009-07-30 16:59:05.14 spid14s * sqlservr 01000000 02C1FFFF 01c20000

2009-07-30 16:59:05.14 spid14s * ntdll 7C800000 7C8C1FFF 000c2000

2009-07-30 16:59:05.14 spid14s * kernel32 77E40000 77F41FFF 00102000

2009-07-30 16:59:05.14 spid14s * MSVCR80 78130000 781CAFFF 0009b000

2009-07-30 16:59:05.14 spid14s * msvcrt 77BA0000 77BF9FFF 0005a000

2009-07-30 16:59:05.14 spid14s * MSVCP80 7C420000 7C4A6FFF 00087000

2009-07-30 16:59:05.14 spid14s * ADVAPI32 7D1E0000 7D27BFFF 0009c000

2009-07-30 16:59:05.14 spid14s * RPCRT4 77C50000 77CEEFFF 0009f000

2009-07-30 16:59:05.14 spid14s * Secur32 76F50000 76F62FFF 00013000

2009-07-30 16:59:05.14 spid14s * sqlos 344D0000 344D4FFF 00005000

2009-07-30 16:59:05.14 spid14s * USERENV 76920000 769E1FFF 000c2000

2009-07-30 16:59:05.14 spid14s * USER32 77380000 77410FFF 00091000

2009-07-30 16:59:05.14 spid14s * GDI32 77C00000 77C48FFF 00049000

2009-07-30 16:59:05.14 spid14s * WINMM 76AA0000 76ACCFFF 0002d000

2009-07-30 16:59:05.14 spid14s * opends60 333E0000 333E6FFF 00007000

2009-07-30 16:59:05.14 spid14s * NETAPI32 71C40000 71C96FFF 00057000

2009-07-30 16:59:05.14 spid14s * IMM32 76290000 762ACFFF 0001d000

2009-07-30 16:59:05.14 spid14s * psapi 76B70000 76B7AFFF 0000b000

2009-07-30 16:59:05.14 spid14s * instapi 48060000 48069FFF 0000a000

2009-07-30 16:59:05.14 spid14s * sqlevn70 4F610000 4F7B8FFF 001a9000

2009-07-30 16:59:05.14 spid14s * rsaenh 68000000 68034FFF 00035000

2009-07-30 16:59:05.14 spid14s * AUTHZ 76C40000 76C53FFF 00014000

2009-07-30 16:59:05.14 spid14s * MSCOREE 33DC0000 33E04FFF 00045000

2009-07-30 16:59:05.14 spid14s * ole32 77670000 777A8FFF 00139000

2009-07-30 16:59:05.14 spid14s * msv1_0 76C90000 76CB6FFF 00027000

2009-07-30 16:59:05.14 spid14s * WS2_32 71C00000 71C16FFF 00017000

2009-07-30 16:59:05.14 spid14s * WS2HELP 71BF0000 71BF7FFF 00008000

2009-07-30 16:59:05.14 spid14s * iphlpapi 76CF0000 76D09FFF 0001a000

2009-07-30 16:59:05.14 spid14s * kerberos 341F0000 34247FFF 00058000

2009-07-30 16:59:05.14 spid14s * cryptdll 766E0000 766EBFFF 0000c000

2009-07-30 16:59:05.14 spid14s * MSASN1 34250000 34261FFF 00012000

2009-07-30 16:59:05.14 spid14s * schannel 76750000 76776FFF 00027000

2009-07-30 16:59:05.14 spid14s * CRYPT32 34280000 34312FFF 00093000

2009-07-30 16:59:05.14 spid14s * COMRES 77010000 770D5FFF 000c6000

2009-07-30 16:59:05.14 spid14s * XOLEHLP 34360000 34365FFF 00006000

2009-07-30 16:59:05.15 spid14s * MSDTCPRX 34370000 343E8FFF 00079000

2009-07-30 16:59:05.15 spid14s * OLEAUT32 77D00000 77D8AFFF 0008b000

2009-07-30 16:59:05.15 spid14s * msvcp60 343F0000 34454FFF 00065000

2009-07-30 16:59:05.15 spid14s * MTXCLU 34460000 34478FFF 00019000

2009-07-30 16:59:05.15 spid14s * VERSION 77B90000 77B97FFF 00008000

2009-07-30 16:59:05.15 spid14s * WSOCK32 71BB0000 71BB8FFF 00009000

2009-07-30 16:59:05.15 spid14s * CLUSAPI 34480000 34491FFF 00012000

2009-07-30 16:59:05.15 spid14s * RESUTILS 344A0000 344B2FFF 00013000

2009-07-30 16:59:05.15 spid14s * mswsock 71B20000 71B60FFF 00041000

2009-07-30 16:59:05.15 spid14s * DNSAPI 76ED0000 76EF9FFF 0002a000

2009-07-30 16:59:05.15 spid14s * winrnr 76F70000 76F76FFF 00007000

2009-07-30 16:59:05.15 spid14s * WLDAP32 76F10000 76F3DFFF 0002e000

2009-07-30 16:59:05.15 spid14s * rasadhlp 76F80000 76F84FFF 00005000

2009-07-30 16:59:05.15 spid14s * security 62860000 62863FFF 00004000

2009-07-30 16:59:05.15 spid14s * dssenh 68100000 68126FFF 00027000

2009-07-30 16:59:05.15 spid14s * hnetcfg 62E90000 62EE9FFF 0005a000

2009-07-30 16:59:05.15 spid14s * wshtcpip 71AE0000 71AE7FFF 00008000

2009-07-30 16:59:05.15 spid14s * NTMARTA 77E00000 77E20FFF 00021000

2009-07-30 16:59:05.15 spid14s * SAMLIB 7E020000 7E02EFFF 0000f000

2009-07-30 16:59:05.15 spid14s * msfte 62FB0000 63208FFF 00259000

2009-07-30 16:59:05.15 spid14s * dbghelp 63220000 63334FFF 00115000

2009-07-30 16:59:05.15 spid14s * WINTRUST 76BB0000 76BDAFFF 0002b000

2009-07-30 16:59:05.15 spid14s * imagehlp 76C10000 76C37FFF 00028000

2009-07-30 16:59:05.15 spid14s * ntdsapi 766F0000 76703FFF 00014000

2009-07-30 16:59:05.15 spid14s * xpsp2res 635A0000 63864FFF 002c5000

2009-07-30 16:59:05.15 spid14s * CLBCatQ 777B0000 77832FFF 00083000

2009-07-30 16:59:05.15 spid14s * sqlncli 63890000 63AB6FFF 00227000

2009-07-30 16:59:05.15 spid14s * COMCTL32 77530000 775C6FFF 00097000

2009-07-30 16:59:05.15 spid14s * comdlg32 762B0000 762F8FFF 00049000

2009-07-30 16:59:05.15 spid14s * SHLWAPI 77DA0000 77DF1FFF 00052000

2009-07-30 16:59:05.15 spid14s * SHELL32 7C8D0000 7D0CEFFF 007ff000

2009-07-30 16:59:05.15 spid14s * comctl32 77420000 77522FFF 00103000

2009-07-30 16:59:05.15 spid14s * SQLNCLIR 63B10000 63B42FFF 00033000

2009-07-30 16:59:05.15 spid14s * msftepxy 63DD0000 63DE4FFF 00015000

2009-07-30 16:59:05.15 spid14s * xpstar90 641C0000 6420AFFF 0004b000

2009-07-30 16:59:05.15 spid14s * SQLSCM90 64220000 64228FFF 00009000

2009-07-30 16:59:05.15 spid14s * ODBC32 64240000 6427CFFF 0003d000

2009-07-30 16:59:05.15 spid14s * BatchParser90 64280000 6429EFFF 0001f000

2009-07-30 16:59:05.15 spid14s * ATL80 7C630000 7C64AFFF 0001b000

2009-07-30 16:59:05.15 spid14s * odbcint 64400000 64416FFF 00017000

2009-07-30 16:59:05.15 spid14s * xpstar90 64420000 64445FFF 00026000

2009-07-30 16:59:05.15 spid14s * dbghelp 644D0000 645E4FFF 00115000

2009-07-30 16:59:05.15 spid14s *

2009-07-30 16:59:05.15 spid14s * Edi: 62AFE358: 00140E58 781580A6 62AFE870 00000000 78158027 0B2CBC2F

2009-07-30 16:59:05.15 spid14s * Esi: 00000000:

2009-07-30 16:59:05.15 spid14s * Eax: 62AFE23C: 000042AC 00000000 00000000 77E4BEF7 00000000 7C827739

2009-07-30 16:59:05.15 spid14s * Ebx: FFFFFFFF:

2009-07-30 16:59:05.15 spid14s * Ecx: 62AFE8AC: 00000000 00010007 00000000 0090008E 00140E5C 62AFE26C

2009-07-30 16:59:05.15 spid14s * Edx: FFFFFFFF:

2009-07-30 16:59:05.15 spid14s * Eip: 77E4BEF7: 10C2C95E 01093D00 840FC000 00000095 F29DE950 9090FFFF

2009-07-30 16:59:05.15 spid14s * Ebp: 62AFE28C: 62AFE2D0 021AE96C 000042AC 00000000 00000000 00000000

2009-07-30 16:59:05.15 spid14s * SegCs: 0030001B: 6B8008E1 014001E1 54E07800 6C3288E1 010003E1 6006E800

2009-07-30 16:59:05.15 spid14s * EFlags: 00000246:

2009-07-30 16:59:05.15 spid14s * Esp: 62AFE238: 03F747D8 000042AC 00000000 00000000 77E4BEF7 00000000

2009-07-30 16:59:05.15 spid14s * SegSs: 78130023: 00000000 00000000 00000000 00000000 00000000 00000000

2009-07-30 16:59:05.15 spid14s * *******************************************************************************

2009-07-30 16:59:05.15 spid14s * -------------------------------------------------------------------------------

2009-07-30 16:59:05.15 spid14s * Short Stack Dump

2009-07-30 16:59:05.16 spid14s 77E4BEF7 Module(kernel32+0000BEF7)

2009-07-30 16:59:05.16 spid14s 021AE96C Module(sqlservr+011AE96C)

2009-07-30 16:59:05.16 spid14s 021B2880 Module(sqlservr+011B2880)

2009-07-30 16:59:05.16 spid14s 021B242D Module(sqlservr+011B242D)

2009-07-30 16:59:05.16 spid14s 015C4F15 Module(sqlservr+005C4F15)

2009-07-30 16:59:05.16 spid14s 010B6518 Module(sqlservr+000B6518)

2009-07-30 16:59:05.16 spid14s 023D1135 Module(sqlservr+013D1135)

2009-07-30 16:59:05.16 spid14s 01090057 Module(sqlservr+00090057)

2009-07-30 16:59:05.16 spid14s 01090205 Module(sqlservr+00090205)

2009-07-30 16:59:05.16 spid14s 01090277 Module(sqlservr+00090277)

2009-07-30 16:59:05.16 spid14s 0108FBF2 Module(sqlservr+0008FBF2)

2009-07-30 16:59:05.16 spid14s 0108F8C1 Module(sqlservr+0008F8C1)

2009-07-30 16:59:05.16 spid14s 01087D0E Module(sqlservr+00087D0E)

2009-07-30 16:59:05.16 spid14s 01087DAD Module(sqlservr+00087DAD)

2009-07-30 16:59:05.16 spid14s 010879EA Module(sqlservr+000879EA)

2009-07-30 16:59:05.16 spid14s 01087B9F Module(sqlservr+00087B9F)

2009-07-30 16:59:05.16 spid14s 010067D3 Module(sqlservr+000067D3)

2009-07-30 16:59:05.16 spid14s 010068F9 Module(sqlservr+000068F9)

2009-07-30 16:59:05.16 spid14s 01006609 Module(sqlservr+00006609)

2009-07-30 16:59:05.16 spid14s 010DAF6C Module(sqlservr+000DAF6C)

2009-07-30 16:59:05.16 spid14s 010DAE8C Module(sqlservr+000DAE8C)

2009-07-30 16:59:05.16 spid14s 010DAB54 Module(sqlservr+000DAB54)

2009-07-30 16:59:05.17 spid14s 010DACF1 Module(sqlservr+000DACF1)

2009-07-30 16:59:05.17 spid14s 781329AA Module(MSVCR80+000029AA)

2009-07-30 16:59:05.18 spid14s 78132A36 Module(MSVCR80+00002A36)

2009-07-30 16:59:05.22 spid14s * -------------------------------------------------------------------------------

2009-07-30 16:59:05.26 spid14s Stack Signature for the dump is 0x76976582

Any ideas?

Thanks,

Q

Steve Jones - SSC Editor SSC Guru Points: 736211 More actions · Answer 3

Check SPID 14

User initiated stack dump. This is not a server exception dump.

Not sure what is running, but something appears to be calling a dump.

abishekshroff SSCrazy Points: 2040 More actions · Answer 4

this is a acees violation dump. open a case with MS. it is going to be a bug for sure