Colin Phillips (Alumni)
I recently ran into an issue at a client site where one of their content DB’s was in an “Error” state (Database Status).
The Database name below was found to be in “Error”
The simple resolution to this was to click on the database name in question, and in the dialog that opens, simply click on the “OK” button. Once you do that, that database will return to the database status of “Started”.
This topic is discussed further in the following forum post: https://social.technet.microsoft.com/Forums/office/en-US/f1aab4bc-2687-424c-9051-47621d0aee4f/content-database-status-error-in-sharepoint-2010-central-administration?forum=sharepointadminprevious