Rebecca Lewis performs some troubleshooting:
It’s 2am. Your phone wakes you. Rub your eyes, check your email, and there it is:
Error: 9002, Severity: 17, State: 4 The transaction log for database 'trading' is full due to 'LOG_BACKUP'.The database is still online. Looks ok. You can read from it. But every INSERT, UPDATE, and DELETE fails. Production night-trading is effectively down.
The good news: It’s fixable — but, that fix depends entirely on what’s preventing log truncation.
Click through for a choose-your-own-adventure story.