Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Location
    London
    Posts
    3

    Unanswered: Reinitialize subscriptions in transactional replication

    If I have one table in one publication in transactional replication
    replication between primary and replicate is broken because subscription is marked as inactive.

    If there are 3 rows on replicate and 5 rows on primary , out of which 2 are added after replication is broken

    If I do

    Reinitialize subscriptions
    start the snapshot agent
    start the distribution agent

    Does this mean that it will only transfer the new 2 rows to replicate sites ? or will it drop everything from replicate site and apply all rows from primary site on to replicate.

    Any help is appreciated

  2. #2
    Join Date
    Sep 2003
    Location
    Dallas, Texas
    Posts
    311

    Re: Reinitialize subscriptions in transactional replication

    It will drop every article the subscriber subscribes and refresh the DDL and data from the publication.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •