MSSQLSERVER_9002
Applies to: SQL Server
Details
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. |
Explanation
The database log is out of space. These are reasons why the log can run out of space
- Log not being truncated
- Disk volume is full
- Log size is set to a fixed maximum value or autogrow is disabled)
- Replication or availability group synchronization that is unable to complete
The log_reuse_wait_desc column in sys.databases (Transact-SQL) describes why space in the log cannot be reused.
User Action
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).
Phản hồi
https://aka.ms/ContentUserFeedback.
Sắp ra mắt: Trong năm 2024, chúng tôi sẽ dần gỡ bỏ Sự cố với GitHub dưới dạng cơ chế phản hồi cho nội dung và thay thế bằng hệ thống phản hồi mới. Để biết thêm thông tin, hãy xem:Gửi và xem ý kiến phản hồi dành cho