| Author |
Message |
Filipe Hammond
Guest
|
Posted:
Tue Oct 25, 2005 12:51 am Post subject:
OnePoint Database Availability Alerts |
|
|
Hi,
how does one set up an SMTP or pager notification for the MOM Onepoint
database being unavailable if the db is on a separate server? So far, I am
only able to get the notification if I bring the db back online, which is a
bit late.
thanks
Filipe |
|
| Back to top |
|
 |
Daniel Lai [MVP-Managemen
Guest
|
Posted:
Tue Oct 25, 2005 12:51 am Post subject:
Re: OnePoint Database Availability Alerts |
|
|
Hello,
Thank you for your posting!
Please try to use SQL Server Management Pack, and use the Event Rule to
generate the alerts
If you have any questions, please feel to let me know. I am glad to be of
assistance.
--
Daniel Lai
Microsoft MVP Program Top Contributor
Windows Server-Management Infrastructure
Microsoft Management Solution Consultant
http://msmvps.com/daniel
"Filipe Hammond" <filipeh@hottmail.com> wrote in message
news:u$o5G8N2FHA.1140@tk2msftngp13.phx.gbl...
| Quote: | Hi,
how does one set up an SMTP or pager notification for the MOM Onepoint
database being unavailable if the db is on a separate server? So far, I am
only able to get the notification if I bring the db back online, which is
a bit late.
thanks
Filipe
|
|
|
| Back to top |
|
 |
Filipe Hammond
Guest
|
Posted:
Tue Oct 25, 2005 6:54 am Post subject:
Re: OnePoint Database Availability Alerts |
|
|
Thanks for your reply. That will only work once the OnePoint db comes online
again. This does not appear to work, for example, if the OnePoint db server
crashes during the night leaving the management server unable to raise
alerts or send standard notifications using alert rules and such. In such an
event we would like to be paged that the MOM db is down.
Is there another way perhaps?
thanks
Filipe
"Daniel Lai [MVP-Management Infrastructure]" <laigarry@hotmail.com> wrote in
message news:%23d4ptDP2FHA.1980@TK2MSFTNGP15.phx.gbl...
| Quote: |
Hello,
Thank you for your posting!
Please try to use SQL Server Management Pack, and use the Event Rule to
generate the alerts
If you have any questions, please feel to let me know. I am glad to be of
assistance.
--
Daniel Lai
Microsoft MVP Program Top Contributor
Windows Server-Management Infrastructure
Microsoft Management Solution Consultant
http://msmvps.com/daniel
"Filipe Hammond" <filipeh@hottmail.com> wrote in message
news:u$o5G8N2FHA.1140@tk2msftngp13.phx.gbl...
Hi,
how does one set up an SMTP or pager notification for the MOM Onepoint
database being unavailable if the db is on a separate server? So far, I
am only able to get the notification if I bring the db back online, which
is a bit late.
thanks
Filipe
|
|
|
| Back to top |
|
 |
Daniel Lai [MVP-Managemen
Guest
|
Posted:
Tue Oct 25, 2005 7:13 am Post subject:
Re: OnePoint Database Availability Alerts |
|
|
Hello,
Thank you for your posting!
Then, I think you need to use third party software or other method to
monitor the Event Log of the MOM OnePoint Database offline and failure.
If you have any questions, please feel to let me know. I am glad to be of
assistance.
--
Daniel Lai
Microsoft MVP Program Top Contributor
Windows Server-Management Infrastructure
Microsoft Management Solution Consultant
http://msmvps.com/daniel
"Filipe Hammond" <filipeh@hottmail.com> wrote in message
news:OZDWHcQ2FHA.3216@TK2MSFTNGP09.phx.gbl...
| Quote: | Thanks for your reply. That will only work once the OnePoint db comes
online again. This does not appear to work, for example, if the OnePoint
db server crashes during the night leaving the management server unable to
raise alerts or send standard notifications using alert rules and such. In
such an event we would like to be paged that the MOM db is down.
Is there another way perhaps?
thanks
Filipe
"Daniel Lai [MVP-Management Infrastructure]" <laigarry@hotmail.com> wrote
in message news:%23d4ptDP2FHA.1980@TK2MSFTNGP15.phx.gbl...
Hello,
Thank you for your posting!
Please try to use SQL Server Management Pack, and use the Event Rule to
generate the alerts
If you have any questions, please feel to let me know. I am glad to be of
assistance.
--
Daniel Lai
Microsoft MVP Program Top Contributor
Windows Server-Management Infrastructure
Microsoft Management Solution Consultant
http://msmvps.com/daniel
"Filipe Hammond" <filipeh@hottmail.com> wrote in message
news:u$o5G8N2FHA.1140@tk2msftngp13.phx.gbl...
Hi,
how does one set up an SMTP or pager notification for the MOM Onepoint
database being unavailable if the db is on a separate server? So far, I
am only able to get the notification if I bring the db back online,
which is a bit late.
thanks
Filipe
|
|
|
| Back to top |
|
 |
Arie de Haan
Guest
|
Posted:
Tue Oct 25, 2005 8:51 am Post subject:
Re: OnePoint Database Availability Alerts |
|
|
In article <u$o5G8N2FHA.1140@tk2msftngp13.phx.gbl>, filipeh@hottmail.com
says...
| Quote: | Hi,
how does one set up an SMTP or pager notification for the MOM Onepoint
database being unavailable if the db is on a separate server? So far, I am
only able to get the notification if I bring the db back online, which is a
bit late.
thanks
Filipe
Hi Filipe, |
you should use the Remote Connectivity rules from the SQL Management
pack. Navigate to the MS SQL Server -> SQL Server 2000 -> Client Sode
Monitoring. Also read
http://www.microsoft.com/technet/prodtechnol/mom/mom2005/Library/bb5fbf4
c-fe54-4bdf-8e6e-0d0cff252bb8.mspx
because it will need some additional configuration
--
Greetz,
Arie
This posting is provide "AS IS" with no guarantees, warranties, rigths
etc. |
|
| Back to top |
|
 |
|
|
|
|