SQL Server 2005 – Tempdb Full | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

SQL Server 2005 – Tempdb Full

We found that the tempdb was full in one of our production SQL server 2005.
We have tried to shrink the log file but the file hasnt been shrunk. The tempdb size is about 25 GB and used space is 24 GB. Could any one please help us? Thanks
S. Ramesh
Please go through this white paper:
http://www.microsoft.com/technet/prodtechnol/sql/2005/workingwithtempdb.mspx It discusses about monitoring and troubleshooting tempdb
]]>