SQL Server 2012 AlwaysOn Testing Tip

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:  http://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)

Skip to main content