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:07 am

    #1248159

    paul.knibbs (11/9/2010)

    and make sure you have regular backups so they don't keep growing out of control.

    Log backups are not necessary (and won't run) in simple recovery, which George indicated his databases are in.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass