Hi, In our environment we are planning to set up replication betwen three servers with publisher running on SERVER A, Distributor on Server B, Subscriber on Server C. Can this be done? If yes can anyone share me the documents with me? Regards, Ravi
This can be done. In fact, this is one good way if both your publisher and subscriber are busy servers. Please make sure Server B can see Server A & C You need to configure Server B as the distribution server (When you configure the server for replication with local distribution, it will create distribution database there.) On Server A, when configuring for replication, you need to use remote distributor - pointing to Server B Now create the publication and then the subscription. Make sure you create appropriate access rights for repldata folder and the accounts used by replication agents. Please refer books online for more details. One good book on this topic is "Pro SQL Server 2008 Replication" http://www.amazon.com/Server-2008-Replication-Experts-Voice/dp/143021807X
For specific information on configuring publisher/distributor http://technet.microsoft.com/en-us/library/ms151192.aspx http://msdn.microsoft.com/en-us/library/ms151781.aspx Hope this helps!
