Post reply

Distributor per publication

  • August 3, 2003 at 6:09 pm

    #101603

    Hi everyone 🙂

    I am new to replication and so my understanding is a bit scratchy in many areas. I hope my question makes sense.

    1. If I have two databases on my dataserver (A), can I publish one of these using a distributor on dataserver A and another using a distributor on another dataserver B).

    In a nutshell, can a single dataserver have publications refering to different distribution servers?

    Can in advance for your consideration.

    Mark Rodrigues

  • August 3, 2003 at 6:34 pm

    #468355

    My guess is NO. Hard to find anything in BOL that states explicitly whether you can or not, but my answer is based on:

    1) you can't run sp_adddistributor twice

    2) sp_dropdistributor doesn't give you the option of specfying which distributor to drop

    3) all BOL replication topologies show a single distributor

    4) BOL frequently referes to "the distributor" giving the distinct impression that there'll only be one.

    Cheers,

    - Mark


    Cheers,
    - Mark

  • August 3, 2003 at 6:41 pm

    #468356

    Thanks for the quick (and learned) response Mark.

    It is much appriciated.

    Mark Rodrigues

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply