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 #DateLog File Size (Byte)

  001/11/2016 12:520

  101/11/2016 12:5085504

  201/10/2016 23:45448918

  301/07/2016 15:40441444

  401/03/2016 23:24377226

  512/31/2015 11:55111588

  612/29/2015 16:55206408

• alanspeckman

  Hall of Fame

  Points: 3344

  More actions

  January 13, 2016 at 10:29 am

  #1851662

  refer to this post as your answer