Replication Question

[Bell1991]

I have a question about replication.

Currently we have two servers, serverA and serverB.

ServerA is the primary server and serverB is somewhat of a backup. Everything on serverA gets replicated to ServerB. So, if serverA goes down - serverB takes over.

My question is if serverA goes down and serverB is the primary - once we get serverA back up - how do we get the new information back to serverA?

I was originally thinking having replication set up in both directions - that way when serverA is back up - just re-initialize the databases - but if serverA is down and serverB is trying to replicate to it - I will get errors.

Thanks,
-Bell

 

[JayKusch]

I believe your two-way replication is the way to go. Do not worry about the errors in replication, too much , that is what will happen when connectivity between the servers is down. It will que up these changes, via the log reader, and will apply all the non-marked items in the translog back to server A when it comes back online.

Thanks

J. Kusch