How to get detail information about switch Always on Between Primary And Secondary

• MotivateMan1394

  Hall of Fame

  Points: 3876

  More actions

  September 11, 2015 at 10:49 pm

  #304496

  Hi

  We have High Availability Based on Alaways on - Sql server 2014

  But this morning I saw that , It switched and mainserver was the second.

  First : It was good, because we have all services.

  second : It was bad, I dont know when and why it was switched.

  Please say me to get information about history Of switch between p and s.

  thank you .

• arr.nagaraj

  SSCertifiable

  Points: 6528

  More actions

  September 14, 2015 at 1:30 am

  #1826291

  2 options.

  1) SQL Server errorlog - Gives detailed info on the failover from primary to secondary

  2) On Always dashboard look for "View Always on Health Events" at the right hand corner.

  Regards,
  Raj

  http://Strictlysql.blogspot.com