The ex-developer set up the replication..having distributor and subscriber separate from Publisher and since i'm not a dba, i really dont want to change it...
I just want to push to a new server (S2) and then disable the subscriber/distributor to the other one (S1) after I get it working on S2...
This is what I did ....based on what rm said...to create a new publication:
1. created a new publication with one article in it. in "properties", "subscription options" tab, I marked "Use a distribution agent that is indepdent of other publications from this database".
2. In "status" tab of publication properties, i see Service Status , but i still see SQLServerAgent (On S1) Running ... This should be S2.
3. In "agent properties", in "run agent" step of the job , I have this:
-Publisher [P1] -PublihserDB[caller] -Distributor [S1] -Publication [CallerTable] -DistributorSecurityMode 1
but that distributor should be S2 I changed the job step to "S2" as distributor.
4. Pushed the new publication. Chose the subscriber S2, chose "run agent at distributor", again when i get to "Start required Services", I see S1 on the list as having SQlServerAgent running.
But still it creates it on S1 and it fails..i guess because i changed the distributor manually
Any way to publish to S2, the new server without separating distributor/subscriber as Trav described??