Server: Msg 9002, Level 17, State 6, Procedure DelTDByTrxNum, Line 83
The log file for database 'agresso' is full. Back up the transaction log for
the database to free up some log space.

How do I check the archive log files sizes, how full they are, how to auto extend the log files? How can I fix the error above?