Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2013

    Unanswered: Basic Replication query

    Lets say that I have a transaction which is open for a long time on a database where we have few tables replicated.

    Will the rep-agent be able to transfer all the replication related inserts/updates etc. just before this oldest open transaction or will the rep-agent gets struck/wait till this open transaction completes ?

  2. #2
    Join Date
    Mar 2008
    All the committed trans before the open trans will replicate at replicate side, but the trans after the open tran will not be replcated as there will be no commit for open tran in log. also all the trans committed, whose commit time falls after open tran, will also be not replicated.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts