June 4, 2014 at 5:38 am
Dear Team,
To day I logon SQL server 2008 pronunciation then i have checked Log folder but log flooder size is occupied 90gb .Then i have deleted 90gb log files again with in mints create new files SQLDUMP01123.mpmp format all files .and i have created one job and daily maintenance cleanup task for reducing log size but still growing log size.
Please help me this issue asap.
Thanks & Regards,
Rajesh M
SQL DBA
June 4, 2014 at 5:48 am
what is .mpmp format?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 4, 2014 at 6:03 am
June 4, 2014 at 6:03 am
What recovery model is the database in?
June 4, 2014 at 6:06 am
The file extention MPMP is not a default SQL extention, so probably it is generated by some other process. Can you see who created (is owner of) these files?
Perhaps a longshot, but this could give some information for you to sort out: http://serverfault.com/questions/29816/what-is-the-sqldump-file-for
Another possible option (again a longshot): some kind of export process (like: http://sqldump.sourceforge.net/) is extracting the data from the database to flat files on disk?
June 4, 2014 at 6:10 am
June 4, 2014 at 6:15 am
HanShi (6/4/2014)
The file extention MPMP is not a default SQL extention, so probably it is generated by some other process. Can you see who created (is owner of) these files?Perhaps a longshot, but this could give some information for you to sort out: http://serverfault.com/questions/29816/what-is-the-sqldump-file-for
Another possible option (again a longshot): some kind of export process (like: http://sqldump.sourceforge.net/) is extracting the data from the database to flat files on disk?
I think what the OP is probably referring to is a SQL Server mini-dump file.
To the OP, as previously requested, what Recovery Model are you using? If it's Full then you should be taking regular transaction log backups.
Regards
Lempster
June 4, 2014 at 6:18 am
this is not database related issue when i have open C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\sqldmpr0112.mdmp unlimted new files creted this reason drive is full plese help me.
June 4, 2014 at 7:55 am
Ah, okay, you're running out of space on that drive because of the mdmp file. Do you have any of the following trace flags enabled?:
Trace Flag 2551: Produces a filtered memory dump
Trace Flag 2544: Produces a full memory dump
Trace Flag 2546: Dumps all threads for SQL Server in the dump file
You can check by running DBCC TRACESTATUS. A value of 1 in the Status column indicates that the trace flag is on, a 0 means that it is off.
Regards
Lempster
June 4, 2014 at 7:57 am
free_mascot (6/4/2014)
what is .mpmp format?
It's a mini-dump file. Written when SQL throws access violations or similar severe errors. The goal should be identifying why SQL is throwing access violations and fixing the cause.
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
June 4, 2014 at 9:23 pm
please expalin brifely this issue
June 4, 2014 at 9:36 pm
Thanks for your support , i just want to take conformantion ,now current satus is tarceflag is in enble mode,should i need chnge to disble the tarce flag ?
June 4, 2014 at 9:38 pm
Mini dumps can be created for a number of reasons.
What is the patch level of your server?
Do you have CLR enabled?
Do you have certain jobs that run on a regular basis that might correlate to the timing of the creation of these mini-dumps?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 4, 2014 at 9:43 pm
SQL server 2008r2 sp1 ,Regular basis fullbacjup and ddifferentail backups are running
June 4, 2014 at 9:45 pm
So the full backups and the differential backups are running at the same times that the mini-dumps are created?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 15 posts - 1 through 15 (of 24 total)
You must be logged in to reply to this topic. Login to reply