How to fix 'The transaction log for the database is full due to ACTIVE_TRANSACTION'

By FoxLearn 2/11/2025 7:45:04 AM   704
The error "The transaction log for database 'x' is full due to 'ACTIVE_TRANSACTION'" in SQL Server usually occurs when the transaction log file grows too large and doesn't have enough space for ongoing transactions.

This could happen for several reasons, including long-running transactions, insufficient log space, or misconfigured database settings.

Right click on your database, then select Properties.

sql database

Next, Select Options, then change the Recovery mode from 'Simple' to 'Full'

database properties

Finally, Right click on your database, then select Tasks =>Shink =>Database

Do the same way Tasks =>Shink =>File

And don't forget to check your disk make sure it not full