Export (0) Print
Expand All
Expand Minimize

Initialize Subscription

SQL Server 2000

If you want Microsoft® SQL Server™ to initialize the subscription, select Yes, initialize the schema and data. After the subscription is created, the Distribution Agent or Merge Agent will run and apply the snapshot files to the Subscriber.

If you manually load the schema and data at the Subscriber, for example, using backup tapes, you do not need to initialize the subscription. Select No, the Subscriber already has the schema and data if you do not want SQL Server to apply the snapshot.

If the publication property to synchronize immediately is enabled, and the Snapshot Agent has not run, or the publication is not set to synchronize immediately, select Start the Snapshot Agent to initialize the subscription immediately to start the Snapshot Agent. If the Merge Agent or Distribution Agent is not set to run continuously, the snapshot will be applied when that agent runs according to its schedule.

If the publication property to synchronize immediately is enabled, and the snapshot has not been generated for the publication, this option will indicate that you must start the Merge Agent or Distribution Agent after the snapshot is available.

If the publication property to synchronize immediately is enabled, the snapshot has been generated, and the Merge Agent or Distribution Agent is set to run continuously, the Start the Snapshot Agent to initialize the subscription immediately check box is not displayed.

See Also

Applying the Initial Snapshot

Show:
© 2014 Microsoft