Merge replication in sql server 2000

• aks_osd

  Old Hand

  Points: 337

  More actions

  July 22, 2008 at 2:32 pm

  #126697

  I have merge replication configured on my server on 3 databases. Publisher and Distributor are my same server and i have 1 subscriber.

  Now there is one request i have got to change the SQL SERVER name.

  Can anyone please tell me how do i proceed with this when my MERGE REPLICATION is already configured on the server. ??

  I PLANNED TO :

  A) STOP RELICATION FIRST

  B) THEN USING SP_DROPSERVER AND SP_ADDSERVER

  C) AND THEN ENABLING REPLICATION AGAIN.

  BUT HAVE LITLLE CONFUSION. AS THE REPL WORKS AND CAN BE CONFIGURED ONLY WITH THE SERVER NAME. SO IS THIS REALLY FINE TO MOVE ON THE ABOVE MENTONED STEPS?????????

• sqlservercenter-793614

  SSC-Addicted

  Points: 463

  More actions

  July 22, 2008 at 3:42 pm

  #846731

  STOP THE SUBSCRIBE FIRST!

  THEN STOP PUBLISHER.

  DO NOT MAKE WRONG SEQUENCE.

  THAT WILL MAKE DATA LOST.

  ---

  [font="Arial"]MCDBA, MCITP (DB Dev, DB Admin), MCSE,MCTS, OCA 10g[/font]