Friday, February 24, 2012

AGAIN Merge Replication with alternate synchronization partner

Hello I'm asking this without having answer:
I followed these instructions to set up replication:
http://support.microsoft.com/default...roduct=sql2k#3
From what I read in the help and everywhere this is soppoused to set the
PublisherB as the alternate synch parter. If I turn off the server
PublisherA and I need Publisher B and Subcriber A to replicate between
themselves while the Publisher A if off, what do I need to set up? What else
do I need to do? Because I turn off the server Publisher A and the
information is not being replicated between the other two servers. Again
we're having a huricane and we need to turn off the server and the other two
sites need to work normally as nothing happens.
Thanks and please help
Jennyfer
you need to set up server b with a copy of the database on server a. Then
you need to create the identical merge publication there as well.
Then you need to configure server b as an alternate publisher of server a.
You do this on server a using the sp_addmergealternatepublisher proc.
Then push your subscription to server c as a pull subscription.
When server a goes offline, you need to point server c to pull from server
b. You do this by right clicking on the merge pull agent, and change the
merge agent parameters to -Publisher ServerB -PublisherDB
PublisherDatabase -Distributor ServerB -SyncToAlternate 1
then restart your merge agent.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Jennyfer J Barco" <pdwhitt@.nospam.wdsinc.com> wrote in message
news:OQjj0OrlEHA.3520@.tk2msftngp13.phx.gbl...
> Hello I'm asking this without having answer:
> I followed these instructions to set up replication:
>
http://support.microsoft.com/default...roduct=sql2k#3
> From what I read in the help and everywhere this is soppoused to set the
> PublisherB as the alternate synch parter. If I turn off the server
> PublisherA and I need Publisher B and Subcriber A to replicate between
> themselves while the Publisher A if off, what do I need to set up? What
else
> do I need to do? Because I turn off the server Publisher A and the
> information is not being replicated between the other two servers. Again
> we're having a huricane and we need to turn off the server and the other
two
> sites need to work normally as nothing happens.
> Thanks and please help
> Jennyfer
>

No comments:

Post a Comment