Transaction log "full" even when space is available and Autogrowth is enabled in SQL Server

Se aplica a: SQL Server 2014 DeveloperSQL Server 2014 EnterpriseSQL Server 2014 Enterprise Core

Symptoms


Assume that you run an instance of Microsoft SQL Server 2014, and you enable the AutoGrowth property for a database. Even so, changes to the database may not be saved. Additionally, you receive error messages that resembling the following that state that the transaction log is full:

If you try to back up the transaction log file, you receive the following error message:

If you try to manually grow the transaction log file, you receive the following error message:

If you query the sys.dm_db_log_space_usage DMV, the results indicate that the transaction log is 100-percent or more used. You may also find that there is sufficient free space in the storage drive to accommodate log file growth.

Resolution


This fix is included in Cumulative Update 12 for SQL Server 2014 Service Pack 2.

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

References


Learn about the terminology that Microsoft uses to describe software updates.