Thursday, March 5, 2015

Error: "The log for database "x" is not available. Check the event log for related error messages. Resolve any errors and restart the database."

The log for database "x" is not available. Check the event log for related error messages. Resolve any errors and restart the database.

To resolve, follow these steps:

  • Take the database offline.
  • Bring it back online.
  • Run DBCC checkdb to make sure everything is good.
  • Set Auto Close = False.

No comments:

Post a Comment