June 10, 2008 at 9:28 am
Hi,
Transactional Replication (both pull and push) is already configured in the sql box. As we are experience performance degration on the publisher box due to the hardware problem we decided to move the publisher to a new box and the distributor and subscriber will remain the same. Can you tell me what are the steps i have to perform in moving the replication successfully.
Thanks
Chandra Mohan N
[font="Verdana"]Thanks
Chandra Mohan[/font]
June 10, 2008 at 10:35 am
Your initial config has been
P1 => D->Swhere P1 and D are the same box
and new config
P2->D->S
so I suggest that you first script out the existing publication (drop and create parts)
- this is a text file with sproc calls that you can edit for new config and re-execute later
Simplest may be to
1. configure P2 for replication
2. use the SSMS GUI on P2 to configure D as distributor
3. ditto create a "dummy" pub and sub to S
4. drop "dummy"
as this will setup all the distribution db, entries in system tables etc
then you could execute your edited script on P2 to create your original pub, sub etc
Once D's sole purpose is now to be distributor, you may want to replace the PULL DA's on S with PUSH DA's on D (since that will free-up workload on S)
HTH
Dick
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply