Friday, March 30, 2012

Replication to a specific IP

If we had two SQL 2000 servers each with 2 NIC's. For each server one network card was pointing to an internal network 172.16.x.xxx we use for production. The other NIC (say its 198.16.x.xxx) we wanted to use just for replication purposes between the two servers in an attempt to lighten the network traffic on the 172 network. My question is, can you set up 2 SQL servers to replicate between themselves on a specific IP or Named Pipe?If both server is in different geographical area or on a WAN, you will face a big threat from anyone in the world who wrote a simple program to guess your user "sa" password or any user account. To post that on a WAN, its preferable to go through a firewall.

There are 2 options:-
1) get a 1gigabit network adapter card and a switch that support 1GB.
2) make use of Client Utility Connection on both SQL server. Configured according to your Server Name with static IP address and specify the port that is use by both server. This will tell the replication agents to call the static ip.

Originally posted by sdonovan
If we had two SQL 2000 servers each with 2 NIC's. For each server one network card was pointing to an internal network 172.16.x.xxx we use for production. The other NIC (say its 198.16.x.xxx) we wanted to use just for replication purposes between the two servers in an attempt to lighten the network traffic on the 172 network. My question is, can you set up 2 SQL servers to replicate between themselves on a specific IP or Named Pipe?

No comments:

Post a Comment