Initialize Subscriptions

THIS TOPIC APPLIES TO: yesSQL ServernoAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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.

See Also

Create a Pull Subscription
Create a Push Subscription
Initialize a Subscription
Subscribe to Publications