AltSnapshotFolder Property (Replication ActiveX)
The AltSnapshotFolder property returns or sets the path to the folder that contains the initial snapshot for a subscription.
Syntax
object.AltSnapshotFolder [= path]
Part | Description |
---|---|
object |
Expression that evaluates to an object in the Applies To list. |
path |
Path to alternate snapshot folder. |
Applies To
SQLDistribution Object (Replication ActiveX)
SQLMerge Object (Replication ActiveX)
Remarks
The snapshot folder path must include a Universal Naming Convention (UNC) or File Transfer Protocol (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 (Transact-SQL) stored procedure to copy a subscription manually.
Data Type
String
Modifiable
Read/write
Prototype (C/C++)
HRESULT AltSnapshotFolder(BSTR pVal);
HRESULT AltSnapshotFolder(BSTR* pVal);