Post reply

resync data

  • February 5, 2010 at 3:30 pm

    #216346

    Hello All,

    I have a transactional replication scenario (SQL 2000 sp4) where I have a publisher with three different subscribers(A,B and C). Recently one of the subscriber(B) had to go offline becuase of hardware failure.

    Now the server B is back online, and I am trying to resync data between the Publisher and subscriber B.

    However when I tried to run the snapshot, replication between the Publisher and the subscriber A and B is getting halted.

    So I am wondering if there are anyways to resyn the data between the Publisher and Subscriber

    B without interuppting the replicaton between the rest of the subscriber.

    Thanks in advance for looking into this.

  • February 5, 2010 at 6:55 pm

    #1114880

    I know in merge replication you can reinitialize a subscriber, which takes a recent snapshot and applies it to the subscriber and any changes since the snapshot occurred. The same option may be available for transactional replication as well.

    Otherwise you could remove the subscription from replication and re-add it.

    Joie Andrew
    "Since 1982"

Viewing 2 posts - 1 through 1 (of 1 total)

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