Temp DB log full? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Temp DB log full?

Hi All,
I ran the following query on one of our testing databases (just an ad-hoc query as i wanted to see some examples of the data returned by the view): SELECT top 9 *
FROM view_ProductResult when it runs, it is returning the 9 rows, but i am also getting the following error: Server: Msg 9002, Level 17, State 6, Line 1
The log file for database ‘tempdb’ is full. Back up the transaction log for the database to free up some log space. Any ideas why i am getting this? there is 3gb free on the drive, the whole database is only around 3gb and there is no way the view would return anything close to that, so there is no reason I can see why the temp db log cant grow. Tempdb log is set to autogrow with no maximum size. tempDB data file is currently 107mb and the log is 2mb. I tried stopping and restarting the SQL server service but it hasnt helped. I have had a look at other posts with the same problem and none of the suggestions in them have helped Thanks
Ben ‘I reject your reality and substitute my own’ – Adam Savage
ok, it seems to be working now with no input from me! Very strange indeed! Would still be interested to hear any ideas! ‘I reject your reality and substitute my own’ – Adam Savage
HI Ben, Can you check this topic, which is related to this thread. -Johnson http://sql-server-performance.com/forum/topic.asp?TOPIC_ID=10113
thanks Johnson,
I had looked at that post previously and none of the suggestions seemed to solve my problem (hence my question). ‘I reject your reality and substitute my own’ – Adam Savage
Check this toic and links in that topic. http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=11230
Like all review thishttp://www.sqlteam.com/item.asp?ItemID=5371 article for more information. Check whether the transactions running from application are treated as open transactions, and due to that TEMPDB log will be full, try to increase the log atleast to 250mb that can accomodate the process. Satya SKJ
Contributing Editor & Forums Moderator
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.