Use 2 distribution database on the same server | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Use 2 distribution database on the same server

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
No issues I think using that way,http://www.awprofessional.com/articles/article.asp?p=170234&seqNum=2 for 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.
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
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.
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
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.
]]>