Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
MSsnapshotdeliveryprogress (Transact-SQL)
Collapse the table of content
Expand the table of content

MSsnapshotdeliveryprogress (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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

session_token

nvarchar(260)

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.

progress_token_hash

int

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

progress_token

nvarchar(500)

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

progress_timestamp

datetime

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

Community Additions

ADD
Show:
© 2015 Microsoft