How to solve the transaction log for database is full due to ACTIVE_TRANSACTION?

How to solve the transaction log for database is full due to ACTIVE_TRANSACTION?


Solution1:
DBCC SHRINKDATABASE ([Database-Name], 0);

Solution2:
Change the recovery model of the database to SIMPLE.
Seyed Hamed Vahedi Seyed Hamed Vahedi     Wed, 9 October, 2024