Home Forums Article Discussions Article Discussions by Author Discuss content posted by Yogeshwar Phull Automatic Alert Generation in the event of SQL Server Cluster Failover RE: Automatic Alert Generation in the event of SQL Server Cluster Failover

  • October 5, 2011 at 10:31 pm

    #1391062

    What if a failover occurs but the other node fails to come online and it fails back to the original server? No alert will be raised.

    What if the cluster shuts down and can't start on either node? No alert will be raised.

    You need to monitor externally.

    My blog: SQL Soldier[/url]
    SQL Server Best Practices:     SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]