Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 Site Related Forums
 Article Discussion
 Article: What To Do When tempdb Is Full
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Ask SQLTeam Question

0 Posts

Posted - 08/23/2001 :  23:24:23  Show Profile  Visit AskSQLTeam's Homepage  Reply with Quote
Sim writes "I would like to know if tempdb has become full and what to do if you cannot truncate the log? I want to understand the process why you cannot truncate it."

Article Link.

Starting Member

1 Posts

Posted - 11/13/2001 :  15:03:45  Show Profile  Reply with Quote
You should be able to truncate the log file. Now I've had this happen to me before and basically what had happened was a job had gotten hung and continued to fill up the TempDB Log File. I had to kill the job, then truncate the log file, but as soon as I truncated the log it filled up again due to the job(s) having to roll back. I had to continually truncate the log file until all the jobs had rolled back.

Go to Top of Page

Aged Yak Warrior

628 Posts

Posted - 11/14/2001 :  13:30:00  Show Profile  Reply with Quote
I have had this happen to me, where the log was filling up and I could not truncate it or shrink it because of table corruption in the tempdb. You can't run DBCC CHECKDB in the tempdb because it is in use and you can't put it in Single-User mode.

The only solution ot this I have seen is to restart the server, which clears out the tempdb. Other solutions are welcome :)

Go to Top of Page

Starting Member

1 Posts

Posted - 03/27/2007 :  04:40:20  Show Profile  Reply with Quote
Shrink the Dn to 10 %
put it in auto maintenance daily when server is not in use i.e at night timings after backup

Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000