Post reply

Multiple Transaction Log Files

  • October 25, 2004 at 11:18 am

    #165297

    I have a clustered sql server using an EMC CX300 for storage.

    Are there any issues with expanding the transaction log to use multiple files and multiple drives? I need more log space and it is much easier to add an additional lun on the san and a transaction log file than to expand an existing lun and use disk part or some other utility to get windows to recognize the space.

    Thanks

  • October 26, 2004 at 7:33 am

    #527971

    There shouldn't be any problem, but you won't get a performance boost either. Since you said you were just looking for more log space, it should work out great. SQL Server just fills the first log file, then moves onto the second, fills it, then back to the first (assuming it has been truncated, etc.).

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply