Export (0) Print
Expand All

AltSnapshotFolder 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 AltSnapshotFolder property specifies an alternate path to use for snapshot file creation or application.


object
.
AltSnapshotFolder [=value]

object

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

value

A string that specifies an alternate path for snapshot files

String

Read/write

HRESULT GetAltSnapshotFolder(SQLDMO_LPBSTR pRetVal);
HRESULT SetAltSnapshotFolder(SQLDMO_LPCSTR NewValue);

If used with the MergePublication2 or TransPublication2 objects, the AltSnapshotFolder property specifies an alternate location to use for snapshot file creation when a snapshot must be transported to a Subscriber. If used with the MergePullSubscription2 or TransPullSubscription2 objects, AltSnapshotFolder specifies an alternate location to use for snapshot file application.

Transporting a snapshot file using portable media, such as a removable hard drive, can be useful in situations where a Subscriber is not continuously connected. Transporting a snapshot file may also be desirable in a situation where a large amount of data might otherwise need to be applied using an expensive connection.

AltSnapshotFolder is required if the publication attribute SQLDMOPubAttrib_InternetEnabled is set.

ms133513.note(en-US,SQL.90).gifNote:
If an application sets AltSnapshotFolder with the MergePublication2 or TransPublication2 object after the initial snapshot has been created, a new snapshot must be generated. Snapshots are applied when the next scheduled snapshot agent runs.

ms133513.note(en-US,SQL.90).gifNote:
If an application calls AltSnapshotFolder on an instance of Microsoft SQL Server version 7.0, the constant, SQLDMO_E_SQL80ONLY, and the message "This property or method requires Microsoft SQL Server 2000 or later" are returned.

Community Additions

ADD
Show:
© 2014 Microsoft