Post reply

How to prevent reinitialization of all subscriptions.

  • August 7, 2009 at 10:27 am

    #156079

    How do you stop/prevent a "reinitiate all subscriptions" from publisher to subscriber?

  • August 7, 2009 at 11:46 am

    #1036199

    What kind of replication are you talking about?

    Also it would be better if you post replication questions under Replication section in this forum.

    -Roy

  • August 7, 2009 at 11:57 am

    #1036205

    1-way push subscription in MS-SS 2000.

  • August 7, 2009 at 12:09 pm

    #1036214

    You are in the wrong section of the forum to post replication issues. That too SQL 2000.

    But from what I know about Transactional replication, you usually run Snapshot or reinitialize data from publisher when your subscriber is out of sync with publisher. In normal circumstances, you do the initialization of data only at the time of setting up replication. There is a one time SnapShot agent run that will populate the data. After that it will not fire up again since the data is not out of sync.

    -Roy

  • August 7, 2009 at 12:35 pm

    #1036232

    Sorry for being in the wrong section (this is the first time I used this forum); I re-posted to the replication section. Much thanks for your help though.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply