January 22, 2009 at 1:24 pm
Initially when we set up snapshot replication we used the same server for the distributor. This has been causing locking and/or performance issues when the snapshot agent starts up, and also even when the subscriber on the report server pulls.
Now we want to move the distributor to a different server but when I try to create the new publication it automatically defaults to the same distributor and wont let me choose a different server.
January 22, 2009 at 2:07 pm
Check out sp_adddistributor. This will allow you to do that. You will have to go to the new distributor first and establish the publishing server as a valid publisher. Once that is complete you can go to your current publisher / distributor and add a new publisher using the stored proc mentioned above or using the tools in SSMS.
Sorry about the confusion.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 22, 2009 at 3:34 pm
Just out of curiosity... can you change the distributor of an existing publication, or do you just have to drop and recreate it on the new distributor?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply