I am running a multiple instance cluster. Each server has
8 CPUs with 16GB ram. I have a database on each server
active where if one node fails, they failover to each
other.

Any documentation or information for instant notification
when there is a failover? Notification by email etc.

Thanks

You can create a startup stored procedure that sends an email whenever an
instance starts up. That is probably as close as you can come without an
external monitoring system.

--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com

I support the Professional Association for SQL Server
www.sqlpass.org

"marine" <anonymous (AT) discussions (DOT) microsoft.com> wrote

"Geoff N. Hiten" <SRDBA (AT) Careerbuilder (DOT) com> wrote


My other suggestion is to put a task as part of the resource group and use
something like blat.

(this avoids reliance on SQL Mail.)