SQL Server Performance

cluster replication

Discussion in 'SQL Server 2005 Replication' started by cnikirk, Sep 25, 2006.

  1. cnikirk Member

    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.
  2. Twan New Member

    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

Share This Page