Replication: Change Distributor

Hello,
I need to change the distributor role from one production server to another
new server. I have 15 servers replicating (transactional) to one central
server, which is the distributor too. Of course, I want to change this role
to another new server.
I have been tested some processes in order to do that, many of them were
certains but I want to know the correct process which is supported by MS.
Thank you a lot.
Maria Pia Fernandez
Maria,
you can deduce the supported path from BOL - the section "Strategies for
Backing Up and Restoring Snapshot and Transactional Replication". The whole
process can be made simpler by preventing any access to the system, then
syncing all subscribers, then backing up the databases (master, msdb,
distribution) on the distributor. You can then restore the databases.
Remember that the server name must be identical for this to work.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
|||To change the distributor you must drop all subscriptions and publications
and then configure the new distributor and all publishers to use this
distributor. Then recreate you publications and subscriptions. Ensure that
the distributor is clustered.
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
"mpia" <repettos@.telviso.com.ar> wrote in message
news:O7ldpJjVHHA.1120@.TK2MSFTNGP02.phx.gbl...
> Hello,
> I need to change the distributor role from one production server to
> another new server. I have 15 servers replicating (transactional) to one
> central server, which is the distributor too. Of course, I want to change
> this role to another new server.
> I have been tested some processes in order to do that, many of them were
> certains but I want to know the correct process which is supported by MS.
> Thank you a lot.
> Maria Pia Fernandez
>
|||Hilary/Paul, thanks for your answers,
I need to maintain the old distributor!!!! I mean I need to change some
production publications in order to use another new distributor. So, this
new distributor will not have the same name.
Besides, I cant stop replicating, I can stop one of them and change its
distributor and so on.
Maria Pia Fernandez
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:u3GTp0mVHHA.2212@.TK2MSFTNGP02.phx.gbl...
> To change the distributor you must drop all subscriptions and publications
> and then configure the new distributor and all publishers to use this
> distributor. Then recreate you publications and subscriptions. Ensure that
> the distributor is clustered.
> --
> 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
>
> "mpia" <repettos@.telviso.com.ar> wrote in message
> news:O7ldpJjVHHA.1120@.TK2MSFTNGP02.phx.gbl...
>
|||A publisher can only use a single distributor. Multiple publishers can use
the same distributor on a remote distributor, or they can each have their
own distribution database on the same distributor.
But your configuration is not supported.
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
"mpia" <repettos@.telviso.com.ar> wrote in message
news:epy7SOpVHHA.1200@.TK2MSFTNGP04.phx.gbl...
> Hilary/Paul, thanks for your answers,
> I need to maintain the old distributor!!!! I mean I need to change some
> production publications in order to use another new distributor. So, this
> new distributor will not have the same name.
> Besides, I cant stop replicating, I can stop one of them and change its
> distributor and so on.
> Maria Pia Fernandez
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:u3GTp0mVHHA.2212@.TK2MSFTNGP02.phx.gbl...
>
|||I know that. I will try to explain better (sorry for my English!!)
I have 15 publishers using one distributor. I need to change the distributor
for some publications, so I will have two distributors.How can I change el
distributor for ONE publication?
Thanks.
Maria Pia Fernandez
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%237fq$upVHHA.4872@.TK2MSFTNGP03.phx.gbl...
>A publisher can only use a single distributor. Multiple publishers can use
>the same distributor on a remote distributor, or they can each have their
>own distribution database on the same distributor.
> But your configuration is not supported.
> --
> 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
>
> "mpia" <repettos@.telviso.com.ar> wrote in message
> news:epy7SOpVHHA.1200@.TK2MSFTNGP04.phx.gbl...
>
|||You will have to drop these publications and disable replication on those
machines whose distributor you wish to change. When recreate replication
configure them to use the different distributor/distributiondb.
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
"mpia" <repettos@.telviso.com.ar> wrote in message
news:OUx%23DFuVHHA.1432@.TK2MSFTNGP02.phx.gbl...
>I know that. I will try to explain better (sorry for my English!!)
> I have 15 publishers using one distributor. I need to change the
> distributor for some publications, so I will have two distributors.How can
> I change el distributor for ONE publication?
> Thanks.
> Maria Pia Fernandez
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:%237fq$upVHHA.4872@.TK2MSFTNGP03.phx.gbl...
>
|||Yes, I know that method but I want to do that no need to drop publications.
Is this possible? I think it is possible without using enterprise manager.
Thank for your time!!!!
Maria Pia Fernandez
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:eNT6lkuVHHA.4720@.TK2MSFTNGP04.phx.gbl...
> You will have to drop these publications and disable replication on those
> machines whose distributor you wish to change. When recreate replication
> configure them to use the different distributor/distributiondb.
> --
> 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
>
> "mpia" <repettos@.telviso.com.ar> wrote in message
> news:OUx%23DFuVHHA.1432@.TK2MSFTNGP02.phx.gbl...
>
|||There is no supported way to do this.
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
"mpia" <repettos@.telviso.com.ar> wrote in message
news:%23bwacHvVHHA.4028@.TK2MSFTNGP04.phx.gbl...
> Yes, I know that method but I want to do that no need to drop
> publications.
> Is this possible? I think it is possible without using enterprise manager.
> Thank for your time!!!!
> Maria Pia Fernandez
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:eNT6lkuVHHA.4720@.TK2MSFTNGP04.phx.gbl...
>