Replication Qn

[Tomi]

May be this is a stupid question :

Is it possible to set up transactional/snapshot replication bidirectional ?ie one pushing the changes to the other and the other pushing changes to the first ?
This is an idea for redundancy - not considering log shipping or clusters

thanks
Tom

 

[cyno]

Yes. You can implement bidirectional transactional replication. There should not be conflicts(updates more often). If you have updates(conflicts) more often then merge replication is best solution

http://support.microsoft.com/default.aspx?scid=820675

cyno

 

[Tomi]

Thanks . This is what I have been looking for

Tomi