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 |
|
rob41
Yak Posting Veteran
67 Posts |
 Posted - 2010-12-10 : 10:51:51
|
| I think this is a problem with the transaction log, does anyone know what I can do to fix it so it won't happen again?Executed as user: menlo\traxsqlsvc. ...n 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 3:30:02 AM Error: 2010-12-10 03:36:42.75 Code: 0xC0202009 Source: Data Flow Task OLE DB Destination [49] Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "The transaction log for database 'eng_db' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases". End Error Error: 2010-12-10 03:36:42.77 Code: 0xC0047022 Source: Data Flow Task DTS.Pipeline Description: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "OLE DB Destination" (49) failed with error code 0xC0202009. The identified component returned an error from the ProcessInput method. The err... The package execution fa... The step failed. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-12-10 : 11:34:33
|
| Either the disk that the transaction log lives on is full (or dangerously low on space), or you've limited transaction log growth and it needs to grow to accommodate the import.What recovery model is the database 'eng_db' in? If not in simple, are you taking regular transaction log backups? |
 |
|
|
rob41
Yak Posting Veteran
67 Posts |
Posted - 2010-12-10 : 11:40:52
|
| we do recoveries every night. I did some additional research and it looks like the problem is caused by not having delay validation turned on in the package, it's default position is off. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-12-10 : 11:57:38
|
| "we do recoveries every night"You do what? If your database is not in simple recovery, then you need to be taking transaction log backups. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-12-10 : 15:06:22
|
| Please read through this - [url]http://www.sqlservercentral.com/articles/64582/[/url]--Gail ShawSQL Server MVP |
|
|
|
|
|
|
transaction log