9002

Product

Name

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

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

column in

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

ﾉ

Expand table