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 |
|
funketekun
Constraint Violating Yak Guru
491 Posts |
 Posted - 2007-05-23 : 10:24:11
|
| there is a sql job that failed yesterday. This job calls a store procedure. This store procedure doesn't use any temp table. But there are lots of updates and inserts clauses.application log shows:Error: 9002, Severity: 17, State: 2The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space.----------------------------------------------------------------tempdb.mdf 1.37gbtemplog.ldf 19.6 mbthese files are located on D: drive and D drive has 52gb free spacedatabasename : tempdbdatabase_size: 1422.00 mbunallocated space: 1403.60 mb----------------------------------------------------------------anyone to fix this?i used "backup log tempdb with truncate_only" But i dont know if it truncated the log file? how do i fix this problem. |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-05-23 : 10:28:50
|
| Check if this helps: [url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=64914[/url]Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-23 : 10:48:44
|
| Did you allow tempdb log file auto grow? |
|
|
|
funketekun
Constraint Violating Yak Guru
491 Posts |
Posted - 2007-05-23 : 11:35:11
|
| rmiao,tempdb is set to default. It autogrows.I have setup Data File Auto Grow and Log File Auto Grow on Profiler. It has been running for 3 hours. But nothing has been caught.Any suggestions? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-23 : 13:10:13
|
| Maybe files didn't grow yet. Did you check file size? |
|
|
|
|
|
|
The log file for database 'tempdb' is full.