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 |
|
SQLCode
Posting Yak Master
143 Posts |
 Posted - 2004-04-12 : 15:36:00
|
| Hi,Thanks for all the wonderful help in the past. This time it is more crucial. Tempdb is full in prod.I immediately added a secondary file, restricted the filegrowth and I am planning on moving it to a different drive which has more space.Is this right thing to do? Do you have any more suggestions?TIA. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-12 : 15:39:08
|
| Yes that is what you do when tempdb is on a drive that doesn't have enough free disk space. The ultimate thing to do would be to add more drives to the array to support tempdb.Tara |
 |
|
|
MuadDBA
628 Posts |
Posted - 2004-04-12 : 15:46:36
|
| OR, figure out what the heck is using up all your tempdb space, and look into optimizing it. |
|
|
|
|
|
|
TempDB full