How do I shink this file, it's 500gig and the dump file is only 5gig? Fred

Restart the SQL Server service and read this asrticle http://technet.microsoft.com/en-us/library/cc966545.aspxBest Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

your talking sql tempdb, I'm talking reportservertempdb

What do you mean by dump file? In any case you can use select log_reuse_wait_desc,name from sys.databases to check if the log is not reusing the space for any particular reason and DBCC SQLPERF (LOGSPACE) to check what is the % of space used by the log from the total log size. If the result is nothing for the log_reuse_wait_desc you can use DBCC Shrnkfile http://msdn.microsoft.com/en-us/library/ms189493.aspx to reduce the size of the file.