Moving Replication Distributor to new cluster

Hi
What are the gotchas on moving a Replication Distributor to new hardware/a
new cluster?
Kind Regards,
T. Hagen
You have to drop the publications and disable replication on the publisher
before the move. You have to make sure your remote distributor is
clustered - which it appears to be
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"thagen" <thagen@.discussions.microsoft.com> wrote in message
news:23A725E7-ED77-4BD6-A8A6-AF3D91C96D2D@.microsoft.com...
> Hi
> What are the gotchas on moving a Replication Distributor to new hardware/a
> new cluster?
> Kind Regards,
> T. Hagen
|||As well as Hilary's response, and it's a long time since I worked on
clustering a distributor, I recall that the distribution working folder
should be set up as a shared resource on the cluster.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
|||Thanks Hilary.
There is nothing to be done on the Subscriber side?
And as for the actual steps in moving the Distributor, you have any how-to
on that?
Kind Regards,
Torkild
"Hilary Cotter" wrote:

> You have to drop the publications and disable replication on the publisher
> before the move. You have to make sure your remote distributor is
> clustered - which it appears to be
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "thagen" <thagen@.discussions.microsoft.com> wrote in message
> news:23A725E7-ED77-4BD6-A8A6-AF3D91C96D2D@.microsoft.com...
>
>
|||Perhaps you mean the snapshot share While you can park this anywhere, it
is best on the publisher.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:uRXwYO8ZHHA.2316@.TK2MSFTNGP04.phx.gbl...
> As well as Hilary's response, and it's a long time since I worked on
> clustering a distributor, I recall that the distribution working folder
> should be set up as a shared resource on the cluster.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
>
|||You can't move the distributor. You have to disable publishing on the
publisher. Pre-create the distributor on the remote distributor and then
configure your publishers to use this distributor. Then connect to your
publishers and enable replication, and enable it to use the remote
distributor. You will need to configure an administrative link password.
There is a guide in the sample chapter of my book.
http://www.nwsu.com/lowres_replication_ch02.pdf
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"thagen" <thagen@.discussions.microsoft.com> wrote in message
news:3B9C0EF4-E09C-455B-8F5B-9AC1B80BE7D9@.microsoft.com...[vbcol=seagreen]
> Thanks Hilary.
> There is nothing to be done on the Subscriber side?
> And as for the actual steps in moving the Distributor, you have any how-to
> on that?
> Kind Regards,
> Torkild
> "Hilary Cotter" wrote:
|||Yes -thanks for the correction Hilary (snapshot share).
It still makes sense to me though that this should be a shared resource on
the central (shared) array rather than a local node so it can fail over.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com