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 - 2002-06-12 : 08:07:54
|
| Ajay writes "HiTempdb is allocated around 14 GB space in the system, overwhich only 13 MB is being used. I think this is due to the unrestricted and automatic file growth specified for the tempdb. During initial data import or similar functions, the tempdb might have gone huge, but the problem now is that I am running out space in the server. Can I reduce the space allocated? I've tried 1) Shrink DB. The space allocated is not changing2) Altered teh physical file to a newly created tempdb_data with 1 MB, but after restarting SQL server, the new file is allocated to teh same size as the original, with the same used space.Can I delete tempdb and recreate it? or will SQL server recreate it if I delete? Please help.. Ajay" |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2002-06-12 : 08:15:58
|
| Truncate your log file...see [url]http://www.swynk.com/friends/krishnan/tranlogshrink.asp[/url] for more....PeaceRickEdited by - RickD on 06/12/2002 08:16:25 |
 |
|
|
efelito
Constraint Violating Yak Guru
478 Posts |
Posted - 2002-06-12 : 10:29:56
|
| Simply stopping and restarting the SQL Server service may get you what you're looking for as well. Check the original size of tempdb by right clicking on tempdb and selecting properties. You should see the original size specified in the space allocated column. When you restart SQL Server tempdb will be rebuilt to this size.Jeff BanschbachConsultant, MCDBA |
|
|
|
|
|
|
Tempdb Size problem