Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
malathic
Starting Member
6 Posts |
 Posted - 2006-05-25 : 06:02:21
|
| Hi, I want to know how to notify, by an alert or an email to some one, when the principal failovers automatically to the mirror server.Please guide me through step by step for this requirement.Thanks in Advance,Radhika |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-05-25 : 06:23:47
|
Cross post to each other thread ? 
KH |
 |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2006-05-25 : 06:39:06
|
| You could use the notification services thingy I guess.Or you could have a stored procedure set to run on startup that runs if the (physical) host name of the computer is different to the last one (you could store the last one in a table).-------Moo. :) |
|
|
|
|
|
|
How to notify in case of Automatic Failover