Error 9002 SQL Transaction Logs are full.

Version 1

    Details

    When the transaction log becomes full, SQL Server Database Engine issues a 9002 error. The log can fill when the database is online or in recovery. If the log fills while the database is online, the database remains online but can only be read, not updated. If the log fills during recovery, the Database Engine marks the database as RESOURCE PENDING. In either case, user action is required to make log space available.


    Resolution

     

    The following information may be used for purging your SQL transaction logs:


    Note: This information is provided as-is, as FrontRange Solutions does not administer or support MS SQL.  This information should be used by someone familiar with MS SQL such as a Database Administrator.