Sql Server database logs "missing"

Posted by linkerro on Server Fault See other posts from Server Fault or by linkerro
Published on 2012-09-27T08:52:18Z Indexed on 2012/09/27 9:39 UTC
Read the original article Hit count: 417

Here's the problem we're having:

In the applications that are using the databases we get errors like:

The log for database 'redactedDatabaseName' is not available. Check the event log for related error messages. Resolve any errors and restart the database.
Cannot close event log because there are still event handle users active.

The server log says this:

Error: 9001, Severity: 21, State: 1.

Context:

The server in question is holding databases for a multi-tenant application and lately it's been under quite heavy loads.

It has something like 3k small databases on it and these errors have been coming in the last week.

We have a work-around right now, which is taking the database offline then bringing it online again.

Any ideas why this is happening and how we can fix it?

© Server Fault or respective owner

Related posts about sql-server

Related posts about windows-server-2008-r2