Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

SQL LOG SIZE FULL ISSUE Expand / Collapse
Author
Message
Posted Wednesday, June 4, 2014 5:38 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, July 14, 2014 11:53 PM
Points: 17, Visits: 32
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
Post #1577267
Posted Wednesday, June 4, 2014 5:48 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
what is .mpmp format?

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Post #1577271
Posted Wednesday, June 4, 2014 6:03 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, July 14, 2014 11:53 PM
Points: 17, Visits: 32
Post #1577274
Posted Wednesday, June 4, 2014 6:03 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 2:56 AM
Points: 451, Visits: 1,665
What recovery model is the database in?
Post #1577275
Posted Wednesday, June 4, 2014 6:06 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 1:18 AM
Points: 2,224, Visits: 2,660
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’! **
Post #1577277
Posted Wednesday, June 4, 2014 6:10 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, July 14, 2014 11:53 PM
Points: 17, Visits: 32
Post #1577280
Posted Wednesday, June 4, 2014 6:15 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 4:50 AM
Points: 2,036, Visits: 1,374
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
Post #1577283
Posted Wednesday, June 4, 2014 6:18 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, July 14, 2014 11:53 PM
Points: 17, Visits: 32
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.
Post #1577284
Posted Wednesday, June 4, 2014 7:55 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 4:50 AM
Points: 2,036, Visits: 1,374
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
Post #1577339
Posted Wednesday, June 4, 2014 7:57 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:23 AM
Points: 42,444, Visits: 35,500
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 2008, MVP
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

Post #1577341
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse