Points to Check when SQL Server Log File Full or SQL Server 9002 Error.

Following are the Points to Check.... 

 1. First check columns log_reuse_wait and log_reuse_wait_desc in sys.dtabases system table.

 2. Then following are the options to mange log file when SQL server is showing 9002 or Log file full error:
      Backing up the log Increase Disk Size Remove unnecessary files from Disk/ freeing disk space
      Kill long Running Unnecessary Transactions
      Add additional Disk
      Attach and Detach Log File
      Shrink Log file with truncate only
      Check for unnecessary transaction or long running queries

Increase the size of the log file Move the log file on different disk space we need to follow above steps as per the Requirement and scenarios...

 Thanks, DB