Unable to modify filegrowth on TEMPDB

  • I just made some modifications to the tempdb database via a script against QA and received the "command completed successfully" message. However when I go back and verify the datafiles sizes and growth rate. The size is correct, but the growthrate dosen't change. I then tried with EM and was able to make the modification, click ok with no error messages, but when I go back and check, the growth rate is what is was before. The change didn't take effect. I refreshed and disconnected each time, but the change isn't there!

    Any ideas why this would be happening?

    Thanks

  • I found this article in

    Microsoft Knowledge Base Article - 816939

    PRB: File Growth Value for TempDB is Not Persistent When Changed From Fixed Increments to Percentage

    I'm trying out the workaround now.

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

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