Changing IP

I am using merge replication with SQL ver 7, on a NT4 box. I need to
move one of seven subscribing servers to a new location which means
changing the IP address. I want to do the move without taking down
replication if possible. My plan is to move the box and change to new
IP address. Then update the WINS entry for the new address, and have
replication resume.
Should this work? Let me know if anyone can think of potential
problems.
thanks in advance, Jim
It should work. Replication is sensitive to subscriber name changes, not ip
address changes. Just make sure that you did not hard code an ip address in
the alias you may have created for this server in client network utility.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Jim" <ndpace@.att.net> wrote in message
news:c834d859.0409291039.4499a3df@.posting.google.c om...
> I am using merge replication with SQL ver 7, on a NT4 box. I need to
> move one of seven subscribing servers to a new location which means
> changing the IP address. I want to do the move without taking down
> replication if possible. My plan is to move the box and change to new
> IP address. Then update the WINS entry for the new address, and have
> replication resume.
> Should this work? Let me know if anyone can think of potential
> problems.
> thanks in advance, Jim
|||Guys!
I have the similar problem, but the server name will be changed also.
I believe it should be enough to call a kind of system SP, which will
replace old box names to the new ones. Could you point me to the right
direction?
Best regards,
Serge.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:uEUCatlpEHA.1816@.TK2MSFTNGP09.phx.gbl...
> It should work. Replication is sensitive to subscriber name changes, not
ip
> address changes. Just make sure that you did not hard code an ip address
in
> the alias you may have created for this server in client network utility.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> "Jim" <ndpace@.att.net> wrote in message
> news:c834d859.0409291039.4499a3df@.posting.google.c om...
>
|||Serge,
Use Master
go
Sp_DropServer 'OldName'
GO
Use Master
go
Sp_Addserver 'NewName', 'local'
GO
Stop and Start SQL Services
This will rename your server, but you'll need to set up
the publications from fresh afterwards.
HTH,
Paul Ibison
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)