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 appreciatedIt will drop every article the subscriber subscribes and refresh the DDL and data from the publication.
Tuesday, March 20, 2012
Reinitialize subscriptions in transactional replication
Labels:
broken,
database,
marked,
microsoft,
mysql,
oracle,
primary,
publication,
reinitialize,
replicate,
replication,
replicationreplication,
server,
sql,
subscription,
subscriptions,
table,
transactional
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment