Content Database Status Error in SharePoint 2010 Central Administration

In  SharePoint 2010 environment, I have number of content databases in a web application, I found one of my content database showing error under the database status column in manage content database section in central administration, rest of them all are showing status started.

Resolution:

I clicked on content database and hit ok without changing anything and status became –Started.

I just wanted to check the content database status in SQL server database,

I used this below query to check the Content DB status,

SELECT DB_NAME() AS DatabaseName, DATABASEPROPERTYEX('Specify database name', 'Status') AS DBStatus