Home » Blog » 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
  • October 6, 2015 at 11:33 am #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?

    October 7, 2015 at 12:57 pm #800 Score: 0
    Lincoln Burrows
    Moderator
    16 pts

    have you run the DBCC CHECKDB on the database?

    October 8, 2015 at 11:53 am #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.

    October 9, 2015 at 11:02 am #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

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