I have a small question in the process of replication we set up publisher,distributor and the subscriber.As a usual practice we do set up the distributor with the publisher or seperately by itself.So my question is can we set up the distributor with the subscriber than publisher???...does this anyways effect the server performance....or will there be any other issues that will arise in the process of replication Thanks in advance
Yes it is possible, if this is the case then it is the local distributor. This is manageble for smaller installation and if it is a large scale replication then better to seperate them. This will not only improve the performance but also reduce greater I/O usage to reduce impact of replication issues. http://books.google.com/books?id=au...bz_&sig=h1RassPFzKkmlKDN9TmKeH4Vta0#PPA116,M1 fyi.