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 |
|
Ned
Starting Member
16 Posts |
 Posted - 2007-01-23 : 11:57:06
|
| Hi,I noticed our temp db is 12GB+. We recently did alot of deletes from one of our databases which I would believe would cause the log file of the particular database to increase, but I'm not sure why the temp db got so big. Is there any easy way to shrink it down? (without necessarily rebooting).For on going maintence, should we be backing up the temp db, what exactly is stored in it? (we're backing up the other db nightly)Thanks |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-01-23 : 13:17:19
|
| No need to back it up. In 2005 row versioning is all handled in the tempdb database and that can cause it to grow, also any temporary tables are created in the tempdb database, so if you have lots of temporary tables being created by applications try to drop them as soon as they are no longer in use - the sooner they are dropped, the sooner the space can be reused by other temporary tables.There's no simple solution to keeping tempdb smaller, but these articles will help you understand managing it a little betterhttp://www.microsoft.com/technet/prodtechnol/sql/2005/workingwithtempdb.mspxhttp://support.microsoft.com/kb/307487 |
 |
|
|
|
|
|
large temp db