Consider the following scenario. You create a merge
publication in Microsoft SQL Server 2005. The merge publication meets the
following requirements:
| • | The merge publication contains a parameterized
filter. |
| • | A
snapshot of
a precomputed partition of the merge publication is
created. |
| • | You enable the FTP snapshot delivery feature for the merge
publication. |
You also create a pull subscription that meets the following
requirements:
| • | The pull subscription is created on a different computer
than the computer where the merge publication is created. |
| • | The pull subscription is configured to receive the
precomputed partition of the merge publication. |
Additionally, the Merge Agent of the pull subscription cannot
access other snapshot folders on the distributor.
You run the
Merge Agent to initialize or reinitialize the subscription database. In this scenario, you
receive the following message:
Creating the partitioned snapshot, since it was not already available for this Subscriber.
Note If you run the Merge Agent in SQL Server Management Studio, you
receive this message under
Status in the
View
Synchronization Status dialog box. If you run the Merge Agent by running the Replmerg.exe file manually, you receive this message at the
command prompt where you run the Replmerg.exe file.
However,
you expect that the Merge Agent uses the existing snapshot for the precomputed
partition instead of re-creating a snapshot.
Back to the top
This issue occurs because the Merge Agent behaves as if
the snapshot for the precomputed partition is
unavailable.
Before a Merge Agent in SQL Server 2005 accesses the
snapshot for a precomputed partition, the Merge Agent verifies that
the snapshot exists. However, if you run the Merge Agent to initialize or
to reinitialize a
subscription database, the Merge Agent only verifies
snapshots
on a Universal Naming Convention (UNC) path. In this situation, the Merge Agent behaves as if the snapshot is unavailable,
even if a valid snapshot for the merge publication exists in the FTP folder.
Therefore, the Merge Agent re-creates a snapshot of
the precomputed partition.
Back to the top
This
behavior is by design.
Back to the top