Home » Topic » how to fix error 9001 (“DatabaseName” is not available) ?

how to fix error 9001 (“DatabaseName” is not available) ?

Stephen West ~ Modified: October 6th, 2015 ~ ~ 1 Minute Reading

Home Forums how to fix error 9001 (“DatabaseName” is not available) ?

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #794 Score: 0
    Stephen West
    Moderator
    4 pts

    I am working on SQL Server 2012 and getting this error message

    Event ID: 9001
    The Log for database 'database name' is not available. check the event log for related error message.

    how can i fix this SQL error 9001?

    #800 Score: 0
    Lincoln Burrows
    Moderator
    16 pts

    have you run the DBCC CHECKDB on the database?

    #817 Score: 0
    Stephen West
    Moderator
    4 pts

    Yes I did run the DBCC CHECKDB but it shows the below message:

    CHECKDB found 0 allocation errors and 0 consistency errors in database ‘DB’.
    DBCC execution completed. If DBCC printed error messages, contact your system administrator.

    #825 Score: 0
    Andrew Jackson
    Moderator
    1 pt

    Took the database offline in Management Studio and then immediately brought online, the error will be resolved after this. strange but it works

Viewing 4 posts - 1 through 4 (of 4 total)
  • You must be logged in to reply to this topic.