Transactional Replication re-initialize from backup RRS feed

  • Question

  • Good evening Colleagues,

    So question goes like this. If I use the option to create a publication that allows initialization from backup and then a pull subscription all is well so far.

    What happens when for whatever reason the subscription is asking for re-initialization, what are the steps involved,

    for ex:
    Drop the subscription -> take published db backup -> restore it on top of subscribed db -> recreate subscription.

     Many thanks,


    Thursday, June 25, 2015 7:25 PM