Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

MSsnapshotdeliveryprogress (Transact-SQL)

The MSsnapshotdeliveryprogress table is used to track files that have been successfully delivered to the Subscriber when a snapshot is being applied. This data is used to resume the delivery of files in case the Merge Agent fails to deliver all of the files during the session so that the same files are not delivered again the next time that the Merge Agent is run. This table is stored at the Subscriber in the subscription database.

Column name Data type Description



Identifies the path to snapshot folder from which the file was successfully delivered. For publications that use parameterized filters, the string dynsnap will be appended to the value.



A hash value generated based on the value of progress_token that is used improve lookup efficiency for a given progress_token value.



Identifies a file that has been successfully delivered, where the value is a combination of the file name and path.



The datetime value that indicates when a snapshot file was successfully delivered.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2014 Microsoft. All rights reserved.