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 6 (of 6 total)

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