Home Dashboard Directory Help
Search

Automatic failover of Subscriber (Transactional Replication) by SQLDBAs


Status: 

Active


2
0
Sign in
to vote
Type: Suggestion
ID: 794388
Opened: 7/18/2013 6:36:36 AM
Access Restriction: Public
0
Workaround(s)
view

Description

Automatic failover of Subscriber (Transactional Replication)
if a database(publishing/subscriber) particiapte in AG Automatic failover is not happening.
Details
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.
Sign in to post a workaround.