Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2007

    Unanswered: Replication question

    Can I implement the publisher-distributor-subscriber model as publisher to distributer/subscriber with the distribution server on the subscriber server, with the publisher on an active-passive cluster?

    1. I can't put the distribution server on the cluster (not an option)
    2. I don't have a third server for the distribution server

    I have only two servers.. OLTP and a requirement for a reporting server.
    Table level replication at the column level with filtering will be implemented.

  2. #2
    Join Date
    Jan 2003
    Provided Answers: 17
    Yes, you can. I did it several years ago on SQL 2000. SQL 2005 (or 2008) should be more flexible.

  3. #3
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    Yes, using SQL 2008 the publisher, distributor, and subscriber can all be on one machine, all on different machines, or combined in any way that is convenient.

    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts