• If you need a (very) large log, rather than a single very large allocation, you might be better off growing in somewhat smaller chunks. For example, if you need a 20GB, maybe shrink to smallest size, add space to 5GB, grow to 10GB, grow to 15GB, then grow to 20GB. That keeps the size of the VLFs from being extremely large.

    SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.