共用方式為


LogFolder Property

未來的 Microsoft SQL Server 版本將移除這項功能。請避免在新的開發工作中使用這項功能,並規劃修改目前使用這項功能的應用程式。

The LogFolder property identifies the operating system directory storing the file that maintains Microsoft SQL Server database transaction log records.

語法

object
.LogFolder [=value]

Parts

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

  • value
    A string that identifies an existing operating system directory by name

Data Type

String

Modifiable

Read/write if the DistributionDatabase object is used to create a database used by replication for publication distribution. Read-only if the DistributionDatabase object references an existing replication distribution database.

Prototype (C/C++)

HRESULT GetLogFolder(SQLDMO_LPBSTR pRetVal);
HRESULT SetLogFolder(SQLDMO_LPCSTR NewValue);

[!附註]

SQL Distributed Management Objects (SQL-DMO) strings are always returned as OLE BSTR objects. A C/C++ application obtains a reference to the string. The application must release the reference using SysFreeString.

備註

The LogFolderproperty is a string of up to 260 characters.

Specify an operating system file using the LogFile property. Specify an operating system directory using the LogFolder property. Use drive-and-directory-based or universal naming convention (UNC) file naming. For example, the strings "C:\Program Files\Microsoft SQL Server\Data" and "\\Seattle1\Program Files\Microsoft SQL Server\Data" are each valid for LogFolder.

請參閱

參考