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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-09-20 : 08:30:55
|
| Srinivas writes "I am using SQL 2000 in Windows 2003 SBS with Raid 5iWhat should i suppose to do if the tempdb is full. It has almost taken all the hdd free sizeI can't even restart the SQL server.Please advice...!RegardsSri" |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-09-20 : 09:33:08
|
| Some mega large query has run, and used up all of TEMPDB for temporary storage.Restarting SQL Server _should_ cause TEMPDB to be recreated, but maybe SQL doesn't have enough disk space to get started at all. Anything you can delete (old backups etc.) to create just enough room to retry the "restart"?Kristen |
 |
|
|
|
|
|
tempdb is Full