how can I configure what will be registered nside the log file?

  • Dear Friends

                Inside the sql server how can I configure what will be registered inside the log file?

    Thanks
    Almir

  • Are you asking about the transaction logs or the server logs?

  • ZZartin - Monday, February 26, 2018 2:33 PM

    Are you asking about the transaction logs or the server logs?

    about sql server logs

  • Transaction logs or error logs?

    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
  • GilaMonster - Tuesday, February 27, 2018 9:47 AM

    Transaction logs or error logs?

    Transaction logs

  • The only thing you can configure there is the DB's recovery model, which affects how long log records are retained, and whether some operations will be minimally or fully logged.

    What are you trying to do?

    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 6 posts - 1 through 5 (of 5 total)

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