Post reply

Trace File Naming Convention

  • September 19, 2011 at 6:40 am

    #243300

    Hello,

    I'm a junior DBA and am trying to filter out specific event classes from the default trace file. My script currently calls whatever the latest trace file is named. however, I have to check the name of the file manually every time before I run it to make sure it hasn't changed. From what I understand, the default trace file increments by one after it grows to a specific size and a new one is created.

    All I would like to achieve is to set it to a static name and have the archived trace file names be incremented by 1 instead of the active one. I hope i was clear enough.

    Thanks in advance for your help

    Jay

  • September 19, 2011 at 6:45 am

    #1383278

    You cannot make any changes to the default trace. You can't change the name of the files, number of files, size of files or events in any way.

    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

  • September 19, 2011 at 6:49 am

    #1383281

    Ok, thanks for your quick reply Gail!

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

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