Post reply

Improve sql server logs

  • December 2, 2015 at 3:48 am

    #305721

    I want to improve logs which stores in default trace by putting more efficient data according to security aspect for example now it logs unsuccessful logins, I want to log more critical data. Let me know if you have suggestion about this issue.

    Tnx 🙂

  • December 2, 2015 at 3:50 am

    #1843447

    You can't change the default trace.

    What you can do is turn the default trace off and create your own trace which logs what you want. I recommend using Extended Events rather than trace if you want to do that. It's easier to get Extended Events to start a session on restart than for Trace.

    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

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

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