9001

Product

Name

Event ID

9001

Event Source

MSSQLSERVER

Component

SQLEngine

Symbolic

Name

LOG_NOT_AVAIL

Message Text

The log for database ’%.*ls’ is not available. Check the event log for related error

messages. Resolve any errors and restart the database.

Error 9001 occurs when the database log file becomes unavailable. When the database log

goes offline that means a serious failure has occurred that prevents transactions to occur in the

database. Such a failure requires the database to restart or for you to restore a backup. The

error shows the end result, but doesn’t explain what led to this state. Some other issue has

caused the log to not be available and you must investigate the underlying issue. Here’s an

example of how the error appears in the SQL error log

Output

Commonly error 9001 occurs together with other errors that provide more specific explanation

about the root cause. Examples include errors

9002

,

3313

,

3314

,

17204

(shows OS error when

accessing a file),

17053

(shows OS error),

ﾉ

Expand table

Error: 9001, Severity: 21, State: 5.
The log for database 'ContosoDb' is not available. Check the operating system error log for related error messages. Resolve any errors and restart the database.