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

 All Forums
 Site Related Forums
 Article Discussion
 Article: What To Do When tempdb Is Full

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-08-23 : 23:24:23
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.

mubin
Starting Member

1 Post

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

enjoy
Go to Top of Page
   

- Advertisement -