• Eric M Russell (8/31/2015)


    TEMPDB will automatically shrink whenever SQL Server is restarted, which might be most reliable way to do this, if needed. However, unless your TEMPDB is competing for storage with other databases, then there is no practical reason to shrink it ever. Ideally, TEMPDB should be allocated on a dedicated disk of it's own and just allowed to grow as needed.

    Thank you.

    Well I had no disk space available. Before I made my post I was able to free up 13.6 of Disk Space.

    I had to restart SQL Server.

    There was not a lot of activity on the Server.

    tempdb is on a Disk of it's own.

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/