• I like the snapshot method for Enterprise edition.

    An alternative would be to detach and reattach during a maintenance window. The caveat here is to ensure a backup is performed first, and to attach the database forcing a rebuild of the log. Again, these are extremes for small gains.

    Based off the prior example, this would work to recreate two small vlfs. Then the log can be grown to an appropriate size.

    USE master;

    GO

    EXEC sp_detach_db 'VLFtest'

    GO

    /* move or rename the log file */

    CREATE DATABASE [VLFtest] ON (FILENAME = 'G:\Database\Data\VLFtest.mdf') FOR ATTACH_REBUILD_LOG

    GO

    USE VLFtest;

    GO

    DBCC loginfo

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events