Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Interesting nuance in SQL Server 2012 AlwaysOn testing – if you stop SQL Service manually on primary replica, it fails over to second node
only once. Any further attempts of stopping SQL Service (to test auto failover) would not cause failover – read more: https://blogs.msdn.com/b/sqlserverfaq/archive/2012/03/15/inf-alwayson-the-secondary-database-doesn-t-come-automatically-when-the-primary-instance-of-sql-server-goes-down.aspx?+Tricks)