Home Forums SQL Server 2008 SQL Server 2008 High Availability One Way Transactional Replication: Multiple subscribers for single Publisher RE: One Way Transactional Replication: Multiple subscribers for single Publisher

  • May 23, 2013 at 2:12 am

    #1617733

    chandan_jha18 (5/23/2013)

    Thanks Bhaskar. Will try this option once to see how it works. I have a question though. Lets say that the replication is running for 1 subscriber and I edit the publication property to reinitialize from backup.

    Now while I take the backup, there will be new transactions originating from publisher. So will those be automatically applied to the subscriber when i restore the subscriber database from backup or do i need to do anything else

    Thanks

    Chandan

    After you take backup and till you apply it on subscriber, disable the Distribution clean up: distribution agent, this will stop the cleanup of distributed transaction after replication to subscriber, after subscription added sucessfully, you can re-enable this agent so all the pending transaction will get applied to new subscriber too..

    To Disable this agent Goto SSMS -> Sql Server Agent -> Jobs -> Distribution clean up: distribution.