Every day I notice several of my project DBs on SQL 2008 R2 (v.
10.50.2500) get into a limbo state where they are unavailable. They're not technically offline in this case. In Management Studio, there's no plus sign next to them to expand them, and when I right click > Properties I just get a single "General" pane with all data grayed out, with many properties just saying Unavailable.
We've found that we can correct this by going to Tasks > Take Offline then going back to Tasks > Bring Online
What could be causing this issue? Incorrect settings at the SQL server level?
Our SQL DB server runs on Windows Server 2008 R2 and the drives storing the DBs are on a SAN.