• I am having the same trouble. My tempdb files will not shrink despite the fact that only a small portion is actually in use. There are no open transactions.

    tempdev10006.94 15.389991.56

    templog113.00 9.71103.29

    tempdev2 7157.94 7.387150.56

    Shrinkdatabase, shrinkfile do not work.

    This query :

    select * from tempdb.sys.all_objects

    where is_ms_shipped = 0;

    Did produce 74 objects.

    It seems the only solution will be to bounce the instance.

    Does anyone have any other suggestions without restarting SQL Server?

    Thanks