共用方式為


LogFiles Collection

未來的 Microsoft SQL Server 發行版本將不再提供此功能。請避免在新的開發工作中使用此功能,並計劃修改目前使用此功能的應用程式。

The LogFiles collection contains LogFile objects that reference operating system files that maintain the transaction log records of a Microsoft SQL Server database.

顯示目前物件的 SQL-DMO 物件模型

Properties

Count Property

Methods

Add Method

ItemByID Method

Item Method

Refresh Method

備註

With the LogFiles collection, you can configure SQL Server transaction log disk usage. For more information about creating operating system files for transaction log use, see LogFile Object.

When using the Item method, the LogFiles collection supports member identification using only ordinal reference syntax. For example:

Set oLogFile = oTransactionLog.LogFiles(1)
ms134951.note(zh-tw,SQL.90).gif附註:
The LogFiles collection is compatible with instances of SQL Server version 7.0 and later. However, the LogFiles2 collection extends the functionality of the LogFiles collection for use with features that are new in SQL Server 2000.

請參閱

參考

LogFiles2 Collection

說明及資訊

取得 SQL Server 2005 協助