• muthyala_51 (9/17/2012)


    Hi,

    I have setup replication with sync type-replication support only and it's working fine. If I need to reinitialize the subscriptions of any publication, do I need to completely drop the subscription and create it again with default settings? Any other way of doing it by retaining the existing settings?

    Thanks,

    Back to the original question. No you cannot reitialise a subscription using 'replication support only' or 'none'. At least thats what happened when I set up a couple of tests

    You have to use automatic.

    Which in a way makes sense, you wanted create the subscription without initialising so you are prevented to do so in the future.

    What settings do you want to keep?