How to Get Alert Email on Failover in Your Always On Availability Group in SQL Server
Follow these simple steps along with the script to set up and receive a simple and single email whenever a failover happens in your AlwaysOn Availability Group. AlwaysOn Availability Group in SQL Server AlwaysOn Availability Group was released with SQL Server 2012 and is the successor of database mirroring. You can set it up in your SQL Server environment for high availability or disaster recovery. For High Availability the group has to be set in synchronous mode and for disaster recovery the...
Read more ยป