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.
| Author |
Topic |
|
chetan_dba
Starting Member
21 Posts |
 Posted - 2008-04-02 : 05:15:14
|
| Hi all ,this is chetan .SQl server DBa.i want to know that what should be done when tempdb is full.Thanks in advance...Thanks in advance.-- Chetan |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2008-04-02 : 05:18:49
|
| Find out why it got full?Make it bigger?Kill any processes that are holding objects should release space or a restart of the server will recreate an empty tempdb.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2008-04-02 : 14:02:18
|
| I agree about finding out why it got full and possibly make it bigger. I don't necessarily agree with killing the processes unless you are absolutely certain that isn't going to cause other issues. However, if the system is locked up, you have little choice but to restart the services (which'll kill the processes). Be prepared for rollbacks in this instance (additional downtime).Terry |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-02 : 23:28:18
|
| If log is full (most likely), you can free up some space with 'backup log tempdb with truncate_only'. |
|
|
|
|
|
|
Temp Db