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 |
|
sachinsamuel
Constraint Violating Yak Guru
383 Posts |
 Posted - 2006-10-18 : 10:23:49
|
| Hi Experts!I have a database in sql 2005 whose TempDB has grown. It has also got some .ndf files to it. The .ndf files are of 16 GBWhat is the best way to reduce the size.I tried putting the server on minimum configuration and then altering the database size. I was able to put it on minimum configuration but not able to alter as I am not able to open Query analyser. It doest allow me to login. Please help. This is bit urgent.Thanks in advanceSachinDon't sit back because of failure. It will come back to check if you still available. -- Binu |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-10-18 : 10:34:06
|
| i'm not an expert but you need to figure out why the tempdb is growing to such a size... it may be normal and what you need to do is increase the disk storage, you can move the tempdb to another location with more spacewhat permission do you have on the server? why is QA not allowing you to login? are you the DBA?--------------------keeping it simple... |
 |
|
|
sachinsamuel
Constraint Violating Yak Guru
383 Posts |
Posted - 2006-10-18 : 11:08:49
|
| Yes I am. There were some activity performed in this DB last week. They were just some temporary testing excersise. Now I need to reduce the size.This is not a production database.ThanksSachinDon't sit back because of failure. It will come back to check if you still available. -- Binu |
|
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-10-18 : 11:44:43
|
| Have you got the ALLOW_SNAPSHOT_ISOLATION or READ_COMMITTED_SNAPSHOT database options turned on? If so, row versions are stored in the tempdb database and that might be the cause of the growth you are seeing?Also, are you using Notification Services - it can cause a lot of tempdb growth too?If it is not a production server, then stop and restart it, that will reduce TempDB in size very fast. |
|
|
|
sachinsamuel
Constraint Violating Yak Guru
383 Posts |
Posted - 2006-10-18 : 15:12:51
|
| Thanks a lot SnSQL for your great help.RegardsSachinDon't sit back because of failure. It will come back to check if you still available. -- Binu |
|
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-10-18 : 15:54:37
|
| You're welcome, note that there is a very good article on calculating and understanding tempdb space usage for SQL Server 2005 herehttp://www.microsoft.com/technet/prodtechnol/sql/2005/workingwithtempdb.mspx |
|
|
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
Posted - 2006-10-19 : 00:36:22
|
| Hi Sachinyes as the name suggests Tempdb is the template db.You can restart your sql server .RegardsNitin |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-10-19 : 00:42:29
|
Tempdb is temporary db not template db 
KH |
|
|
|
|
|
|
Urgent Help!