SQL-DMO
LogFiles Collection
The LogFiles collection contains LogFile objects that reference operating system files that maintain the transaction log records of a Microsoft® SQL Server™ database.
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 2000 and SQL Server version 7.0. However, the LogFiles2 collection extends the functionality of the LogFiles collection for use with features that are new in SQL Server 2000.