To fix this problem, change Recovery Model to Simple then Shrink Files Log

1. Database Properties > Options > Recovery Model > Simple

2. Database Tasks > Shrink > Files > Log

Reference: https://stackoverflow.com/questions/17674973/the-transaction-log-for-the-database-is-full