Post reply

Deleted Records in One Table [Transactional Replication]

  • January 3, 2019 at 12:37 pm

    #378927

    On the Subscriber DB (S-DB), a user deleted records by accident.

    I can identify the missing records using columns keys (I have no  identity column). Can I just copy these missing records back into the table?

    TIA

  • January 3, 2019 at 12:58 pm

    #2017908

    ARPRINCE - Thursday, January 3, 2019 12:37 PM

    On the Subscriber DB (S-DB), a user deleted records by accident.

    I can identify the missing records using columns keys (I have no  identity column). Can I just copy these missing records back into the table?

    TIA

    Usually yes as long as your positive that is the extent of the issue and you have the correct rows to add to the subscriber.

    Sue

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

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