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

SnapshotMethod Property

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

The SnapshotMethod property controls creation of the initial snapshot of published article data.


object
.SnapshotMethod [= value]
object

An expression that evaluates to an object in the Applies To list.

value

A long integer that specifies snapshot creation parameters as described in Settings.

Long, enumerated

Read/write

HRESULT GetSnapshotMethod(SQLDMO_INITIALSYNC_TYPE* pRetVal);
HRESULT SetSnapshotMethod(SQLDMO_INITIALSYNC_TYPE NewValue);

Set value using these SQLDMO_INITIALSYNC_TYPE values.

Constant Value Description

SQLDMOInitSync_BCPChar

1

Uses Microsoft SQL Server bulk copy in character data format to transfer data for initial synchronization.

SQLDMOInitSync_BCPNative

0

Uses SQL Server bulk copy in native data format to transfer data for initial synchronization.

SQLDMOInitSync_Concurrent

3

Uses concurrent snapshot processing (transactional replication).

SQLDMOInitSync_/ConcurrentChar

4

Concurrent snapshot that generates character mode BCP files. It is required if the AllowDTS property is set to TRUE.

SQLDMOInitSync_Default

0

SQLDMOInitSync_BCPNative.

SQLDMOInitSync_Max

4

The maximum Initial Synchronization mode value.

SQLDMOInitSync_Min

0

SQLDMOInitSync_BCPNative.

SQLDMOInitSync_Unknown

10

The value is not valid.

If an application sets SnapshotMethod after the initial snapshot has been created, a new snapshot must be generated. Snapshots are applied when the next scheduled snapshot agent runs.

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

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.