다음을 통해 공유

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