共用方式為


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);
ms136896.note(zh-tw,SQL.90).gif附註:
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 LogFolder property 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.

Applies To:

DistributionDatabase Object

請參閱

參考

LogFile Property

說明及資訊

取得 SQL Server 2005 協助