Relicated Master Query

[Andy B]

I have created a master & replicas and sorted out synchronisation across a VPN and overall l am very happy with what l have achieved (lots of thanks to to help l have received todate from this forum that has made that posssible).

I now have a couple of questions which are niggles rather than full blown problems.

THe first is my master keeps reverting to a replica version of itself, l press the reinstate master and it keeps it as the master for a period but it keeps dropping the master status. Firstly any ideas why ? and secondly how do l stop it keep changing?

Next every now and again synchronisation slows a relicants version down to the point that it VERY slow to open (almost like it is on a VPN itself not a local copy) No amount of synchronation from their end fixes it, however it would appear that a synchronisation from my end solves the problem.

Agani the two questions - any idea why ?

and how do l fix it ?

Hope someone can help me

AndyB

 

[TryingMyBest]

Indirect Synchronisation?

Check out Indirect Synchronisation as detailed on Microsoft's White Paper "Database Replication in Microsoft Jet" This doesn't open each database directly, rather the synchornisers talk to each other and the synchronisation is then performed locally instead of over the WAN.

Sorry I don't have the online link as it's a printed version I am looking at. I imagine a search of MS website will locate it though.

You'll need Replication Manager to use indirect synchronisation.

Sorry I can't help with your other problem....no ideas

Hope this helps
Jo