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 |
|
pelegk2
Aged Yak Warrior
723 Posts |
 Posted - 2006-10-31 : 04:50:58
|
i am reciving this error :quote:
MSSQLSERVER - " Error: 9002, Severity: 17, State: 6 The log filefor database 'tempdb' is full. Back up the transaction log for the database to free up some log space.
i am running a very big night process andsome times i get the above message i dont have contro over the tempDB size as its configured to auto=growth)what can i do with the aboev message?thnaks in advancepelegIsrael -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-10-31 : 04:57:59
|
| "i dont have contro over the tempDB size as its configured to auto=growth"In that case I reckon the disk is actually becoming full, so the next automatic database growth (of any other database that is using that drive) is going to fail, with possibly unpredictable application results!)How big is TEMPDB getting? A couple of GB or hundreds of GB?Can the overnight task be changed, e.g. to delete in batches, rather than millions of rows all in one go?Kristen |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-10-31 : 04:58:37
|
| increase disk space?or divide the task by batch--------------------keeping it simple... |
|
|
|
pelegk2
Aged Yak Warrior
723 Posts |
Posted - 2006-10-31 : 05:46:02
|
| the tempDB grow up to 5 GB i thinklater on i run a JOB of shrink for the tempDBa lack of DISK SPACE is seem's to be the problemthnaks allpelegIsrael -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
|
Kristen
Test
22859 Posts |
|
|
|
|
|
'tempdb' is full message