Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate Microsoft Fabric, Power BI, SQL, and AI community-led event. March 31 to April 2, 2025.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to: SQL Server
Attribute | Value |
---|---|
Product Name | SQL Server |
Event ID | 9002 |
Event Source | MSSQLSERVER |
Component | SQLEngine |
Symbolic Name | LOG_IS_FULL |
Message Text | 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. |
The database log is out of space. These are reasons why the log can run out of space
The log_reuse_wait_desc column in sys.databases (Transact-SQL) describes why space in the log cannot be reused.
A very common solution to this problem is to ensure transaction log backups are performed for your database which will ensure the log is truncated. If no recent transaction log history is indicated for the database with a full transaction log, the solution to the problem is straightforward: resume regular transaction log backups of the database.
For detailed information on resolving this error, see Troubleshoot a Full Transaction Log (SQL Server Error 9002).
Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate Microsoft Fabric, Power BI, SQL, and AI community-led event. March 31 to April 2, 2025.
Register today