Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Notification for Availabilty Group Failover Expand / Collapse
Author
Message
Posted Friday, July 19, 2013 8:20 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, April 18, 2014 2:10 AM
Points: 117, Visits: 275
How can we setup auto notification for Availabilty Group Failover in SQL 2012? Please suggest.

Regards
sqldba4u
Post #1475508
Posted Tuesday, July 23, 2013 2:58 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, April 18, 2014 2:10 AM
Points: 117, Visits: 275
Any workaround on this?
Post #1476421
Posted Tuesday, July 23, 2013 5:34 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Yesterday @ 11:07 PM
Points: 59, Visits: 419
Haven't come across auto notification
Can make use of this DMV to sys.dm_hadr_availability_group_states , we can look at values for primary_recovery_health and primary_recovery_health_desc which will have the node name.

Please refer http://msdn.microsoft.com/en-us/library/ff878491.aspx
Post #1476507
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse