Results 1 to 2 of 2

Thread: sql server replication with multiple distribution dbs (load balancer)

  1. #1
    Join Date
    Mar 2007
    Posts
    27

    sql server replication with multiple distribution dbs (load balancer)

    Hi
    I Have an instance (sql server 2000 sp3a) with 80 database and for 40 of these databases and I have transactional replication setup to another server.
    Publisher server acts as the distributer so I have a distribution database on that instance.

    Problem: now I have to replication all 80 database and Before I start setting them up as publication, I know that I will have locking problem on distribution db (on MSrepl_commands and MSrepl_transactions) due to number of transactions . log reader and distributer agents will block each other.
    I am wondering if I can have more than one distribution database for the same instance so I can spread the load between to different databases.
    What is the best practice in this scenario?
    Many Thanks

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    No you can't, unless use multiple distributors.

Posting Permissions

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