Automatic failover of Subscriber (Transactional Replication) - by SQLDBAs

Status : 

 


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

Description

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 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 http://technet.microsoft.com/en-us/library/hh882436.aspx

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