Transaction log error

[Guju]

Hi all,

I am getting below error messages mentioned between dotted lines.

---------------------------------

fcb::ZeroFile(): GetOverLappedResult() failed with error 2.

The log file for database 'UAT' is full. Back up the transaction log for the
database to free up some log space..
Could not write a CHECKPOINT record in database ID 7 because the log is out
of space.

Automatic checkpointing is disabled in database 'UAT' because the log is out
of space. It will continue when the database owner successfully checkpoints
the database. Free up some space or extend the database and then run the
CHECKPOINT statement.

----------------------------------------------------------------------------
-

I have more then enough space and the log files is set to autogrow with
unlimited space.

I googled and found few people have similar issue but the resolution is not
found, yet.

Can someone please suggest something to solve this issue.

Thanks,

[MC]

Did you try manually increasing log file? I'm not certain if you have free
space in log or not?

MC
"Guju" <gu**@tpg.com.au> wrote in message
news:41********@news.iprimus.com.au...

Hi all,

I am getting below error messages mentioned between dotted lines.

---------------------------------

fcb::ZeroFile(): GetOverLappedResult() failed with error 2.

The log file for database 'UAT' is full. Back up the transaction log for
the
database to free up some log space..
Could not write a CHECKPOINT record in database ID 7 because the log is
out
of space.

Automatic checkpointing is disabled in database 'UAT' because the log is
out
of space. It will continue when the database owner successfully
checkpoints
the database. Free up some space or extend the database and then run the
CHECKPOINT statement.

----------------------------------------------------------------------------
-

I have more then enough space and the log files is set to autogrow with
unlimited space.

I googled and found few people have similar issue but the resolution is
not
found, yet.

Can someone please suggest something to solve this issue.

Thanks,

[Guju]

MC,

I have increased it from 8 mb to 15 mb and will be monitoring for few days.

Will let you know how I go.

Thanks,

"MC" <marko_culo#@#yahoo#.#com#> wrote in message
news:cn**********@brown.net4u.hr...

Did you try manually increasing log file? I'm not certain if you have free
space in log or not?

MC
"Guju" <gu**@tpg.com.au> wrote in message
news:41********@news.iprimus.com.au...

Hi all,

I am getting below error messages mentioned between dotted lines.

---------------------------------

fcb::ZeroFile(): GetOverLappedResult() failed with error 2.

The log file for database 'UAT' is full. Back up the transaction log for
the
database to free up some log space..
Could not write a CHECKPOINT record in database ID 7 because the log is
out
of space.

Automatic checkpointing is disabled in database 'UAT' because the log is
out
of space. It will continue when the database owner successfully
checkpoints
the database. Free up some space or extend the database and then run the
CHECKPOINT statement.

--------------------------------------------------------------------------

--

-

I have more then enough space and the log files is set to autogrow with
unlimited space.

I googled and found few people have similar issue but the resolution is
not
found, yet.

Can someone please suggest something to solve this issue.

Thanks,