SQL Server Performance Forum – Threads Archive
Distributer & Pull SubscriptionHey 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=’‘ />]
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…
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.