AltSnapshotFolder Property

Replication Programming

Replication Programming

AltSnapshotFolder Property

The AltSnapshotFolder property returns or sets the path to the folder that contains the initial snapshot for a subscription.

Applies To

SQLDistribution Object

SQLMerge Object

Syntax

object.AltSnapshotFolder [= path]

Part Description
object Expression that evaluates to an object in the Applies To list.
path Path to alternate snapshot folder.
Remarks

The snapshot folder path must include a UNC or FTP designator, for example:

   objMerge.AltSnapshotFolder = "file:\\Distributor\Backup\Snapshots"
   objDistr.AltSnapshotFolder = _
      "ftp://distributor.company.com/backup/snapshots,1433"

It is recommended you use the sp_copysnapshot stored procedure to copy a subscription manually.

Data Type

String

Modifiable

Read/write

Prototype (C/C++)

HRESULT AltSnapshotFolder(BSTR pVal);

HRESULT AltSnapshotFolder(BSTR* pVal);

See Also

How to Browse and Copy Snapshot Files (Transact-SQL)