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.

  • You haven't stated what type of disks your databases are stored on such as a SAN or NAS. We had a similar issue when the iSCSI connection would get interrupted with no failover. SQL Server would notice the database files were inaccessible and mark them in a similar manner that you are describing.
    – user113230
    Jul 29 '13 at 14:08
  • Good point and thanks for the info. I updated, we are on a SAN.
    – Mark
    Jul 29 '13 at 14:14
  • What tchester said. I've observed similar behavior with disk IO issues. Jul 29 '13 at 14:35

Your SAN probably has more than one RAID controller module. Typically when you create a virtual disk it will assign it to a preferred controller. If that controller becomes overloaded with IO requests, your virtual disk can be moved over to the non-preferred controller.

When this occurs SQL Server which is talking to the preferred RAID controller from host's iSCSI connection will notice that the database files are no longer accessible and take them "offline". This can also occur if the preferred RAID controller goes offline for other reasons.

To work around this problem you should configure an additional iSCSI connection/logon to the secondary RAID controller.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.