• Well you have one batch of commands to alter the path and file location for tempdb and the other is to modify the data and log file size. For changes to take effect on the path, you would need to restart SQL server.

    As for the growth, if you are concerned about the growth and size of your tempdb, you should find out what is causing the growth. Fix that and then look into altering the size of the files.

    For info on methods to find the root cause of the growth, check out this article -

    http://www.sqlservercentral.com/articles/Log+growth/69476/

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events