September 30, 2008 at 6:08 am
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
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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply