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 |
|
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. |
 |
|
|
gsuresh
Starting Member
22 Posts |
Posted - 2012-11-15 : 04:59:19
|
| Thanks Sodeepsuresh |
|
|
|
|
|
|
sql server 2008