Alert of size log

• Lisset

  SSCommitted

  Points: 1858

  More actions

  May 15, 2009 at 4:42 pm

  #100632

  Hi everybody, I have a database and I want create a alert in SQL Server for when the log have the determinated size. Someone know How I can do it?

  Thanks for your help

• Florian Reischl

  SSC-Dedicated

  Points: 37301

  More actions

  May 15, 2009 at 4:52 pm

  #995756

  SSE2k is some month away but I think you can use a T-SQL job which checks the sysfiles and raises an error when your determined size was reached.