July 23, 2011 at 8:47 am
Hi
we configured trans replication. two servers ( one pub , other sub )
How to configure reverse replication
How to do Manuel fail over
Please any help for me ..
Thanks
Jerry
July 23, 2011 at 4:52 pm
Your questions are very general. Have a look at Books Online. It has all the information you need.
Bidirectional Transactional Replication
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 24, 2011 at 9:43 am
Replication isn't designed for high availability. To reverse it, you need to stop replicating data from the old publisher, and re-set up replication in the other direction.
As mentioned above, you might read more about it in BOL or post more information on what you are trying to accomplish.
July 24, 2011 at 7:22 pm
You have a few options
You can use transactional replication with updateable subscriptions.
You can use peer to peer replication
You can setup bi directional transactional replication , however you will need to code the logic in order to prevent circular references.
Alternatively you can checkout mirroring the publisher in which failover is automatic and completely transparent from replication asides from the additional switch in the log reader.
Cheers
Jannie
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply