Home Forums Article Discussions Article Discussions by Author Discuss content posted by Simon Facer Why SHRINKFILE is a very bad thing, and what to do about it. RE: Why SHRINKFILE is a very bad thing, and what to do about it.

  • November 9, 2010 at 5:31 am

    #1248169

    giles.clapham (11/9/2010)

    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

    Yes, indeed. It's only the data in the file that gets backed up, not the file itself. If your log is empty, backing it up will have no impact, no matter how much space the log file occupies on disk.

    John