SQL Server Performance Forum – Threads Archive

cluster replication

I have a sql server 2000 active/active cluster. One of the nodes in the cluster is a publisher. I am a using sql server 2005 as a subscriber. I know that replication works fine between 2000 and 2005, but does it still work ok when the publisher and distributor are in a cluster?
My other question is how to schedule the subscriber to syncronize every night. I don’t see a way to schedule this. Thank you.

---

Hi ya, yeah it makes no difference whether the databases are clustered or not. Just make sure that any snapshot directory is on a cluster resource too, otherwise when failover occurs the snapshot directory may no longer be valid. In terms of scheduling it depends whether it is a push or pull replication as to whether the job lives on the publisher or subscriber, you can just update the schedule for the relevant job Cheers
Twan

---

]]>