• Hi

    1400+ virtual log files is a high fragmentation into the log file(s).

    These three articles should be enough to understand how to configure your log

    http://www.sqlskills.com/blogs/kimberly/transaction-log-vlfs-too-many-or-too-few/

    http://www.sqlskills.com/blogs/kimberly/8-steps-to-better-transaction-log-throughput/

    http://www.sqlskills.com/blogs/paul/bug-log-file-growth-broken-for-multiples-of-4gb/

    Regards,

    Igor

    Igor Micev,My blog: www.igormicev.com