June 25, 2004 at 7:40 am
Iam working as production DBA, Tempdb is full in Ms-Sql server, what can i do with out stopping server
June 25, 2004 at 7:49 am
Check that tempdb is set to authogrow. You can extend tempdb onto another drive if that one if out of space.
Look for long running transactions and kill them, you may have one that is using all the space.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
June 28, 2004 at 2:40 am
If you cannot use autogrow would running a dbcc shrinkdatabase on tempdb help?
June 28, 2004 at 6:16 am
Yes, it would. Eventually. Shrinkdatabase and Shrinkfile do not work immediately.
It will take place, but for the transaction log, the inactive portions have to be located at the end of the log.
You could even use BACKUP LOG Tempdb WITH TRUNCATE_ONLY and then run SHRINKDATABASE.
-SQLBill
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply