Post reply

Constant Recycling of Main SQL Error Logs

  • January 17, 2016 at 11:59 am

    #303769

    I have a really strange thing occurring with my most of SQL servers, but not all. My main SQL server logs are re-initializing every few seconds. To the point at which I have maxed out at Archive #99 in error logs and cannot see any real error log content as a result.

    You can see the start of the list below this goes down to #99 and each log just says re-initializing log. I checked my agent jobs and they are all idle, so I don’t know what could be causing this. Any ideas how to narrow it down?

  • January 17, 2016 at 12:40 pm

    #1852425

    It sounds to me like someone is trying to cover their tracks or is playing around with some method to keep the logs "manageable".

    I don't know if log recycling is captured by the Default Trace but that's the first place I'd check. If someone's login shows up there, I'd disable their AD and SQL Server account immediately and then start asking questions. If you have an "IT Security" group, I'd also report it to them right now. At least make the CIO aware of what occurred because, either internally or externally, you may be under attack or in the presence of someone incredibly stupid/arrogant. Needs to be dealt with in any case. Just make sure it's not something that you've done somewhere before you do that. 😛

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

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

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