Hi all,

I've had a package which ran cleanly for some time. I've since been getting
the following error:

Error 0xc0202009: Data Flow Task: 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 'CCG_ODS'
is full. To find out why space in the log cannot be reused, see the
log_reuse_wait_desc column in sys.databases".

The database has simple transaction logging and plenty of space. Not sure
what is going on.

The log reuse from the following query was Nothing when I started the
process and sits at Active Transaction subsequently.

SELECT * FROM sys.databases

Any help would be appreciated.

Thanks in advance,
Mark

Hello MarkFrank,

are you seeing this?

http://support.microsoft.com/?id=317375

Allan

Hi Alan,

That is the error I'm seeing. I re-created a new database with simple
logging that seems to be working ok. However, switching the original to
simple did not alleviate the issue.

Thanks,

Mark

"Allan Mitchell" wrote:

One of the reasons is that just because the DB T log is set to simple it
still cannot be cleared until active transactions have finished using it.
This still means that large transactions can blow the log because the log
manager cannot breathe yet. ALSO if the log has to expand then this can
also cause this message because the query has to wait and all it knows is
that the log is full.

Allan


"MarkFrank" <MarkFrank (AT) discussions (DOT) microsoft.com> wrote