SQL Server Performance

Reinitializing a Subscription and synchronization the subscription

Discussion in 'SQL Server 2008 Replication' started by vjk, Jan 13, 2011.

  1. vjk New Member

    1)what is the difference between Reinitializing a Subscription and synchronization the subscription?
    when to use reinitializing ?
    when to use synchronization?)when adding table or deleting a table what to do?(reinz.. or syn)
    when adding a column what to do?

  2. satya Moderator

    Welcome to the forums.
    Is this a interview Question?
    The answer depends on the type of replication that is used here, from Books online : When you create a subscription, you can define a synchronization schedule that controls when the replication agent for the subscription will run. If you do not specify scheduling parameters, the subscription will use the default schedule.
    By default, a subscription to a transactional publication is initialized with a snapshot, which is generated by the Snapshot Agent and applied by the Distribution Agent. In some scenarios, such as those involving large initial datasets, it is preferable to initialize a subscription using another method.

Share This Page