Post reply

Error log and Stack Dump

  • July 18, 2005 at 3:35 pm

    #109818

    SQLServer Gurus:

    Does anyone know how to change the default location of the Stack dump that gets generated upon error (fatal errors, EXCEPTION_INT_DIVIDE_BY_ZERO..etc). By default SQLServer places them in C:\Program Files\Microsoft SQL Server\MSSQL\log\... with a dmp and a txt files.

    I would like to change it to F:\MSSQL\LOG\

    Thanks in advance.

  • July 19, 2005 at 8:32 am

    #575499

    This is one of the startup parameters for a SQL instance.  If you right click on the instance in enterprise manager and select startup paramenters on the General tab you can edit it.  You will need to restart the instance after doing this.

    Regards,

    Jason P. Burnett
    Senior DBA

  • July 19, 2005 at 8:35 am

    #575502

    I also forgot to mention that if you wish to change the logs from the SQLAgent you will need to right click on it also and modify it's log file path.  Maintenance plan logs will need to be modified on a per maintenance plan basis also.

    Hope this helps.

    Jason

    Regards,

    Jason P. Burnett
    Senior DBA

  • July 19, 2005 at 1:26 pm

    #575632

    Both are in place as mentioned above by Jason; however, the mini dumps are still occuring in c:\....\log

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

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