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'

Improve this question
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. Commented Sep 21, 2023 at 14:01
  • @JoelCoehoorn DBCC SQLPERF('logspace') returns 1.492188 MB log size; 116.2304% space used Commented Sep 21, 2023 at 14:07
  • @SeanLange autogrowth/maxsize is set to 10%, unlimited 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? Commented Sep 21, 2023 at 14:11

1 Answer 1

Reset to default
-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
Improve this answer
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

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.