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.
| Author |
Topic |
|
xgirl
Starting Member
6 Posts |
 Posted - 2008-03-07 : 15:28:00
|
| We currently have merge publications that replicate to client computers using a pull subscription with the agent running on the distributor. We use a remote distributor. Clients run on Windows 2000. We are upgrading to Windows XP and the subscriptions fail when attempting to run the agent on the distributor. The pull subscriptions work if we run the run the agent on the subscriber. What are the pros and cons of running the agent on the subscriber vs running the agent on the distributor? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-07 : 22:53:33
|
| Will add some loads on subscriber. |
 |
|
|
xgirl
Starting Member
6 Posts |
Posted - 2008-03-10 : 14:18:42
|
| That's what I come up with. What about network traffic payloads? I think it would be increased if the agent is on the subscriber. Anyone know? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-10 : 22:34:55
|
| Not necessary since it'll not get additional data from publisher, unless you use distributor for other subscribers. |
|
|
|
|
|
|
Running Agent on Subscriber vs. Distributor