• Hi Paul,

    I appreciate your comments and advice but just to clarify, and I'm open to being educated on this, my DBs are in Simple recovery they get backed up (Full) frequently.

    Occasionally we have the need to import large amounts of data which needs some form of processing and validation and we end up with a bloated transaction log. An empty but bloated transaction log.

    This transaction log now gets backed up as part of the Full backup which takes additional time and resources.

    So would you still say shrinking the log file back to it's pre mass import size is a bad thing?

    Giles