Automatic failover of Subscriber (Transactional Replication) - by SQLDBAs

Status : 


Sign in
to vote
ID 794388 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 7/18/2013 6:36:36 AM
Access Restriction Public


Automatic failover of Subscriber (Transactional Replication)
if a database(publishing/subscriber) particiapte in AG  Automatic failover is not happening.  
Sign in to post a comment.
Posted by Microsoft on 8/20/2016 at 5:33 PM
Susbcribers for transactional replication are supported with Always On without any requirement for manual steps. Please refer
Posted by Rei on 10/11/2013 at 12:21 PM
What we are looking is to have the 3 manual steps needed to failover a subscriber that participates on a AlwaysOn to be automated.

as described on article

WHY? because if a person has to manually run scripts to do a failover, then HA feature is non existant.