SQL Server Performance

Distribution jobs for two publication

Discussion in 'SQL Server 2005 Replication' started by sqlexpert, Oct 3, 2007.

  1. sqlexpert New Member

    Hi , I have two publication of two different database and they are replicating data to other server but both are sending data to same database with transactional replication , now my question is ,can i have two different distribution jobs for these two publications , currently we have one job only since subscriber database is same for both the publication databases ?
    below is the detail for our setup
    publisher -SQL 2000
    distributor-SQL 2005
    subscriber-SQL 2000
  2. MohammedU New Member

Share This Page