How to create a dynamic snapshot (Enterprise Manager)

How to Install SQL Server 2000

How To

How to create a dynamic snapshot (Enterprise Manager)

To generate a dynamic snapshot

Note  You must generate a regular snapshot to the dynamically filtered merge publication before creating a dynamic snapshot.

  1. Create the merge publication with dynamic filters enabled and specified on any necessary articles.

  2. Generate the regular snapshot by running the Snapshot Agent.

  3. At the Publisher, in SQL Server Enterprise Manager, expand the Replication and Publications folders, right-click the dynamically filtered merge publication, and then click Create Dynamic Snapshot Job.

  4. On the Specify Filter Criteria page, type in the system functions used in the dynamic filters of the publication (SUSER_SNAME() or HOSTNAME()) and the value of the login for the Publisher.

  5. On the Specify Snapshot File Location page, type the path to the folder where you want snapshot files saved or click the browse button (...) and browse for the folder location. Using the alternate snapshot location feature, you can specify the snapshot folder location on the network, on removable media or on an FTP server.

  6. On the Set Job Schedule page, select Using the following schedule, and then select Change to specify a schedule for when the dynamic snapshot will be generated, or select On demand only. Select the Create the first snapshot immediately check box to generate the dynamic snapshot immediately.

  7. On the Specify Job Name page, type in a name for this dynamic Snapshot Agent.

  8. Run the dynamic snapshot agent job

To apply the dynamic snapshot

  1. At the Subscriber, create a pull subscription using the Pull Subscription Wizard. On the Snapshot File Location page, select Use the snapshot from files from the following folder, specify or browse for the location of the dynamic snapshot in the text box, and then select This is a snapshot for a dynamically filtered subscription.

  2. Finish the steps in the Pull Subscription Wizard. Manually start the Merge Agent (using Replication Monitor at the Publisher or programmatically) when the snapshot is available to apply it at the Subscriber.