0

The database in question is set to SIMPLE recovery mode. The disk is not out of space. The database is essentially read only. I can't change any of its properties or run a checkpoint. The transaction log is not particularly large; only 1.5 MB; and is set to be able to grow.

Full error message:

Msg 9002, Level 17, State 1, Line 4
The transaction log for database [dbName] is full due to 'CHECKPOINT'

Things I've tried:

Backing up the log : N/A, set to SIMPLE recovery mode

Changing recovery mode to FULL :

Alter failed; transaction log is full due to 'CHECKPOINT'

Running a checkpoint :

Msg 5901, Level 16, State 1, Line 1
One or more recovery units belonging to database '[dbName]' failed to generate a checkpoint. This is typically caused by lack of system resources such as disk or memory, or in some cases due to database corruption. Examine previous entries in the error log for more detailed information on this failure.

Msg 9002, Level 17, State 1, Line 1
The transaction log for database '[dbName]' is full due to 'CHECKPOINT'.

Adding additional log file :

Alter failed; transaction log is full due to 'CHECKPOINT'

11
  • 1
    What do you get if you run dbcc? Commented Sep 21, 2023 at 13:58
  • You might also check the properties on your database files. They may have a max size set for them and they are full.
    – Sean Lange
    Commented Sep 21, 2023 at 14:01
  • @JoelCoehoorn DBCC SQLPERF('logspace') returns 1.492188 MB log size; 116.2304% space used
    – praxidyke
    Commented Sep 21, 2023 at 14:07
  • @SeanLange autogrowth/maxsize is set to 10%, unlimited
    – praxidyke
    Commented Sep 21, 2023 at 14:08
  • Ugh. Percent growth is rather awful but not an issue for this discussion. What about DBCC CHECKDB? Any errors?
    – Sean Lange
    Commented Sep 21, 2023 at 14:11

1 Answer 1

-1

I was able to resolve this issue using the following procedure:

  • take the database offline
  • delete the contents of the .LDF log file
  • bring the database online
  • follow the procedure outlined in this answer on StackOverflow
2
  • Please duplicate the essential points here as s quote. Commented Sep 21, 2023 at 20:27
  • 5
    "delete the contents of the .LDF log file" you probably lost data, which was waiting to be checkpointed. This is not the right answer in most situations. Commented Sep 21, 2023 at 23:36

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.