Mirroring

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Per Schjetne - 27 Apr 2006 08:45 GMT

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

Reply to this Message

Russ Kaufmann [MVP] - 27 Apr 2006 16:27 GMT

> 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.

Signature

Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp

Reply to this Message

Remus Rusanu [MSFT] - 27 Apr 2006 19:43 GMT

select * from sys.database_mirroring

Signature

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

> 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

Reply to this Message

Michael Hotek - 28 Apr 2006 04:17 GMT

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.

Signature

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.

> 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

Reply to this Message