Skip to Content
0
Former Member
May 03, 2012 at 02:09 PM

TempDB too large and full

74 Views

Hi

I have my production box running on Windows 2003 R2 with SQL 2005.

My temp db has grown to 120 GB and there is no more space in drive to grow it further.

I cannot restart or shrink the SQL.

I do not see any long running jobs currently.

What can be done to release the space.

Please update

Thanks and Regards

Tushar