SQL Server Agent Error log

  • aprathour.89

    Default port

    Points: 1495

    Comments posted to this topic are about the item SQL Server Agent Error log

    -----------------
    Aditya Rathour
    SQL DBA

    Not Everything that is faced can be changed,
    but nothing can be changed until it is faced.

  • Lee Nadelman

    SSCertifiable

    Points: 5320

  • George Vobr

    SSCrazy Eights

    Points: 9223

    Inattention got me. It wanted more coffee. I was blind and missed the word Agent... :crying:
    Still, thanks Aditya for this practical question. A good explanation is on MSSQLTips in the article Best Practice Recycling SQL Server Agent Error Logs.

  • webrunner

    SSC-Dedicated

    Points: 30311

    Thanks, I got it wrong  but great question - I learned something.

    - webrunner

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

  • SQLRNNR

    SSC Guru

    Points: 281243

    Sunnuva. Slow the click.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Revenant

    SSC-Forever

    Points: 42467

    Thanks, Aditya!

    I am surprised that less than 30 percent got this one right.

  • SQLRNNR

    SSC Guru

    Points: 281243

    Revenant - Monday, April 17, 2017 3:03 PM

    Thanks, Aditya!

    I am surprised that less than 30 percent got this one right.

    I am not surprised by it. I do believe most ignore the agent log.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Revenant

    SSC-Forever

    Points: 42467

    SQLRNNR - Monday, April 17, 2017 3:41 PM

    Revenant - Monday, April 17, 2017 3:03 PM

    Thanks, Aditya!

    I am surprised that less than 30 percent got this one right.

    I am not surprised by it. I do believe most ignore the agent log.

    I did not know the answer but it took me literally two minutes to BoL the answer.

  • P. K. Jat

    SSC Veteran

    Points: 236

    SQL Server maintains up to nine SQL Server Agent error logs. Each archived log has an extension that indicates the relative age of the log. For example, an extension of .1 indicates the newest archived error log and an extension of .9 indicates the oldest archived error log.
    so total archive is 10

  • Stewart "Arturius" Campbell

    SSC Guru

    Points: 71864

    Now that is interesting.
    Never really thought about this before...

    ____________________________________________
    Space, the final frontier? not any more...
    All limits henceforth are self-imposed.
    “libera tute vulgaris ex”

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

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