Snapshot Agent (New Publication Wizard)

Applies to: SQL Server Azure SQL Managed Instance

The Snapshot Agent creates files containing the publication schema and data that are used to initialize new subscriptions. By default, the Snapshot Agent runs immediately after the publication is created in the New Publication Wizard. Subsequently, the agent runs according to a schedule you specify. Whether the agent creates new snapshot files each time it runs depends on the type of replication and options chosen. For more information, see Create and Apply the Snapshot.

For merge publications that use parameterized filters, you must create a snapshot for each partition of data after the publication snapshot has completed. For more information, see Snapshots for Merge Publications with Parameterized Filters.

Options

Create a snapshot immediately (merge replication) or Create a snapshot immediately and keep the snapshot available to initialize subscriptions (transactional replication)
Select this check box to create a snapshot immediately after the New Publication Wizard is completed. Clear this check box if you plan to change snapshot properties in the Publication Properties dialog box before generating a snapshot, or if you will initialize the Subscriber without a snapshot. For more information, see Initialize a Transactional Subscription Without a Snapshot.

Note

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

Schedule the Snapshot Agent to run at the following times
Accept the default schedule for running the Snapshot Agent, or click Change to specify a schedule.

See Also

Create a Publication
Create and Apply the Initial Snapshot
View and Modify Publication Properties
Initialize a Subscription with a Snapshot
Publish Data and Database Objects
Replication Agents Overview