Post reply

Single Distribution DB or multiple

  • May 21, 2009 at 7:35 am

    #205032

    Hi,

    I want to know what gurus of replication think wrt having Single Distribution DB or multiple distribution dbs for a single instance of sql server.

    Deepak

  • May 21, 2009 at 11:31 am

    #998426

    Multiple distribution DB's , i dont think so.

    Placing distributor DB will depend on which type of

    replication you opt for Push or pull.


    - Pradyothana     http://www.msqlserver.com

  • May 25, 2009 at 3:36 am

    #999604

    dkhattar (5/21/2009)

    Hi,

    I want to know what gurus of replication think wrt having Single Distribution DB or multiple distribution dbs for a single instance of sql server.

    Deepak

    Each publication can only have one distributor with one distribution DB. The real question you should think about, is do you want a local distributor or a remote distributor.

    The answer to this questions depends, among other things of the type of replication (transactional vs merge), push or pull subscribers, activity and resources of your server etc.

    [font="Verdana"]Markus Bohse[/font]

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

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