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 |
|
sqldba_ind
Starting Member
22 Posts |
 Posted - 2007-07-30 : 07:55:51
|
| Even I have enough space in Hard disk and Transaction log file growth is auto by 10%.DTSRun OnError: DTSStep_ExecuteSQLTask_22, Error = -2147217900 (50040F14) Error string: The log file for database 'SQLDB_IN_JOY' is full. Back up the transaction log for the database to free up some log spaceCan some body help in this issueThanks&Regardssrini |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-07-30 : 08:06:53
|
"Even I have enough space in Hard disk and Transaction log file growth is auto by 10%."Is 10% of the MDF / LDF filesize MORE than the free disk space?Maybe the transaction being created is massive and would be bigger than the remaining free disk space? (I doubt that SQL would discover that UNTIL it had used up all free disk space though  )Kristen |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-30 : 23:10:06
|
| Or transaction rate is much higher than log file can grow, or timeout setting in the app is too low so can't wait for log growing. |
|
|
|
sqldba_ind
Starting Member
22 Posts |
Posted - 2007-07-30 : 23:56:40
|
quote:
Originally posted by rmiao
Or transaction rate is much higher than log file can grow, or timeout setting in the app is too low so can't wait for log growing.
Thanks KristenIn fact that 10% growth of LDF only Thanks rmiaowhat is that Application time out setting,you mean Job time out setting or some otherPlease let me know,I very much thank full to you peopleThanks&Regardssrini |
|
|
|
|
|
|
what might be the Problem?