Change replication publisher

  • I have transactional replication on SQL2000 with 60 subscribers.

    For disaster recovery procedure i need to establish new replication within 15 minutes on another server with same subscribers.

    Can i just confogure another DB as publisher and connect exist subscribers to new publisher ??

    ThanX.

  • Hello

  • No. You must drop all subscriptions from the subscriber to all publisher.

    Create new publication in new publisher, subscribe all your subscribers, generate the snapshot and sincronize again.

  • it's possible . . . see bol "Strategies for Backing Up and Restoring Transactional Replication"

     

  • But how do you manage that subscribers connect to a publisher with a diferent name than the original??????

  • all that's in the bol referrence . . .

    "Rename the warm standby server to the name of the original Publisher. Replication will continue to distribute data changes to Subscribers."

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply