Post reply

Need alert on server

  • September 30, 2008 at 6:08 am

    #125913

    hi

    actually . last month i built a sql server 2005 in a local desktop machine ...from database point of view its working well

    but in last 30 days .the server got shut down once. once,connection got broken

    in both the cases i checked the error log but nothing much i came to know

    so is it possible that whenever something abnormal happen to it i got mail

    but i dont to want to use thir party software

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • September 30, 2008 at 6:54 am

    #878817

    The SQL Server got shutdown - Check the logs in windows to see what time it got shutdown and by whom.

    Servers don't usually shutdown on their own but hey i known it them to.

    The only thing is the alert will not fire if it is shutdown because it can't send the email.

    So you could set up a vbs script to ping it each minute and if it cannot ping then something wrong with the server. This has to be outside of the SQL.

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

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