SQL Server Performance

Distributer & Pull Subscription

Discussion in 'Performance Tuning for SQL Server Replication' started by Tali_SQL, May 31, 2007.

  1. Tali_SQL New Member

    Hey Guys<br />I am trying to setup transactional replication and put my distributor and pull subscription on the same server (don#%92t want to put more load on production server) But I couldn#%92t figure it out how to put distributor on my DRP box (disaster recover box). Because when I run the wizard it gives me option to put publisher and distributor on the same server but not distributor and pull subscription!<br /><br />I am using sql server 2000 standard edition with sp3a <br /><br />Thanks<br />TA [<img src='/community/emoticons/emotion-4.gif' alt=':p' />]
  2. MohammedU New Member

    When you are configuring replication you see the option to create the ditribution database other than loca in "publishing and distribution wizard window "
    Instead of choosing local computer you can choose remote computer but make sure you can access the remote server...


    All postings are provided “AS IS” with no warranties for accuracy.

Share This Page