Thursday, March 22, 2012

Alert When SQL Server shuts down

Hello All
Does anybody know of a way to send a mail, when the SQL Server shuts down. I
am not able to find any help with regard to that.
Advanced thanks for any body who could provide me information
--
SaravananSorry forgot about other stuff.
OS: Windows 2000 Server
SQL Server 2000
--
Saravanan
"Saravanan" wrote:

> Hello All
> Does anybody know of a way to send a mail, when the SQL Server shuts down.
I
> am not able to find any help with regard to that.
> Advanced thanks for any body who could provide me information
> --
> Saravanan|||last time I had to do this, I used a different sql server to attempt a
connection and alert if it failed.
Barring that, you'll need to be looking at it from the perspective of the
SQL Server service
Kevin3NF
"Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
news:01643CF2-633F-45C4-B190-3A9F15705DC0@.microsoft.com...[vbcol=seagreen]
> Sorry forgot about other stuff.
> OS: Windows 2000 Server
> SQL Server 2000
> --
> Saravanan
>
> "Saravanan" wrote:
>|||If you want to set something up yourself, you need to proble the SQL instanc
e
at a regular interval from a different machine, and if the proble can't
connect to the instance, it fires off an email. This is a standard approach
in any monitoring tool. But for this kind of stuff, you may be better off to
get a monitoring package since this will not be the only thing you want to
monitor.
Linchi
"Saravanan" wrote:

> Hello All
> Does anybody know of a way to send a mail, when the SQL Server shuts down.
I
> am not able to find any help with regard to that.
> Advanced thanks for any body who could provide me information
> --
> Saravanan|||Could you please point me to any links on how to do this?
--
Saravanan
"Kevin3NF" wrote:

> last time I had to do this, I used a different sql server to attempt a
> connection and alert if it failed.
> Barring that, you'll need to be looking at it from the perspective of the
> SQL Server service
> Kevin3NF
>
> "Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
> news:01643CF2-633F-45C4-B190-3A9F15705DC0@.microsoft.com...
>
>|||Could you please point me to any links please on how to do this?
--
Saravanan
"Linchi Shea" wrote:
[vbcol=seagreen]
> If you want to set something up yourself, you need to proble the SQL insta
nce
> at a regular interval from a different machine, and if the proble can't
> connect to the instance, it fires off an email. This is a standard approac
h
> in any monitoring tool. But for this kind of stuff, you may be better off
to
> get a monitoring package since this will not be the only thing you want to
> monitor.
> Linchi
> "Saravanan" wrote:
>

No comments:

Post a Comment