Post reply

MDMP file

  • April 6, 2011 at 7:41 am

    #248489

    My SQL agent is failing and in error logs are showing that I don't have enough storage to deliver

    .mdmp file. I have 250 G available on that drive.

    1. How can I find out out how big is a file and can I make it smaller or do I need it at all.

    Thank you

  • April 6, 2011 at 12:49 pm

    #1308221

    .mdmp file is a dump file, and it by default is written under the LOG folder. This location can be changed by launching Configuration Manager, right-clicking on the service instance to select Properties, and then switching to the Advanced tab. This will show you the current value of your Dump Directory and allow you to change it. NOTE: I think the change only takes affect on a restart.

    Have Fun!
    Ronzo

  • April 6, 2011 at 1:15 pm

    #1308237

    I need right click on SQLAgent or SQLServer? if yes I don't see any how big is the file.

    Thank you

  • April 6, 2011 at 1:25 pm

    #1308245

    Sorry, wasn't directly answering your question on size. I was guessing that perhaps it was trying to write the file to a location with very little free space instead of the drive with lots of GB.

    Have Fun!
    Ronzo

  • April 6, 2011 at 2:36 pm

    #1308285

    that location is 250gb

Viewing 5 posts - 1 through 4 (of 4 total)

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