I am using SQL Server 2005. it's a running plant, Everyday large number of data posted into SQL Server 2005
SELECT TOP 5000 [T_idx], [T_TAG], [T_Date] FROM [house].[dbo].[total] ORDER BY T_Date DESC
From SQL Server 2005 I executed above script, and observed below error message:
5000 row effected
Msg 9002, Level 17, State 6, Line 1
The log fie for database 'tempdb' is full. Backup the transaction log for the database to free up some log space.
and the 'tempdb' file size 860 Mb and my hard disk free size 9.4 GB. Is this space is enough or do I need to free-up some space?