I am investigating replication with the idea that eventualy we might have multiple servers all over country holding the same data so that we have an off site copy of the data and so different sites can have there own copy of the data for quick local access.
I have set up a basic transaction replication between two servers, DB A is set up as a publisher and i setup the Subscription from there to Database B,as this is only a test a selected 4 tables from the Main Database to replicate and they appeared in DB
B, i made some changes to the data in DB A and they replicated fine.
so far so good.
but if i update DB B it is not replicated in DB A, have i missed some thing or do i have to set Database B up as a publisher as well as Database A?
View Complete Post