Home Forums SQL Server 2008 T-SQL (SS2K8) Send Alert when no log backup completed in 24 hours RE: Send Alert when no log backup completed in 24 hours

  • Sorry for the late response to your request to know which code set I used. The answer is sorry none, part of process are in ultra secure enviroments and server level email would be a strict no-no, and would case what is known as a Resume generating event(RGE).

    and are instances have grown to 1300 since this posting.

    the final process was a set of SSIS packages that collected requested information, and then we are using SSRS to allow management and application owners to see what is happening. it is crude but meets the need.

    Thank you for the information.