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