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

By FoxLearn 2/16/2024 4:34:01 AM   398
This post show you how to fix 'The transaction log for database 'x' is full due to 'ACTIVE_TRANSACTION' in SQL Server.

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