Error: 9002 SQL Server

Error: 9002, Severity: 17, State: 2
The transaction log for database '%.*ls' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases

Nah kalo udah nemu error database (SQL Server khususnya) kayak di atas ..
Causes :

• A very large transaction log file.
• Transactions may fail and may start to roll back.
• Transactions may take a long time to complete.
• Uncommitted transactions
• Extremely large transactions
• Operations: DBCC DBREINDEX and CREATE INDEX
• While restoring from transaction log backups
• Client applications do not process all results
• Queries time out before a transaction log completes the expansion and you receive false 'Log full' error messages
• Unreplicated transactions

How to maintenance or even solve it :

• check db integrity
• shrink db
• re-organize index
• update statistics
• backup db
• maintenance cleanup

and for additional run the dbcc shrinkdatabase("dbname", TRUNCATEONLY)