Was this page helpful?
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Initialize Subscriptions


Subscribers must be initialized before they can begin receiving replicated data. An initial dataset is not required, but the Subscriber must at least have the schema for each replicated object and any metadata tables and procedures required by replication.

Subscription properties

Select the check box in the Initialize column for each Subscriber that requires an initial data set. If the check box is cleared, only the replication metadata and procedures will be initialized. For more information about initializing a subscription without a snapshot, see Initialize a Transactional Subscription Without a Snapshot.

Select Immediately from the drop-down list box in the Initialize When column to have the Merge Agent or Distribution Agent transfer snapshot files to the Subscriber after this wizard is completed. Select At first synchronization to have the agent transfer the files the next time it is scheduled to run. The Immediately option is not available for pull subscriptions to Microsoft SQL Server Express. The Merge Agent and Distribution Agent do not run on instances of SQL Server Express; therefore the subscription must be initialized through another method.


The wizard might prompt for a connection to the Distributor in order to start the appropriate job for the Distribution Agent or Merge Agent.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft