Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Replicating over dedicated link

Author  Topic 

bjkhan
Starting Member

1 Post

Posted - 2003-11-18 : 19:40:21
Hi,

Currently I have two SQL servers located in two geographically separated sites. I replicate the data from one site to another using the SQL Transactional Replication. I have two network configured in the SQL servers. One network is where the users interface with the servers and another network dedicated for backup and replication. How I do force the replication to only use a particular network?

Thanks

Ajmal

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-11-18 : 19:46:53
Do you mean how to force it to use a particular IP address? I don't think that replication can be configured in this way. Maybe you could put the IP address where you would put the server name when configuring replication, but it'll be up to you to test out.

Why would you want to do this?

Tara
Go to Top of Page
   

- Advertisement -