What is bidirectional replication and who should consider that approach for disaster recovery?
Bidirectional transactional replication lets two or more Windows servers serve as both "publishers" and "subscribers" (recipients) of data. The characteristics of this arrangement involve two servers, e.g., Server A and Server B. In a bidirectional replication scheme, changes to data on Server A are replicated to Server B and changes to data on Server B are replicated on Server A. When a change occurs on Server A, the change is replicated to Server B, but Server B does not replicate the same change back to Server A.
From a disaster recovery perspective, bidirectional replication ensures that data on the primary server and backup server remain synchronized. Organizations with critical databases, applications and customer data will want to ensure that these resources are truly replicated and available in case of a disaster.
This was first published in February 2013