Post reply

default trace not creating trace file

  • April 11, 2018 at 6:38 am

    #336971

    default trace seems to be running but not creating file or creates one and writes nothing. also when i query the path for trace is NULL

  • April 11, 2018 at 6:43 am

    #1986327

    You can check if it's enabled by running:
    SELECT * FROM sys.configurations
    WHERE configuration_id = 1568
    GO

    Are you checking sys.traces for the location of the .trc file?

    Thanks

  • April 11, 2018 at 6:46 am

    #1986328

    did that and yes

  • April 11, 2018 at 6:56 am

    #1986331

    Have you had any space issues on any of the disks recently?

    You can also check the location of the trace file through the registry:

    HKEY_LOCAL_MACHINE\Software\Microsoft\<InstanceName>\Setup\SQLDataRoot

  • April 11, 2018 at 7:00 am

    #1986332

    no space issues and yes the path is in the registry which is the crazy thing
    when i create a generic trace that works just fine
    i need the default to work so i can check out the auto growth of the databases

  • April 11, 2018 at 7:04 am

    #1986336

    Have you tried disabling the default trace then re-enabling it? I know this sounds pretty basic but it might work.

    Thanks

  • April 11, 2018 at 7:17 am

    #1986343

    i did

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

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

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy