SQL Server Performance

Use 2 distribution database on the same server

Discussion in 'Performance Tuning for SQL Server Replication' started by cchitanu, Oct 28, 2004.

  1. cchitanu New Member

    Hi,
    It is posible to use 2 distribution databases on the same server(publisher)? The server is configured to be both : publisher and distributor. We need to separate the distribution databases on different disks for disaster recovery.

    I was able to create 2 distribution databases but the transactional replication is only using one of them. Is there any chance to use sp_adddistpublisher stored procedure to configure the publisher to use the second distribution db or this will kill my replication ?

    Best Regards

    Cristian
  2. satya Moderator

  3. cchitanu New Member

    Satya,
    Actually it is not posible to use the same publisher(server) with two distribution databases. You could have only one distribution database per publisher(in the case you use the same server as publisher, distributor).
    Please corect me if I am wrong.

    Best Regards
  4. satya Moderator

    BOL refers on multiple distribution databases :
    In most cases, you need only one. This feature is for users who are centralizing replication operations and administration and want one distribution server to host many Publishers. You can support many Publishers to one distribution database. However, there may be cases in which you want to separate logical replication applications into separate databases for administration purposes. In this case, use multiple distribution databases. Multiple distribution databases may also provide a performance benefit by reducing contention (both writing to and reading from the distribution database).


    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  5. yasin New Member

    hi there
    i am using sql server 2000, in replication it indicates error as follows
    'The process could not connect to subscriber 'subscriber server'
    please help me

    thanx

    by yasin
  6. satya Moderator

    The link to the subscriber or the subscriber-server is down. Try pinging the subscriber. If pinging is unsuccessful then resolve the network connectivity problem first.

    This problem will also occur if SQL Server Agent is set-up to use the System account instead of a domain account (that is recognised at the subscriber).

    And also refer to this KBAhttp://support.microsoft.com/default.aspx?scid=kb;en-us;321822 for further information.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page