try; DBCC SQLPERF (LOGSPACE) You could schedule a recurring SQL agent job to evaluate the result and mail an alert to you using a stored procedure. Database Mail : http://technet.microsoft.com/en-us/library/ms177580.aspx