Errorlog Size Alert

  • Filippo-391925

    Mr or Mrs. 500

    Points: 587

    Hi all!

    i'd like to know if it is possible to set an alert (sending an email) on errorlog size growth. I need to receive a notify when errorlog size reach certain MB and then execute sp_cycle_errorlog.

    Thanks!

     

  • alanspeckman

    Hall of Fame

    Points: 3344

    bumping up this post.

    I am wanting to know the current errorlog file size.

    EXEC XP_enumerrorlogs

    That only gives you the old cycled errorlog sizes.

    Archive # Date Log File Size (Byte)

    0 01/11/2016 12:52 0

    1 01/11/2016 12:50 85504

    2 01/10/2016 23:45 448918

    3 01/07/2016 15:40 441444

    4 01/03/2016 23:24 377226

    5 12/31/2015 11:55 111588

    6 12/29/2015 16:55 206408

  • alanspeckman

    Hall of Fame

    Points: 3344

    refer to this post as your answer

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

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