SQL LOG SIZE FULL ISSUE

Question

SQL LOG SIZE FULL ISSUE

rajesh.mekala

Mr or Mrs. 500

Points: 569
More actions
June 4, 2014 at 5:38 am

#308761

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

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

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

free_mascot One Orange Chip Points: 27169 More actions · Answer 1

what is .mpmp format?

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

rajesh.mekala Mr or Mrs. 500 Points: 569 More actions · Answer 2

rajesh.mekala

Mr or Mrs. 500

Points: 569

June 4, 2014 at 6:03 am

#1718783

Beatrix Kiddo SSC-Dedicated Points: 32407 More actions · Answer 3

Beatrix Kiddo

SSC-Dedicated

Points: 32407

June 4, 2014 at 6:03 am

#1718784

What recovery model is the database in?

HanShi SSC-Dedicated Points: 33506 More actions · Answer 4

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?

** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

rajesh.mekala Mr or Mrs. 500 Points: 569 More actions · Answer 5

rajesh.mekala

Mr or Mrs. 500

Points: 569

June 4, 2014 at 6:10 am

#1718788

Lempster SSCoach Points: 15651 More actions · Answer 6

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

rajesh.mekala Mr or Mrs. 500 Points: 569 More actions · Answer 7

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.

Lempster SSCoach Points: 15651 More actions · Answer 8

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

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

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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

rajesh.mekala Mr or Mrs. 500 Points: 569 More actions · Answer 10

rajesh.mekala

Mr or Mrs. 500

Points: 569

June 4, 2014 at 9:23 pm

#1719064

please expalin brifely this issue

rajesh.mekala Mr or Mrs. 500 Points: 569 More actions · Answer 11

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 ?

SQLRNNR SSC Guru Points: 281334 More actions · Answer 12

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

rajesh.mekala Mr or Mrs. 500 Points: 569 More actions · Answer 13

SQL server 2008r2 sp1 ,Regular basis fullbacjup and ddifferentail backups are running

SQLRNNR SSC Guru Points: 281334 More actions · Answer 14

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