Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL LOG SIZE FULL ISSUE


SQL LOG SIZE FULL ISSUE

Author
Message
rajesh.mekala
rajesh.mekala
Grasshopper
Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)

Group: General Forum Members
Points: 17 Visits: 37
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
free_mascot
free_mascot
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2879 Visits: 2235
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
rajesh.mekala
Grasshopper
Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)

Group: General Forum Members
Points: 17 Visits: 37

Beatrix Kiddo
Beatrix Kiddo
SSC Eights!
SSC Eights! (959 reputation)SSC Eights! (959 reputation)SSC Eights! (959 reputation)SSC Eights! (959 reputation)SSC Eights! (959 reputation)SSC Eights! (959 reputation)SSC Eights! (959 reputation)SSC Eights! (959 reputation)

Group: General Forum Members
Points: 959 Visits: 3563
What recovery model is the database in?
HanShi
HanShi
Hall of Fame
Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)

Group: General Forum Members
Points: 3051 Visits: 3633
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
rajesh.mekala
Grasshopper
Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)

Group: General Forum Members
Points: 17 Visits: 37

Lempster
Lempster
SSCrazy
SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)

Group: General Forum Members
Points: 2683 Visits: 1657
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
rajesh.mekala
Grasshopper
Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)

Group: General Forum Members
Points: 17 Visits: 37
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
Lempster
SSCrazy
SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)

Group: General Forum Members
Points: 2683 Visits: 1657
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
GilaMonster
GilaMonster
SSC-Forever
SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)

Group: General Forum Members
Points: 47295 Visits: 44392
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


Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search