Brandie Tarvin (5/16/2013)
Depending on the size of the logs to be shrunk, that might not be enough, but it's a good start. Try running another Checkpoint and checking all the DBCC stuff again and see where that gets you.
But, CHECKPOINT still fails with the same error
The transaction log for database 'SharePoint_Config' is full due to 'CHECKPOINT'.
Just to recap:
- Trying to add a new log file fails with that error
- Trying to grow the existing log file fails with that error
- Trying to backup the database (even 'Copy-only Backup') fails with that error
I wonder if it is in some sort of deadlock where the checkpoint won't complete due to lack of transaction log, and the log cannot be grown because of the checkpoint.