Share via

  • Article

How to: Manage Partitions for a Merge Publication with Parameterized Filters (SQL Server Management Studio)

Manage partitions on the Data Partitions page of the Publication Properties - <Publication> dialog box. For more information about accessing this dialog box, see How to: View and Modify Publication and Article Properties (SQL Server Management Studio). On this page you can: create and delete partitions; allow Subscribers to initiate snapshot generation and delivery; generate snapshots for one or more partitions; and clean up snapshots.

If you script a replication topology, which is recommended, publication scripts contain the stored procedure calls to create data partitions. The script provides a reference for the partitions created and a way in which to recreate one or more partitions if necessary. For more information, see Scripting Replication.

To create a partition

  1. On the Data Partitions page of the Publication Properties - <Publication> dialog box, click Add.

  2. In the Add Data Partition dialog box, enter a value for the HOST_NAME() and/or SUSER_SNAME() value associated with the partition you want to create.

  3. Optionally specify a schedule for refreshing snapshots:

    1. Select Schedule the Snapshot Agent for this partition to run at the following time(s)

    2. Accept the default schedule for refreshing snapshots, or click Change to specify a different schedule.

  4. Click OK.

To delete a partition

  1. On the Data Partitions page, select a partition in the grid.

  2. Click Delete.

To allow Subscribers to initiate snapshot generation and delivery

  1. On the Data Partitions page, select Automatically define a partition and generate a snapshot if needed when a new Subscriber tries to synchronize.

  2. Click OK.

To generate a snapshot for a partition

  1. On the Data Partitions page, select a partition in the grid.

  2. Click Generate the selected snapshots now.

To clean up a snapshot for a partition

  1. On the Data Partitions page, select a partition in the grid.

  2. Click Clean up the existing snapshots.