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...


    MohammedU.
    Moderator
    SQL-Server-Performance.com

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

Share This Page