Solution1:
DBCC SHRINKDATABASE ([Database-Name], 0);
Solution2:
Change the recovery model of the database to SIMPLE.
How to solve the transaction log for database is full due to ACTIVE_TRANSACTION?

