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.

 All Forums
 SQL Server 2008 Forums
 High Availability (2008)
 sql server 2008

Author  Topic 

gsuresh
Starting Member

22 Posts

Posted - 2012-11-13 : 12:21:50
If temb db full.how to solve this issue?

suresh

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2012-11-14 : 17:05:41
Is Autogrow enabled? you can shrink the file but if there are open transaction, it won't have have any effect.

Place tempdb in different drive with enough space.

Restarting SQL service will reset it to initial but that is not good solution.
Go to Top of Page

gsuresh
Starting Member

22 Posts

Posted - 2012-11-15 : 04:59:19
Thanks
Sodeep

suresh
Go to Top of Page
   

- Advertisement -