Errorlog Size Alert

• Filippo-391925

  Mr or Mrs. 500

  Points: 587

  More actions

  April 6, 2007 at 10:54 am

  #370128

  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

  More actions

  January 12, 2016 at 10:50 am

  #1851359

  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

  More actions

  January 13, 2016 at 10:29 am

  #1851662

  refer to this post as your answer