Mirroring

Is there a way to detect if the principal or mirror is running the database?
I want build my own altert system, sending an SMS whenever a automatic
failover/failback happens.
Per Schjetne"Per Schjetne" <newsuser1@.gdconsult.no> wrote in message
news:%23V%23sM6caGHA.1196@.TK2MSFTNGP03.phx.gbl...
> Is there a way to detect if the principal or mirror is running the
> database? I want build my own altert system, sending an SMS whenever a
> automatic failover/failback happens.
You can set alerts on the messages in the event log. Talk to your monitoring
application vendor for more info.
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp|||select * from sys.database_mirroring
This posting is provided "AS IS" with no warranties, and confers no rights.
HTH,
~ Remus Rusanu
SQL Service Broker
http://msdn2.microsoft.com/en-us/library/ms166043(en-US,SQL.90).aspx
"Per Schjetne" <newsuser1@.gdconsult.no> wrote in message
news:%23V%23sM6caGHA.1196@.TK2MSFTNGP03.phx.gbl...
> Is there a way to detect if the principal or mirror is running the
> database? I want build my own altert system, sending an SMS whenever a
> automatic failover/failback happens.
> Per Schjetne
>|||The sys.dm_database_mirroring view will give you the state information that
you
need to monitor. You will need to access this on both partners.
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Per Schjetne" <newsuser1@.gdconsult.no> wrote in message
news:%23V%23sM6caGHA.1196@.TK2MSFTNGP03.phx.gbl...
> Is there a way to detect if the principal or mirror is running the
> database? I want build my own altert system, sending an SMS whenever a
> automatic failover/failback happens.
> Per Schjetne
>