May 11, 2005 at 6:21 pm
Hi all, heres my scenario
I have two servers A and B in different locations - LocA and LocB respectively. Both servers synchronizes their SQL databases continuously.
We have a survey team that uses laptops(also setup as subscribers) in remote sites and synchronises with server A at the end of the day when they connect back to the server. We want to be able to synchronise these laptops with server B incase server A crashes.
What will be the best configuration to achieve this and what are any foreseen problems? Anybody tried alternate publishers before?
May 18, 2005 at 3:16 am
Alternative synchronization partners can be used in merge replication. Caveates: all computers must be using SQL 2000 and the subscriptions must be global (AFAIR). If you are using named Subscriptions, you must enable the Subscriber at the alternate synchronization partner and create a subscription identical to the original subscription at the alternate synchronization partner - do a search in BOL for 'alternative synchronization partners'.
HTH,
Paul Ibison, SQL MVP
Paul Ibison
Paul.Ibison@replicationanswers.com
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply