• Perry, excellent point on TRUNCATEONLY only applying to data files (and all arguments about 'do not shrink' apply to data files just as well as to log files).

    For anyone wondering, here's a reference: http://technet.microsoft.com/en-us/library/ms189493.aspx