Post reply

SQL Server Agent Error log

  • April 16, 2017 at 9:57 pm

    #337308

    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.

  • April 17, 2017 at 6:14 am

    #1938287

  • April 17, 2017 at 6:31 am

    #1938290

    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.

  • April 17, 2017 at 9:24 am

    #1938318

    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

  • April 17, 2017 at 10:47 am

    #1938337

    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

  • April 17, 2017 at 3:03 pm

    #1938389

    Thanks, Aditya!

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

  • April 17, 2017 at 3:41 pm

    #1938399

    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

  • April 17, 2017 at 4:12 pm

    #1938407

    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.

  • April 18, 2017 at 3:02 am

    #1938460

    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

  • April 19, 2017 at 6:18 am

    #1938770

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

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