asked
Always ON: databases not connected if secondary server down?
Always on configured for SQL Server2012 (RTM version) on Windwos 2008 Node1: Primary server (DB name: TestDB1) Node2: Secondary server(configured always on for DB name TestDB1) Node3: Fileshare server(for automatic failover) Always on: Always on configured with automatic failover(move immediately if any failover scenario) Testing Scenario: Node1 shutdown(primary shutdown) We did Node1 shutdown and node2 became primary. But TestDB1 database not able to access on NOde2(whichis beacme Primary after shut Node1 shut down). we did below command as well net start clussvc /fq --on NOde2 (it showing that "requested service already started). in command line if we typ--> Cluster node ( status showing ---->Node1 down,Node2 UP) Question: In order to access the TestDB1 database on Node2, what should we do? Is there any configuration change? Note: After Node1 shutdown, Node2 instance is up and running, but not able to access the TestDB1 database.(TestDB1 database showin not synchronized) thanks
**Solution:** Just found, modified following as per the below link and its working now fine. No issues with database conenction to NOde2 after NODE1 shutdown
http://blogs.msdn.com/b/sql_pfe_blog/archive/2013/04/08/sql-2012-alwayson-availability-groups-automatic-failover-doesn-t-occur-or-does-it-a-look-at-the-logs.aspx 1. alter availability group [Test001AAG] set (failure_condition_level=5) (--previously it was 3) --select * from sys.availability_groups 2.Modified Availibility session timeout to 120(previously it was 10). 3.Cluster group properties max failover in specified period: 3 Hours: 6 Thanks
14 People are following this question.
