Sunday, February 19, 2012

Changing IP addresses

We are planning on changing IP addresses on two database
servers that have SQL transactional replication between
them. Before I get into any trouble, do you see any
problem that could occur regarding the replication
communication between the servers. My plan is to change
the IP addresses and reboot the servers. I won't know
until I do this if the replication will start back up
successfully.
replication is insensitive to IP address changes.
there are some caveats
1) if you are using the client network utility to associate the IP address with the machine name you will have to update the ip addresses
2) if you are using a hosts file for name lookup s to associate the IP address with the machine name you will have to update the ip addresses in this file
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Jeff Steinweber" wrote:

> We are planning on changing IP addresses on two database
> servers that have SQL transactional replication between
> them. Before I get into any trouble, do you see any
> problem that could occur regarding the replication
> communication between the servers. My plan is to change
> the IP addresses and reboot the servers. I won't know
> until I do this if the replication will start back up
> successfully.
>

No comments:

Post a Comment