Alert!!!!

  • savenbuan

    SSC Veteran

    Points: 213

    Something that look simple enough not to cause any nightmare is drawing me through hell.

    I have a third party monitoring utilities that goes through my errorlog and NT eventlog for any error and generate a ticket when any error that has severity 19 and above.

    I created a user error message 5001 and 5002 with severity 22 to occur when ever my backup and transaction log failed.( Note: I know I can use sql mail but no mail in my environment). So the story:

    Nothing is reported and no ticket is generated each time my backup fails. Does anyone know what to do next? I have done everything thing plus using raiseerror stored procedure to make it log but all to no avail. Is this a problem with sql7 and/or 2000? Your two cent contribution welcomed.

  • Wesley Brown

    SSChampion

    Points: 12035

    are you using log encapsulation and openview?

    http://www.sqlserverio.com
    http://www.cactuss.org
    http://www.salssa.org

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply