Error 9002

Severity Level 19

Message Text

The log file for database '%.*ls' is full. Back up the transaction log for the database to free up some log space.

Explanation

The specified transaction log file has run out of free space.

Action

You can:

• Free disk space on any disk drive containing the log file for the related database. Freeing disk space allows the recovery system to grow the log file automatically.

Or

1. Free disk space on a different disk drive.
2. Move the transaction log files with an insufficient amount of free disk space to the disk drive in Step 1.
3. Detach the database by executing sp_detach_db.
4. Attach the database by executing sp_attach_db, pointing to the moved files.

Or

• Either add a log file to the specified database by using the ADD FILE clause of the ALTER DATABASE statement, or enlarge the log file by using the MODIFY FILE clause of the ALTER DATABASE statement, specifying the SIZE and MAXSIZE syntax. Adding an additional log file allows the existing log to grow.

See Also