• this could be a chance to really tidy up the log and reduce the number of vlfs as well. I would try shrinking the log right down to 1mb, and then grow it again in one go up to 1GB. This will set your vlf number and sizes to optimum values.

    This is because for growths up to 64mb 4 vlfs are created, between 64mb and 1024mb 8 vlfs, and anything above 1024mb, 16 vlfs.

    If the log was initially created at 59GB (perish the thought) in one go I would expect you to have problems shrinking it to anywhere near 1GB.

    run dbcc loginfo(dbname), no of rows = no of vlfs

    ---------------------------------------------------------------------