The LogFiles collection contains LogFile objects referencing operating system files that maintain the transaction log records of a Microsoft® SQL Server™ database.
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 Creating operating system files used for transaction log maintenance by using the LogFiles collection requires appropriate privilege. The SQL Server login used for SQLServer object connection must be a member of the fixed role diskadmin or a role with greater privilege.
| Add Method | ItemByID Method |
| Item Method | Refresh Method |