SQL Server Performance

DB Roll Back, if replication Interupted

Discussion in 'SQL Server 2005 Replication' started by m_z_iqbal, Jun 5, 2008.

  1. m_z_iqbal New Member

    If Replication is interupted due to some reasons, what would be the status of Subsriber Database?Database would be Rolled Back or Not. if Not then how to Roll Back the DatabaseI am using Merge Replication and i tested this by disabling the network, due to this replication was stoped but Subscription DB wasn't Rolled BackThanks
  2. MohammedU New Member

    It depends on when you disabled the network, if the changes are made to the subscriber then they will commit...
    I don't think there will be any situation where rollback happens in the replication because either the changes propagated or not to the subscriber. Only rollback happens when the subscriber db goes down when the changes are applying...
    If the network goes down, it will continue when the connection re-established and merge replication is for disconnected servers/clients..

Share This Page