Jaa


LogFiles Collection

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

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 object model that shows the current object

Properties

Count Property

Methods

Add Method

ItemByID Method

Item Method

Refresh Method

Remarks

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)

Note

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.

See Also

Reference

LogFiles2 Collection

Help and Information

Getting SQL Server 2005 Assistance