asked on

MDMP files and SQLDmpr

We had a power outage that caused corruption of almost all SharePoint Databases. The SQL Server generated lots of SQLDumpXXXX.txt and SQLdmpxxx.mdmp files in my C:\Program File\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\LOG folder. The size of LOG folder is over 150 GB. I was able to fix all databases and it stopped generating dump files. How can I reduce the size of LOG folder now? Can I delete SQLDumpXXXX.txt and SQLdmpxxx.mdmp files?
Thanks.

Anuj

These are serious SQL Server issues occurs because of memory problems, scheduler problems or access violation, database corruption etc, this memory dumps allows us to debug the cause. To stop this dumps being generated you have to find and fix the errors, so better start would be to check the SQL Server error log find out the the log entries just before the time where memory dump is generated (If possible post your error log here). This error log will have sufficient information to troubleshoot. If you are unlucky you should to contact Microsoft SQL Server CSS team.

Regarding deleting the memory dump, if you are running out of disk space its okay to delete the current memory dumps, but you may not able to debug the problem also if you are escalating to CSS team they may ask for these dumps.

logictrail

ASKER

SQLDump0001.txt
SQLDmpr9279.log

logictrail

ASKER

I've attached first and last (as I mentioned before those dump files stopped being generated after I fixed databases) dump files from SQLserver log folder.

Anuj

It looks like you have consistency errors in database "WSS_Logging" can you post the results of DBCC checkdb (WSS_Logging).

logictrail

ASKER

I do not see any errors. Can I safely remove old SQLDumpXXXX.txt and SQLdmpxxx.mdmp files from log folder?
WSS-Logging.txt

ASKER CERTIFIED SOLUTION

Anuj

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

logictrail

ASKER

I don't think we follow the same method you described. But. I moved all log files to external drive and there no errors or warnings so far. Thanks for your advice.