Replication architecture question

Last Post 31 Aug 2007 04:58 AM by Lee. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
Lee
New Member
New Member

--
30 Aug 2007 07:24 AM
Greetings:



I am working on a replication setup using transactional replication using with pull subscriptions and a separate distributor. The pull subscriptions are located on a SQL cluster using the virtual SQL Server name as the subscriber; when the box fails over, we get an error of missing replication.dlls. Researching further, we found that replication only works on one node of the subscriber.



Any ideas on what we did wrong in the setup?



Thanks,

Lee Everest





www.texas2oo.com/sqlblog
Lee
New Member
New Member

--
31 Aug 2007 04:58 AM
Hey rm hows it going?

That seems to be the general consensus. I don't know which .dlls, so the sp might be the trick. The replication works on "node 1" and it isn't working on "node 2"; we might be able to just reinstall the sp on the second node right now and then fail over and see if it works.

Looks like you have been busy still on this board?

Take care,
Lee


www.texas2oo.com/sqlblog


Acceptable Use Policy
---