Post reply

Autogrow configuration keeps reverting

  • February 28, 2015 at 8:18 am

    #295584

    I have a SQL Server 2008 R2 database.

    I have modified the autogrowth configuration several times. The strangest thing... they keep reverting back to the original configuration.

    Any thoughts????

  • February 28, 2015 at 8:41 am

    #1780883

    Quick question, is this on a cluster? Can you tell us how you have done it?

    😎

  • February 28, 2015 at 1:04 pm

    #1780903

    Yep. Same SQL Server 2008 R2 Cluster. We have failed over and when it was on the secondary node I checked and the autogrowth was correct.

    I noticed it this morning when I was doing a check.

    I did the change via SSMS, with a script.

  • March 2, 2015 at 2:09 am

    #1781047

    What exactly is changing?

    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

  • March 2, 2015 at 8:41 am

    #1781118

    The autogrowth properties of the file.

    The default is 10%. I change them to grown at 1GB increments. But, something changes it back to 10%.

  • March 2, 2015 at 10:48 am

    #1781167

    Check the model db. Maybe the db is being dropped and restored, and thus maybe picking up the values from the model db.

    I recommend avoiding % growth amounts anyway, so changing model will fix that for newly created dbs as well.

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

  • March 2, 2015 at 10:57 am

    #1781170

    Right. I don't like the % autogrowth either. I'll check model and see if there is something in there.

    I highly doubt the database is getting deleted and restored. I would hope, I would notice that.. 🙂

  • March 2, 2015 at 12:10 pm

    #1781188

    This one goes down into the "Its my freaking fault" folder.

    I HAD a nightly job that would check the usage on a filegroup. If the usage was under 2GB, it would change the filegrowth parameter to 10%. The files being changed, were all under the 2GB threshold.

    Moral of the story, I'm an idiot and you guys are much smarter than I.

    Thanks for your help and thought.

    Lets see if I can just figure out the other problem.. 🙂

Viewing 8 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply