• Maybe it's just an issue I had.

    The last time I altered the SIZE of tempdb data files in SQL, when SQL restarted tempdb files were still larger than that.

    If the ALTER DATABASE ... SIZE = nnnKB beforehand will work on restart, then of course that's a much better method.

    I'm dealing with a range of servers from early SQL 2005 to late SQL 2008 so I might be mixing an earlier problem in that no longer applies.

    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".