请教一个关于sql2005日志不断增加的问题

Question

我的Microsoft SQL Server\MSSQL.1\MSSQL\LOG文件夹下的.mdmp,.log和.txt日志文件不停的在增加，基本上第一秒就增加一次...一会儿就几个G了，是怎么回事?下面是.log文件里的信息，有没有高手帮忙看一下，好像我有装sharepoint，不知道有没有影响...
.log文件如下
2009-09-03 17:04:12.71 spid71      Using 'dbghelp.dll' version '4.0.5'
2009-09-03 17:04:12.73 Logon       Login succeeded for user 'NT AUTHORITY\SYSTEM'. Connection: trusted. [CLIENT: 10.35.60.134]
2009-09-03 17:04:13.03 spid71      ***Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLDump0234.txt
2009-09-03 17:04:13.03 spid71      SqlDumpExceptionHandler: Process 71 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
2009-09-03 17:04:13.03 spid71      * *******************************************************************************
2009-09-03 17:04:13.03 spid71      *
2009-09-03 17:04:13.03 spid71      * BEGIN STACK DUMP:
2009-09-03 17:04:13.03 spid71      *   09/03/09 17:04:13 spid 71
2009-09-03 17:04:13.03 spid71      *
2009-09-03 17:04:13.03 spid71      *
2009-09-03 17:04:13.03 spid71      *   Exception Address = 01105772 Module(sqlservr+00105772)
2009-09-03 17:04:13.03 spid71      *   Exception Code    = c0000005 EXCEPTION_ACCESS_VIOLATION
2009-09-03 17:04:13.03 spid71      *   Access Violation occurred reading address 00000000
2009-09-03 17:04:13.03 spid71      * Input Buffer 109 bytes -
2009-09-03 17:04:13.03 spid71      *    d b o . p r o c  17 00 64 00 62 00 6f 00 2e 00 70 00 72 00 6f 00 63 00
2009-09-03 17:04:13.03 spid71      *  _ M S S _ F l u s  5f 00 4d 00 53 00 53 00 5f 00 46 00 6c 00 75 00 73 00
2009-09-03 17:04:13.03 spid71      *  h T e m p 0     &  68 00 54 00 65 00 6d 00 70 00 30 00 00 00 00 00 26 04
2009-09-03 17:04:13.03 spid71      *   `'    &  d     &  04 60 27 00 00 00 00 26 04 04 64 00 00 00 00 00 26 04
2009-09-03 17:04:13.03 spid71      *   V     &  }     &  04 56 06 00 00 00 00 26 04 04 7d 0a 00 00 00 00 26 04
2009-09-03 17:04:13.03 spid71      *         &     ;  &  04 ff ff ff ff 00 00 26 04 04 00 ca 9a 3b 00 01 26 04
2009-09-03 17:04:13.03 spid71      *                     00
2009-09-03 17:04:13.03 spid71      *  
2009-09-03 17:04:13.03 spid71      *
2009-09-03 17:04:13.03 spid71      *  MODULE                          BASE      END       SIZE
2009-09-03 17:04:13.03 spid71      * sqlservr                       01000000  02BA7FFF  01ba8000
2009-09-03 17:04:13.03 spid71      * ntdll                          7C800000  7C8C1FFF  000c2000
2009-09-03 17:04:13.03 spid71      * kernel32                       77E40000  77F41FFF  00102000
2009-09-03 17:04:13.03 spid71      * MSVCR80                        78130000  781CAFFF  0009b000
2009-09-03 17:04:13.03 spid71      * msvcrt                         77BA0000  77BF9FFF  0005a000
2009-09-03 17:04:13.03 spid71      * MSVCP80                        7C420000  7C4A6FFF  00087000
2009-09-03 17:04:13.03 spid71      * ADVAPI32                       7D1E0000  7D27BFFF  0009c000
2009-09-03 17:04:13.03 spid71      * RPCRT4                         77C50000  77CEEFFF  0009f000
2009-09-03 17:04:13.03 spid71      * Secur32                        76F50000  76F62FFF  00013000
2009-09-03 17:04:13.03 spid71      * USER32                         77380000  77410FFF  00091000
2009-09-03 17:04:13.03 spid71      * GDI32                          77C00000  77C48FFF  00049000
2009-09-03 17:04:13.03 spid71      * CRYPT32                        761B0000  76242FFF  00093000
2009-09-03 17:04:13.03 spid71      * MSASN1                         76190000  761A1FFF  00012000
2009-09-03 17:04:13.03 spid71      * MSWSOCK                        71B20000  71B60FFF  00041000
2009-09-03 17:04:13.03 spid71      * WS2_32                         71C00000  71C16FFF  00017000
2009-09-03 17:04:13.03 spid71      * WS2HELP                        71BF0000  71BF7FFF  00008000
2009-09-03 17:04:13.03 spid71      * USERENV                        76920000  769E1FFF  000c2000
2009-09-03 17:04:13.03 spid71      * opends60                       333E0000  333E6FFF  00007000
2009-09-03 17:04:13.03 spid71      * NETAPI32                       71C40000  71C96FFF  00057000
2009-09-03 17:04:13.03 spid71      * SHELL32                        7C8D0000  7D0CEFFF  007ff000
2009-09-03 17:04:13.03 spid71      * SHLWAPI                        77DA0000  77DF1FFF  00052000
2009-09-03 17:04:13.03 spid71      * IMM32                          76290000  762ACFFF  0001d000
2009-09-03 17:04:13.03 spid71      * LPK                            7F000000  7F008FFF  00009000
2009-09-03 17:04:13.03 spid71      * USP10                          75490000  754F4FFF  00065000
2009-09-03 17:04:13.03 spid71      * comctl32                       77420000  77522FFF  00103000
2009-09-03 17:04:13.03 spid71      * psapi                          76B70000  76B7AFFF  0000b000
2009-09-03 17:04:13.03 spid71      * instapi                        48060000  48069FFF  0000a000
2009-09-03 17:04:13.03 spid71      * sqlevn70                       4F610000  4F7A0FFF  00191000
2009-09-03 17:04:13.03 spid71      * SQLOS                          344D0000  344D4FFF  00005000
2009-09-03 17:04:13.03 spid71      * rsaenh                         68000000  68034FFF  00035000
2009-09-03 17:04:13.03 spid71      * AUTHZ                          76C40000  76C53FFF  00014000
2009-09-03 17:04:13.03 spid71      * MSCOREE                        34100000  34144FFF  00045000
2009-09-03 17:04:13.03 spid71      * ole32                          77670000  777A8FFF  00139000
2009-09-03 17:04:13.03 spid71      * msv1_0                         76C90000  76CB6FFF  00027000
2009-09-03 17:04:13.03 spid71      * iphlpapi                       76CF0000  76D09FFF  0001a000
2009-09-03 17:04:13.03 spid71      * kerberos                       61B40000  61B97FFF  00058000
2009-09-03 17:04:13.03 spid71      * cryptdll                       766E0000  766EBFFF  0000c000
2009-09-03 17:04:13.03 spid71      * schannel                       76750000  76776FFF  00027000
2009-09-03 17:04:13.03 spid71      * COMRES                         77010000  770D5FFF  000c6000
2009-09-03 17:04:13.03 spid71      * XOLEHLP                        61C00000  61C05FFF  00006000
2009-09-03 17:04:13.03 spid71      * MSDTCPRX                       61C10000  61C88FFF  00079000

Answer 1

2009-09-03 17:04:13.03 spid71      * OLEAUT32                       77D00000  77D8AFFF  0008b000
2009-09-03 17:04:13.03 spid71      * msvcp60                        61C90000  61CF4FFF  00065000
2009-09-03 17:04:13.03 spid71      * MTXCLU                         74F40000  74F58FFF  00019000
2009-09-03 17:04:13.03 spid71      * VERSION                        77B90000  77B97FFF  00008000
2009-09-03 17:04:13.03 spid71      * WSOCK32                        71BB0000  71BB8FFF  00009000
2009-09-03 17:04:13.03 spid71      * CLUSAPI                        74DE0000  74DF1FFF  00012000
2009-09-03 17:04:13.03 spid71      * RESUTILS                       74EF0000  74F02FFF  00013000
2009-09-03 17:04:13.03 spid71      * FwcWsp                         61D10000  61D40FFF  00031000
2009-09-03 17:04:13.03 spid71      * DNSAPI                         76ED0000  76EF9FFF  0002a000
2009-09-03 17:04:13.03 spid71      * winrnr                         76F70000  76F76FFF  00007000
2009-09-03 17:04:13.03 spid71      * WLDAP32                        76F10000  76F3DFFF  0002e000
2009-09-03 17:04:13.03 spid71      * hnetcfg                        61E70000  61EC9FFF  0005a000
2009-09-03 17:04:13.03 spid71      * wshtcpip                       71AE0000  71AE7FFF  00008000
2009-09-03 17:04:13.03 spid71      * rasadhlp                       76F80000  76F84FFF  00005000
2009-09-03 17:04:13.03 spid71      * security                       622D0000  622D3FFF  00004000
2009-09-03 17:04:13.03 spid71      * dssenh                         68100000  68126FFF  00027000
2009-09-03 17:04:13.03 spid71      * msfte                          62900000  62B57FFF  00258000
2009-09-03 17:04:13.03 spid71      * dbghelp                        62B80000  62C97FFF  00118000
2009-09-03 17:04:13.03 spid71      * WINTRUST                       76BB0000  76BDAFFF  0002b000
2009-09-03 17:04:13.03 spid71      * imagehlp                       76C10000  76C37FFF  00028000
2009-09-03 17:04:13.03 spid71      * NTMARTA                        77E00000  77E20FFF  00021000
2009-09-03 17:04:13.03 spid71      * SAMLIB                         7E020000  7E02EFFF  0000f000
2009-09-03 17:04:13.03 spid71      * ntdsapi                        766F0000  76703FFF  00014000
2009-09-03 17:04:13.03 spid71      * xpsp2res                       62FE0000  632A4FFF  002c5000
2009-09-03 17:04:13.03 spid71      * CLBCatQ                        777B0000  77832FFF  00083000
2009-09-03 17:04:13.03 spid71      * sqlncli                        632B0000  634CDFFF  0021e000
2009-09-03 17:04:13.03 spid71      * COMCTL32                       77530000  775C6FFF  00097000
2009-09-03 17:04:13.03 spid71      * comdlg32                       762B0000  762F8FFF  00049000
2009-09-03 17:04:13.03 spid71      * SQLNCLIR                       00820000  00852FFF  00033000
2009-09-03 17:04:13.03 spid71      * msftepxy                       637E0000  637F4FFF  00015000
2009-09-03 17:04:13.03 spid71      * xpstar90                       63FF0000  64034FFF  00045000
2009-09-03 17:04:13.03 spid71      * SQLSCM90                       64050000  64058FFF  00009000
2009-09-03 17:04:13.03 spid71      * ODBC32                         64070000  640ACFFF  0003d000
2009-09-03 17:04:13.03 spid71      * BatchParser90                  640B0000  640CDFFF  0001e000
2009-09-03 17:04:13.03 spid71      * SQLSVC90                       640E0000  640F9FFF  0001a000
2009-09-03 17:04:13.03 spid71      * SqlResourceLoader              64110000  64115FFF  00006000
2009-09-03 17:04:13.03 spid71      * ATL80                          7C630000  7C64AFFF  0001b000
2009-09-03 17:04:13.03 spid71      * odbcint                        64270000  64286FFF  00017000
2009-09-03 17:04:13.03 spid71      * SQLSVC90                       64290000  64292FFF  00003000
2009-09-03 17:04:13.03 spid71      * xpstar90                       642A0000  642C5FFF  00026000
2009-09-03 17:04:13.03 spid71      * xpsqlbot                       34460000  34465FFF  00006000
2009-09-03 17:04:13.03 spid71      * xplog70                        34480000  3448BFFF  0000c000
2009-09-03 17:04:13.03 spid71      * xplog70                        344B0000  344B2FFF  00003000
2009-09-03 17:04:13.03 spid71      * dbghelp                        648D0000  649E7FFF  00118000
2009-09-03 17:04:13.03 spid71      *
2009-09-03 17:04:13.03 spid71      *        Edi: 40D323C0:  00000000  00000000  00000000  00000000  00000000  00000000  
2009-09-03 17:04:13.03 spid71      *        Esi: 40D323C0:  00000000  00000000  00000000  00000000  00000000  00000000  
2009-09-03 17:04:13.03 spid71      *        Eax: 627DDEC0:  627DDEF4  02450AD1  FFFFFFFF  627DDF00  013804D2  40D323C0  
2009-09-03 17:04:13.03 spid71      *        Ebx: 00000000:  
2009-09-03 17:04:13.03 spid71      *        Ecx: 00000000:  
2009-09-03 17:04:13.03 spid71      *        Edx: 00000040:  
2009-09-03 17:04:13.03 spid71      *        Eip: 01105772:  108B038B  CB8B016A  4D8BD2FF  F88B560C  FFDE39E8  89C033FF  
2009-09-03 17:04:13.03 spid71      *        Ebp: 627DDECC:  627DDF00  013804D2  40D323C0  3164C028  00000000  627D5A0D  
2009-09-03 17:04:13.03 spid71      *      SegCs: 0000001B:  
2009-09-03 17:04:13.03 spid71      *     EFlags: 00010202:  005C006E  004E0000  004D0055  00450042  005F0052  0046004F  
2009-09-03 17:04:13.03 spid71      *        Esp: 627DDEB0:  627D5BC1  40D323C0  3164C028  40D32368  627DDEF4  02450AD1  
2009-09-03 17:04:13.03 spid71      *      SegSs: 00000023:  
2009-09-03 17:04:13.03 spid71      * *******************************************************************************
2009-09-03 17:04:13.03 spid71      * -------------------------------------------------------------------------------
2009-09-03 17:04:13.03 spid71      * Short Stack Dump
2009-09-03 17:04:13.04 spid71      01105772 Module(sqlservr+00105772)
2009-09-03 17:04:13.04 spid71      013804D2 Module(sqlservr+003804D2)
2009-09-03 17:04:13.04 spid71      01439AD1 Module(sqlservr+00439AD1)
2009-09-03 17:04:13.04 spid71      0143995C Module(sqlservr+0043995C)
2009-09-03 17:04:13.04 spid71      01380F7A Module(sqlservr+00380F7A)
2009-09-03 17:04:13.04 spid71      01380EAF Module(sqlservr+00380EAF)
2009-09-03 17:04:13.04 spid71      01380EAF Module(sqlservr+00380EAF)
2009-09-03 17:04:13.04 spid71      01380EAF Module(sqlservr+00380EAF)
2009-09-03 17:04:13.04 spid71      01380EAF Module(sqlservr+00380EAF)
2009-09-03 17:04:13.04 spid71      01380EAF Module(sqlservr+00380EAF)
2009-09-03 17:04:13.04 spid71      01380EAF Module(sqlservr+00380EAF)
2009-09-03 17:04:13.04 spid71      013810A9 Module(sqlservr+003810A9)
2009-09-03 17:04:13.04 spid71      0125362A Module(sqlservr+0025362A)
2009-09-03 17:04:13.04 spid71      01253CCA Module(sqlservr+00253CCA)
2009-09-03 17:04:13.04 spid71      013CDC85 Module(sqlservr+003CDC85)
2009-09-03 17:04:13.04 spid71      013CDD56 Module(sqlservr+003CDD56)
2009-09-03 17:04:13.04 spid71      0125B712 Module(sqlservr+0025B712)
2009-09-03 17:04:13.04 spid71      0125B0B5 Module(sqlservr+0025B0B5)
2009-09-03 17:04:13.04 spid71      01320C83 Module(sqlservr+00320C83)
2009-09-03 17:04:13.04 spid71      0125B99F Module(sqlservr+0025B99F)
2009-09-03 17:04:13.04 spid71      0102C51D Module(sqlservr+0002C51D)
2009-09-03 17:04:13.04 spid71      011C1302 Module(sqlservr+001C1302)
2009-09-03 17:04:13.04 spid71      011C1179 Module(sqlservr+001C1179)
2009-09-03 17:04:13.04 spid71      011C100E Module(sqlservr+001C100E)
2009-09-03 17:04:13.04 spid71      0102DB52 Module(sqlservr+0002DB52)
2009-09-03 17:04:13.04 spid71      0102E0D0 Module(sqlservr+0002E0D0)
2009-09-03 17:04:13.04 spid71      0102C5F8 Module(sqlservr+0002C5F8)
2009-09-03 17:04:13.04 spid71      011C1302 Module(sqlservr+001C1302)
2009-09-03 17:04:13.04 spid71      011C1179 Module(sqlservr+001C1179)
2009-09-03 17:04:13.04 spid71      011C100E Module(sqlservr+001C100E)
2009-09-03 17:04:13.04 spid71      0102DB52 Module(sqlservr+0002DB52)
2009-09-03 17:04:13.04 spid71      0102E0D0 Module(sqlservr+0002E0D0)
2009-09-03 17:04:13.04 spid71      0102C5F8 Module(sqlservr+0002C5F8)
2009-09-03 17:04:13.04 spid71      010438E5 Module(sqlservr+000438E5)
2009-09-03 17:04:13.04 spid71      01041C35 Module(sqlservr+00041C35)
2009-09-03 17:04:13.04 spid71      0100889F Module(sqlservr+0000889F)
2009-09-03 17:04:13.04 spid71      010089C5 Module(sqlservr+000089C5)
2009-09-03 17:04:13.04 spid71      010086E7 Module(sqlservr+000086E7)
2009-09-03 17:04:13.04 spid71      010D764A Module(sqlservr+000D764A)
2009-09-03 17:04:13.04 spid71      010D7B71 Module(sqlservr+000D7B71)
2009-09-03 17:04:13.04 spid71      010D746E Module(sqlservr+000D746E)
2009-09-03 17:04:13.04 spid71      010D83F0 Module(sqlservr+000D83F0)
2009-09-03 17:04:13.04 spid71      781329BB Module(MSVCR80+000029BB)
2009-09-03 17:04:13.06 spid71      78132A47 Module(MSVCR80+00002A47)
2009-09-03 17:04:13.06 spid71      Stack Signature for the dump is 0x713ADF12
2009-09-03 17:04:13.87 spid71      External dump process return code 0x20000001.
External dump process returned no errors.2009-09-03 17:04:13.87 Server      Error: 17310, Severity: 20, State: 1.
2009-09-03 17:04:13.87 Server      A user request from the session with SPID 71 generated a fatal exception. SQL Server is terminating this session. Contact Product Support Services with the dump produced in the log directory.

Answer 2

请按步骤进行,未进行前面的步骤,请不要做后面的步骤   
   否则可能损坏你的数据库.   
    
    
   一般不建议做第4,6两步   
   第4步不安全,有可能损坏数据库或丢失数据   
   第6步如果日志达到上限,则以后的数据库处理会失败,在清理日志后才能恢复.   
   --*/   
    
   --下面的所有库名都指你要处理的数据库的库名   
    
   1.清空日志   
   DUMP      TRANSACTION      库名      WITH      NO_LOG           
    
   2.截断事务日志：   
   BACKUP    LOG    库名    WITH    NO_LOG   
    
   3.收缩数据库文件(如果不压缩,数据库的文件不会减小   
   企业管理器--右键你要压缩的数据库--所有任务--收缩数据库--收缩文件   
   --选择日志文件--在收缩方式里选择收缩至XXM,这里会给出一个允许收缩到的最小M数,直接输入这个数,确定就可以了   
   --选择数据文件--在收缩方式里选择收缩至XXM,这里会给出一个允许收缩到的最小M数,直接输入这个数,确定就可以了   
    
   也可以用SQL语句来完成   
   --收缩数据库   
   DBCC    SHRINKDATABASE(库名)   
    
   --收缩指定数据文件,1是文件号,可以通过这个语句查询到:select    *    from    sysfiles   
   DBCC    SHRINKFILE(1)   
    
   4.为了最大化的缩小日志文件(如果是sql    7.0,这步只能在查询分析器中进行)   
   a.分离数据库:   
   企业管理器--服务器--数据库--右键--分离数据库   
    
   b.在我的电脑中删除LOG文件   
    
   c.附加数据库:   
   企业管理器--服务器--数据库--右键--附加数据库   
    
   此法将生成新的LOG，大小只有500多K   
    
   或用代码：     
   下面的示例分离    pubs，然后将    pubs    中的一个文件附加到当前服务器。   
    
   a.分离   
   EXEC    sp_detach_db    @dbname    =    '库名'   
    
   b.删除日志文件   
    
   c.再附加   
   EXEC    sp_attach_single_file_db    @dbname    =    '库名',     
         @physname    =    'c:\Program    Files\Microsoft    SQL    Server\MSSQL\Data\库名.mdf'   
    
   5.为了以后能自动收缩,做如下设置:   
   企业管理器--服务器--右键数据库--属性--选项--选择"自动收缩"   
    
   --SQL语句设置方式:   
   EXEC    sp_dboption    '库名',    'autoshrink',    'TRUE'   
    
   6.如果想以后不让它日志增长得太大   
   企业管理器--服务器--右键数据库--属性--事务日志   
   --将文件增长限制为xM(x是你允许的最大数据文件大小)   
    
   --SQL语句的设置方式:   
   alter    database    库名    modify    file(name=逻辑文件名,maxsize=20)   

Answer 3

这个日志狂增的是管理-SQL Server日志，不是指定哪个库的日志....有人遇到过吗?

Answer 4

.mdmp 是转储文件。。一般是sql server 有错误的，如bug时才会产生的。
要需要专门的工具才能对其内容分析。
网上这方面的资料很少。。

Answer 5

要具体情况具体分析，有些东西不是bug引起的，你打补丁也没用。

Answer 6

二樓王兄的sql code很經典.