Iam working as production DBA, Tempdb is full in Ms-Sql server, what can i do with out stopping server

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 734841 More actions · Answer 1

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.

newmanp Mr or Mrs. 500 Points: 555 More actions · Answer 2

If you cannot use autogrow would running a dbcc shrinkdatabase on tempdb help?

SQLBill SSC Guru Points: 51440 More actions · Answer 3

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