Home Forums Article Discussions Article Discussions by Author Discuss content posted by gdmilner Get Rid of All Those Pesky 1 MB File Growth DB Files RE: Get Rid of All Those Pesky 1 MB File Growth DB Files

  • December 5, 2012 at 7:09 pm

    #1565981

    Yeah, the 10% is awful. I'm afraid I don't see the point of resetting to something almost as bad.

    Why not create default growth tables based on total size, one for data and one for logs? Typically a size of anywhere from 5-20% works well for data and/or logs, modified to take into account existing file sizes, disk space available, etc..

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