FTPSubdirectory Property

아티클
12/15/2008

Microsoft SQL Server의 이후 버전에서는 이 기능이 제거됩니다. 새 개발 작업에서는 이 기능을 사용하지 말고, 현재 이 기능을 사용하는 응용 프로그램은 수정하십시오.

The FTPSubdirectory property specifies the File Transfer Protocol (FTP) subdirectory where Internet-enabled snapshot files are stored before they are downloaded.

구문

object
.FTPSubdirectory [= value]

Parts

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

value
A string that specifies the directory in which snapshot files are stored

Data Type

String

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetFTPSubdirectory(SQLDMO_LPBSTR pRetVal);
HRESULT SetFTPSubdirectory(SQLDMO_LPCSTR NewValue);

주의

Use the FTPSubdirectory property to specify subdirectory locations in which Internet-enabled snapshot files are stored before they are downloaded. Merge Agent and Distribution Agent use the FTPSubdirectory setting to locate the snapshot files.

Typically, an FTP subdirectory is located relative to the home directory for the FTP site, and it should include the \Ftp subdirectory in the path. For example, if the home directory for the FTP site is C:\Public\Ftphome and the snapshot files are located in C:\Public\Ftphome\Snapshot\Publication1\Ftp, set the FTPSubdirectory property using the string value 'snapshot\publication1\ftp'.

FTPsubdirectory should be the same as the AltSnapshotFolder. If FTPSubdirectory is not specified, Internet-enabled snapshot files are stored in the default directory. By default, the default instance of Microsoft SQL Server stores these files in the C:\Program Files\Microsoft SQL Server\Mssql\Repldata\Ftp directory. By default, a named instance of SQL Server stores these files in the C:\Program Files\Microsoft SQL Server\Mssql$InstanceName\Repldata\Ftp directory, where InstanceName is the name of a nondefault instance of SQL Server.

Using different subdirectory locations for different publications can be useful in situations requiring varying levels of security access to the shares on a Distributor.

[!참고] If an application sets FTPSubdirectory with the MergePublication2 or TransPublication2 object after the initial snapshot has been created, a new snapshot must be generated. Snapshots are applied the next time Snapshot Agent runs.

If an application calls FTPSubdirectory on an instance of 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.